Problem Note 59023: Using the GET_QUERYVAL function generates incorrect results
The GET_QUERYVAL function, which is used in SAS® High-Performance Risk and SAS® Risk Dimensions®, might generate incorrect results. The issue occurs due to a problem with the variable indexing. As a result, the computed column values that appear in the output data set and through user interface exploration might be incorrect. There are no warnings or errors.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| SAS System | SAS High-Performance Risk | Microsoft® Windows® for x64 | 3.5 | 3.6 | 9.4 TS1M3 | 9.4 TS1M3 |
| 64-bit Enabled AIX | 3.5 | 3.6 | 9.4 TS1M3 | 9.4 TS1M3 |
| 64-bit Enabled Solaris | 3.5 | 3.6 | 9.4 TS1M3 | 9.4 TS1M3 |
| Linux for x64 | 3.5 | 3.6 | 9.4 TS1M3 | 9.4 TS1M3 |
| Solaris for x64 | 3.5 | 3.6 | 9.4 TS1M3 | 9.4 TS1M3 |
*
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.
The parse-time function for GET_QUERYVAL falsely assumes that _VALUE_ output
variable is in slot 1 in the gen->allOutputVars list. The code is incorrectly
changing the output variable index, which throws off the offset
calculation.
| Type: | Problem Note |
| Priority: | high |
| Topic: | Analytics ==> Financial Analysis
|
| Date Modified: | 2020-02-25 16:35:19 |
| Date Created: | 2016-09-21 14:01:15 |
