Help using Base SAS procedures

One lib from two different libs

Reply
Occasional Contributor
Posts: 13

One lib from two different libs

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
Frequent Contributor
Posts: 127

Re: One lib from two different libs

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
Super Contributor
Super Contributor
Posts: 3,174

Re: One lib from two different libs

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.
Ask a Question
Discussion stats
  • 2 replies
  • 123 views
  • 0 likes
  • 3 in conversation