SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 60451: Incorrect dates are exported when you have multiple treatments with custom date fields that share the same tag

DetailsHotfixAboutRate It

When multiple treatments contain custom date fields that share the same tag, the values are concatenated into a single field when the date fields are referenced in an export definition. However, when the treatment is exported, incorrect dates are displayed.

For example, this problem occurs when you perform steps similar to the following:

  1. Define three treatments (Treatment1, Treatment2, and Treatment3) that contain custom date fields of type Day. The three fields each have the tag TreatmentDate, and they contain the following dates: Feb 1, 2017, Mar 5, 2017, and Apr 12, 2017.
  2. Create a campaign diagram that references these treatments.
  3. Export the TreatmentDate tag.

After you execute the diagram,the TreatmentDate field in the export file should contain these dates:

 '01FEB2017    05MAR2017    12APR2017' 

Instead, you see incorrect dates in the export file, as shown in the following example:

'03JAN1960    24MAY1962    03JAN1960'

This problem occurs only when the separator for treatment values in the environment variables is set to Tab. To work around the problem, set the separator to Comma.

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



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Customer Intelligence ProcessesMicrosoft® Windows® for x646.5
64-bit Enabled AIX6.5
64-bit Enabled Solaris6.5
HP-UX IPF6.5
Linux for x646.5
Solaris for x646.5
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.