A diagram returns zero counts in Split output cells when you use values from a data item of type DATE or of type TIMESTAMP.

Consider the following example of a Split node. In this example, the data item Expiration_Date is selected.

When you run the diagram, the two output cells from the Split node have zero counts.

In order for SAS^® Marketing Automation to properly process dates, the application must know whether the real column is of type DATE or of type TIMESTAMP. You indicate this through the Expression Type property of the data item in the information map

Note that the Expression Type property is the the type of the input expression that is used for the data item. It is not the type of the formatted output.

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

Workarounds

If you receive zero counts for a Split node where the date column is of type DATE, you can follow the steps below as a workaround to fixing the information map. However, if the column is of type TIMESTAMP, you must apply the hot fix first, and then perform the following steps to fix the information map:

1. First, determine whether the underlying column type is DATE or TIMESTAMP, as follows:
1. Log on to SAS^® Management Conosle and navigate to the Data Library Manager plug-in.
2. In the plug-in, left-click your to display a list of registered metadata tables.
3. Right-click the table that contains your target column and select Properties from the list that appears.
4. Click the Columns tab and locate your target column.
5. Scroll to the right on this tab and check the value for the Informat field. That value is the target column type. For example, if the value in the field is DateTime, the column if of type TIMESTAMP. If the value is Date, then the type is DATE.
2. Next, log on to SAS^® Information Map Studio and browse to your target information map.
3. Highlight the date item with which you have a problem and perform the following steps, dependent on which release of the SAS^® System you have:
   • SAS 9.1.3
   1. Double-click the data item to open it. Then click Edit
   2. Make sure that the appropriate data type (either DATE or TIMESTAMP) appears in the editor. If it is not correct, change the value to the correct data type.
   • SAS 9.2
     1. Single-click the data item to open the Properties pane, as shown in the following display:
        
        

        

        
        

        Note: If the Properties pane is not visible, you should see a box that contains << in it. Click that box, and the Properties pane should become visible.

     2. Examine the Expression Type property in the Properties pane to ensure that it has the appropriate data type. If the type is not correct, click the Properties pane to display the expression editor, where you can correct the data type if necessary.
   
   
   

   Operating System and Release Information

   Product Family	Product	System	Product Release		SAS Release
   			Reported	Fixed*	Reported	Fixed*
   SAS System	SAS Customer Intelligence Utilities	Microsoft® Windows® for x64	5.3_M3	5.4	9.2 TS2M3	9.2 TS2M3
   		Microsoft Windows Server 2003 Datacenter Edition	5.3_M3	5.4	9.2 TS2M3	9.2 TS2M3
   		Microsoft Windows Server 2003 Enterprise Edition	5.3_M3	5.4	9.2 TS2M3	9.2 TS2M3
   		Microsoft Windows Server 2003 Standard Edition	5.3_M3	5.4	9.2 TS2M3	9.2 TS2M3
   		Microsoft Windows Server 2003 for x64	5.3_M3	5.4	9.2 TS2M3	9.2 TS2M3
   		Microsoft Windows Server 2008	5.3_M3	5.4	9.2 TS2M3	9.2 TS2M3
   		Microsoft Windows Server 2008 for x64	5.3_M3	5.4	9.2 TS2M3	9.2 TS2M3
   		Microsoft Windows XP Professional	5.3_M3	5.4	9.2 TS2M3	9.2 TS2M3
   		Windows 7 Enterprise 32 bit	5.3_M3	5.4	9.2 TS2M3	9.2 TS2M3
   		Windows 7 Enterprise x64	5.3_M3	5.4	9.2 TS2M3	9.2 TS2M3
   		Windows 7 Home Premium 32 bit	5.3_M3	5.4	9.2 TS2M3	9.2 TS2M3
   		Windows 7 Home Premium x64	5.3_M3	5.4	9.2 TS2M3	9.2 TS2M3
   		Windows 7 Professional 32 bit	5.3_M3	5.4	9.2 TS2M3	9.2 TS2M3
   		Windows 7 Professional x64	5.3_M3	5.4	9.2 TS2M3	9.2 TS2M3
   		Windows 7 Ultimate 32 bit	5.3_M3	5.4	9.2 TS2M3	9.2 TS2M3
   		Windows 7 Ultimate x64	5.3_M3	5.4	9.2 TS2M3	9.2 TS2M3
   		Windows Vista	5.3_M3	5.4	9.2 TS2M3	9.2 TS2M3
   		Windows Vista for x64	5.3_M3	5.4	9.2 TS2M3	9.2 TS2M3
   		64-bit Enabled AIX	5.3_M3	5.4	9.2 TS2M3	9.2 TS2M3
   		64-bit Enabled Solaris	5.3_M3	5.4	9.2 TS2M3	9.2 TS2M3
   		HP-UX IPF	5.3_M3	5.4	9.2 TS2M3	9.2 TS2M3
   		Linux for x64	5.3_M3	5.4	9.2 TS2M3	9.2 TS2M3
   		Solaris for x64	5.3_M3	5.4	9.2 TS2M3	9.2 TS2M3

   * 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.

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

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