Problem Note 67523: DS2 procedure code that connects to SAS® Federation Server might ignore the NONOTES option or alter the PUT statement output
 |  |  |  |  |
PROC DS2 code that connects to SAS Federation Server might ignore the NONOTES option or alter PUT statement output to prepend NOTE: before the output.
For example, you encounter this issue when you run the following code. This code should create a result output of eq but the output shows NOTE: eq.
In this code example, the server name, port number, and schema name change based on your configuration:
proc ds2 nolibs noprompt=
"DRIVER=REMTS;SERVER=localhost;PROTOCOL=BRIDGE;PORT=1891;CONOPTS=(DRIVER=DS2;CON
OPTS=(DRIVER=SQL;
CONOPTS=(DRIVER=BASE;CATALOG=BASE;schema=(name=one;primarypath=.))));";
"DRIVER=REMTS;SERVER=localhost;PROTOCOL=BRIDGE;PORT=1891;CONOPTS=(DRIVER=DS2;CON
OPTS=(DRIVER=SQL;
CONOPTS=(DRIVER=BASE;CATALOG=BASE;schema=(name=one;primarypath=.))));";
ds2_options cdump;
data null;
dcl char(10) c[2];
dcl char(10) s;
method init();
s = 'abc';
c[2] = 'abc';
if s = c[2] then put 'eq';
else put 'not eq';
end;
enddata;
run;
quit;
data null;
dcl char(10) c[2];
dcl char(10) s;
method init();
s = 'abc';
c[2] = 'abc';
if s = c[2] then put 'eq';
else put 'not eq';
end;
enddata;
run;
quit;
There is no workaround for this issue.
A hot fix is planed for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Federation Server | Microsoft® Windows® for x64 | 4.4 | 9.4 TS1M7 | 9.4 TS1M7 | |
| 64-bit Enabled AIX | 4.4 | 9.4 TS1M7 | 9.4 TS1M7 | |||
| 64-bit Enabled Solaris | 4.4 | 9.4 TS1M7 | 9.4 TS1M7 | |||
| HP-UX IPF | 4.4 | 9.4 TS1M7 | 9.4 TS1M7 | |||
| Linux for x64 | 4.4 | 9.4 TS1M7 | 9.4 TS1M7 | |||
| Solaris for x64 | 4.4 | 9.4 TS1M7 | 9.4 TS1M7 | |||
A fix for this issue for SAS Threaded Kernel DS2 and FedSQL Language Processors 9.41_M5 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/I9H.html#67523| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2021-03-02 10:06:14 |
| Date Created: | 2021-03-01 17:48:41 |