In SAS Customer Intelligence Studio, numeric missing values in campaign and communication custom details are changed to character fields when the details are exported.

This problem happens when you perform steps similar to the following:

1. Create a selection-campaign definition and a communication definition with a numeric custom detail that is populated by a dynamic list.
2. Ensure that the dynamic list contains some missing (.) numeric values.
3. Create a campaign using the definition that you created previously.
4. Select the missing values in the custom detail.
5. Export both custom details to a file such as a SAS data set. When you export the custom details, you will see that the numeric fields are converted to character values (in this case Dot) for the missing values.

   

Only missing values for the campaign and communication custom details are converted to character values. When you export nonmissing values for the custom details, the numeric format type is maintained.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for this issue for SAS Marketing Automation 6.4 is available at: