Problem Note 67702: The %DCM_CONVERT_DATAGRID_TO_TABLE macro does not generate the expected table in SAS® Intelligent Decisioning
 |  |  |  |  |
In SAS Intelligent Decisioning, the %DCM_CONVERT_DATAGRID_TO_TABLE macro converts each row in a data grid to a separate table. When you run the macro, the column's data type in the converted table might not match that of the type of the source table, and the content in the converted table is not the expected results.
In the image below, you can see this issue for the Cars table. In the converted table, columns are not sorted properly, and the data type and content do not match what is in the source table.
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
After you apply the the hot fix, all columns in the converted table are sorted properly in ascending order, and the data type and content matches the source table.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Intelligent Decisioning | Linux for x64 | 5.5 | 5.5 | Viya | Viya |
Viya on Linux: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdates| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2021-05-03 15:53:35 |
| Date Created: | 2021-04-01 10:43:12 |