topic Re: One lib from two different libs in SAS Procedures

One lib from two different libs

BigZ — Fri, 19 Feb 2010 21:57:20 GMT

Hi there.
I am attempting to create single Lib from 2 different libs in my autoexec file
Here is what I have:

libname lib1 odbc
DATASRC=server
USER=userID
PASSWORD="&dbpass"
readbuff=1000
schema='dbo'
;

libname lib2 odbc
DATASRC=server
USER=userID
PASSWORD="&dbpass"
readbuff=1000
schema='Floro'
;
libname lib3 (lib1 lib2);

So what I want to do is to only have lib3 in my explorer window. Right now I am getting all 3 libs displayed. But I want only lib3 to be displayed.

Thanks

Re: One lib from two different libs

Florent — Tue, 16 Mar 2010 11:27:19 GMT

Hello,

Have you already tried to clear the lib1 and lib2 after having created the lib3 ?

libname lib1 clear;
libname lib2 clear;

Kind regards,
Florent

Re: One lib from two different libs

sbb — Tue, 16 Mar 2010 11:33:54 GMT

Yes - the OP posted a reply in a different FORUM - see link below:

http://support.sas.com/forums/message.jspa?messageID=32511

Scott Barry
SBBWorks, Inc.