Desktop productivity for business analysts and programmers

Creating single Lib

Reply
Occasional Contributor
Posts: 13

Creating single Lib

Hi there.
I am atmpting 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 whant to do is to only have lib3 in my explorer window. Right now I am geting all 3 libs displayed. But I want only lib3 to be desplayed.

Thanks
Super Contributor
Super Contributor
Posts: 3,174

Re: Creating single Lib

Forum etiquette suggestion: Duplicate posts in more than one forum is not necessary.

Regarding your question, my attempt at this task required a manual delete from the SAS Explorer Window.

Scott Barry
SBBWorks, Inc.
SAS Employee
Posts: 149

Re: Creating single Lib

Hmm, EG is really designed to show you everything. You could try assigning lib1 and lib2 in the config file instead (syntax is a bit different from an autoexec). By default, they won't show up on the server list until the data is accessed... but I think that would happen as soon as you start using files from the concatenated library.

Perhaps someone else will have a good suggestion!
Occasional Contributor
Posts: 13

Re: Creating single Lib

FYI
I was able to solve my own problem. Here is my solution to the problem. I am posting it so that others can use it if they need it.

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);

libname lib1 clear;
libname lib2 clear;
Ask a Question
Discussion stats
  • 3 replies
  • 113 views
  • 0 likes
  • 3 in conversation