topic Creating single Lib in SAS Enterprise Guide

Creating single Lib

BigZ — Fri, 19 Feb 2010 21:18:42 GMT

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

Re: Creating single Lib

sbb — Sat, 20 Feb 2010 15:17:34 GMT

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.

Re: Creating single Lib

RichardH_sas — Sun, 21 Feb 2010 03:10:56 GMT

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!

Re: Creating single Lib

BigZ — Wed, 24 Feb 2010 18:50:49 GMT

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;