BookmarkSubscribeRSS Feed
BigZ
Calcite | Level 5
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
2 REPLIES 2
Florent
Quartz | Level 8
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
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
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.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 710 views
  • 0 likes
  • 3 in conversation