Problem Note 65856: The process of updating a lookup table in SASĀ® Business Rules Manager (running in UNIX operating environments) does not work properly
Under UNIX, the process of updating a lookup table in SAS Business Rules Manager does not work properly. The problem occurs when you perform these steps:
- Open a lookup table.
- Click Import to update the lookup table with a CSV file that is created on a Microsoft Windows machine.
When you open the table, it looks correct. However, the value contains an invalid character (\r) that does not appear on the display. You see the issue only when you run a rule flow test that uses this lookup table.
The corresponding SAS log for the test does not contain any error. However, if the Value field is a numeric field, the SAS log contains a note similar to the following note:
NOTE: Invalid numeric data, '1.' , at line 310 column 2
If the Value field is a character field, the SAS log does not contain anything special.
To work around this issue, you need to use the SAS macro %BRM_IMPORT_LOOKUP to import the CSV file.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SAS System | SAS Business Rules Manager | 64-bit Enabled AIX | 3.3 | | 9.4 TS1M6 | 9.4 TS1M6 |
64-bit Enabled Solaris | 3.3 | | 9.4 TS1M6 | 9.4 TS1M6 |
HP-UX IPF | 3.3 | | 9.4 TS1M6 | 9.4 TS1M6 |
Linux for x64 | 3.3 | | 9.4 TS1M6 | 9.4 TS1M6 |
Solaris for x64 | 3.3 | | 9.4 TS1M6 | 9.4 TS1M6 |
*
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.
Type: | Problem Note |
Priority: | alert |
Date Modified: | 2021-07-14 07:45:53 |
Date Created: | 2020-04-16 08:28:27 |