Problem Note 69229: The DATAGRID_GETFIRSTINDEXBYVALUE function fails with the error "Datagrid Column Invalid Type" in SAS® Intelligent Decisioning
 |  |  |  |  |
In SAS Intelligent Decisioning, the DATAGRID_GETFIRSTINDEXBYVALUE function returns the index of the first row that contains the specified value for the column. Moreover, the function returns a zero if the specified value does not exist in the specified column. However, this function does not work as expected when the specified value is null or missing and might fail with the following error:
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
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.6 | Viya | ||
Viya on Windows: 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 Windows Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdatesWinViya 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=softwareUpdatesAn update for this issue is available for SAS Event Stream Processing 6.2. For instructions on how to access and apply this software update see the SAS Event Stream Processing 6.2 Deployment Guide links on
https://tshf.sas.com/techsup/download/hotfix/HF2/Viya_ESP_6_2_home.html#69229| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2024-01-10 16:55:19 |
| Date Created: | 2022-05-25 15:33:35 |