Problem Note 58569: Loading a table into the SAS® LASR™ Analytic Server might fail if a column name is "1" or "2"
 |  |  |  |  |  |
When you attempt to load a table into the SAS LASR Analytic Server, if a table column name is defined as "1" or "2," you might see an error similar to the following in the SAS log:
77 data lasrlib.tbl_n;
78 set tbl_work;
79 run;
NOTE: There were 1 observations read from the data set WORK.TBL_WORK.
NOTE: The data set LASRLIB.TBL_N has 1 observations and 2 variables.
ERROR:
NOTE: DATA statement used (Total process time):
real time 0.71 seconds
cpu time 0.04 seconds
Click the Full Code tab in this SAS Note to see an example of code that produces the error above.
To work around this problem, change the column names to "3," "4," or a higher value.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Visual Analytics | Microsoft® Windows® for x64 | 7.3 | 7.3 | 9.4 TS1M3 | 9.4 TS1M3 |
| Linux for x64 | 7.3 | 7.3 | 9.4 TS1M3 | 9.4 TS1M3 | ||
Modify the LIBNAME statement to match your environment setting before submitting the code.
option VALIDVARNAME=ANY;
libname lasrlib sasiola port=10031 host="localhost" startserver=yes;
data tbl_work;
'1'n=1;
'2'n=2;
run;
data lasrlib.foo;
set tbl_work;
run;
A fix for this issue for SAS Compiler and Symbolic Differentiator 9.41_M2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/W01.html#58569A fix for this issue for SAS Thread-safe Compiler and Symbolic Differentiator 9.41_M2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/W02.html#58569| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2016-08-11 16:09:41 |
| Date Created: | 2016-07-08 08:29:53 |