One lib from two different libs

[BigZ]

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

[Florent]

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

[sbb]

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.