Effective in the third maintenance release of SAS® 9.4 (TS1M3) with hot fix A1F002, a new LIBS= (alias LIBNAMES=) option enables you to specify the libraries that should be used when you submit PROC DS2 and PROC FEDSQL commands. Prior to this option, all active libraries were used to build connection strings. Only those librefs that are named in this option are loaded from the available active libraries. In the absence of this option, all active LIBNAME statements are loaded. Any libref in the option that does not match a defined LIBNAME statement is ignored. The Work library is implicitly included as the first library in all lists, and it is the default library for data references that do not include a libref.
The syntax for the option follows:
* LIBS =* LIBS = ( ... ) * LIBNAMES = * LIBNAMES = ( ... )
When the MSGLEVEL=I system option is specified, messages are written to the SAS® log indicating which LIBNAME is included or ignored based on the use of the LIBS= option.
Click the Full Code tab to see sample code that illustrates the LIBS= option.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Product Family | Product | System | SAS Release | |
Reported | Fixed* | |||
SAS System | Base SAS | Microsoft Windows Server 2012 Datacenter | 9.4 TS1M3 | 9.4 TS1M4 |
Microsoft Windows 8.1 Enterprise 32-bit | 9.4 TS1M3 | 9.4 TS1M4 | ||
Microsoft Windows 8.1 Enterprise x64 | 9.4 TS1M3 | 9.4 TS1M4 | ||
Microsoft Windows 8.1 Pro | 9.4 TS1M3 | 9.4 TS1M4 | ||
Microsoft Windows 8.1 Pro 32-bit | 9.4 TS1M3 | 9.4 TS1M4 | ||
Microsoft Windows Server 2008 | 9.4 TS1M3 | 9.4 TS1M4 | ||
Microsoft Windows Server 2008 R2 | 9.4 TS1M3 | 9.4 TS1M4 | ||
Microsoft Windows Server 2008 for x64 | 9.4 TS1M3 | 9.4 TS1M4 | ||
Microsoft Windows 8 Pro x64 | 9.4 TS1M3 | 9.4 TS1M4 | ||
Microsoft Windows 8 Pro 32-bit | 9.4 TS1M3 | 9.4 TS1M4 | ||
Microsoft Windows 8 Enterprise x64 | 9.4 TS1M3 | 9.4 TS1M4 | ||
Microsoft Windows 8 Enterprise 32-bit | 9.4 TS1M3 | 9.4 TS1M4 | ||
Microsoft® Windows® for x64 | 9.4 TS1M3 | 9.4 TS1M4 | ||
Z64 | 9.4 TS1M3 | 9.4 TS1M4 | ||
Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.4 TS1M3 | |||
z/OS | 9.4 TS1M3 | 9.4 TS1M4 | ||
Microsoft Windows Server 2012 R2 Datacenter | 9.4 TS1M3 | 9.4 TS1M4 | ||
Microsoft Windows Server 2012 R2 Std | 9.4 TS1M3 | 9.4 TS1M4 | ||
Microsoft Windows Server 2012 Std | 9.4 TS1M3 | 9.4 TS1M4 | ||
Windows 7 Enterprise 32 bit | 9.4 TS1M3 | 9.4 TS1M4 | ||
Windows 7 Enterprise x64 | 9.4 TS1M3 | 9.4 TS1M4 | ||
Windows 7 Home Premium 32 bit | 9.4 TS1M3 | 9.4 TS1M4 | ||
Windows 7 Home Premium x64 | 9.4 TS1M3 | 9.4 TS1M4 | ||
Windows 7 Professional 32 bit | 9.4 TS1M3 | 9.4 TS1M4 | ||
Windows 7 Professional x64 | 9.4 TS1M3 | 9.4 TS1M4 | ||
Windows 7 Ultimate 32 bit | 9.4 TS1M3 | 9.4 TS1M4 | ||
Windows 7 Ultimate x64 | 9.4 TS1M3 | 9.4 TS1M4 | ||
64-bit Enabled AIX | 9.4 TS1M3 | 9.4 TS1M4 | ||
64-bit Enabled HP-UX | 9.4 TS1M3 | 9.4 TS1M4 | ||
64-bit Enabled Solaris | 9.4 TS1M3 | 9.4 TS1M4 | ||
HP-UX IPF | 9.4 TS1M3 | 9.4 TS1M4 | ||
Linux for x64 | 9.4 TS1M3 | 9.4 TS1M4 | ||
Solaris for x64 | 9.4 TS1M3 | 9.4 TS1M4 |
options msglevel=i;
libname base '.';
proc ds2 libs=(base junk1 junk2);
quit;
/* These messages are written to the SAS log */ 3 proc ds2 libs=(base junk1 junk2); NOTE: DS2 Using libname BASE (engine V9) NOTE: DS2 Ignoring libname SASHELP (engine V9); not in LIBS= NOTE: DS2 Ignoring libname MAPS (engine V9); not in LIBS= NOTE: DS2 Ignoring libname MAPSGFK (engine V9); not in LIBS= NOTE: DS2 Ignoring libname SASUSER (engine V9); not in LIBS= NOTE: DS2 Using libname WORK (engine V9) WARNING: No match for these libnames: JUNK1 JUNK2 NOTE: Connection string: NOTE: DRIVER=DS2;CONOPTS= (DRIVER=FEDSQL;CONOPTS= ( (DRIVER=BASE;CATALOG=BASE;SCHEMA= (NAME=BASE;PRIMARYPATH={C:\Users\myuserid})); (DRIVER=BASE;CATALOG=WORK;SCHEMA= (NAME=WORK;PRIMARYPATH={C:\Users\myuserid\AppData\Local\Temp\SAS Temporary Files\_TD8380_D11111_})))) NOTE: Writing HTML Body file: sashtml.htm 4 quit;
A fix for this issue for SAS Threaded Kernel DS2 and FedSQL Language Processors 9.41_M1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/A1F.html#56410Type: | Problem Note |
Priority: | medium |
Topic: | SAS Reference ==> Procedures ==> DS2 |
Date Modified: | 2015-11-05 15:14:39 |
Date Created: | 2015-08-12 11:13:45 |