SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 53667: Dynamic treatments that use custom detail tags do not remove blank values when you export to a file or database table

DetailsHotfixAboutRate It

Dynamic treatments that use custom detail tags in SAS® Customer Intelligence Studio do not remove trailing blanks when you export to a file or database table.

The following example output demonstrates the behavior:

"AGE"	"TAG_ELEMENT1_PACKTAG"	"TAG_ELEMENT2_PACKTAG"	"TAG_ELEMENT_3_PACKTAG"
56	"CC        ,CC"	"CC        ,DM"	"CC        ,EM"
62	"CC        ,CC"	"DM        ,CC"	"EM        ,CC"

As you can see, there are blanks between the values. These blanks are added because the exported file fills in blanks until the field length that is defined in the dynamic list is reached.

The expected behavior is that the blanks are trimmed so that the output looks like the following example:

"AGE"	"TAG_ELEMENT1_PACKTAG"	"TAG_ELEMENT2_PACKTAG"	"TAG_ELEMENT_3_PACKTAG"
56	"CC,CC"         	"CC,DM"         	"CC,EM"
62	"CC,CC"	                "DM,CC"         	"EM,CC"

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 Core Mid-TierMicrosoft® Windows® for x646.1_M16.49.4 TS1M0
64-bit Enabled AIX6.1_M16.49.4 TS1M0
64-bit Enabled Solaris6.1_M16.49.4 TS1M0
HP-UX IPF6.1_M16.49.4 TS1M0
Linux for x646.1_M16.49.4 TS1M0
Solaris for x646.1_M16.49.4 TS1M0
* 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.