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

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

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

An 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