topic Re: can I create a library inside one lib? in SAS Programming

can I create a library inside one lib?

kwu — Tue, 28 Sep 2010 16:19:47 GMT

I am on windows. When I create a library (e.g. testlib) and map it to a file directory on the file system (e.g. c:\dir ), the sub directory of c:\dir\subdir does not show up in the sas exploer as the sub lib of testlib. I wonder if there is a way so that I can have the sas explorer shows the same directory structure as the file system?

I only need one level of nesting, at least be able to create a sub lib in a lib.

I tried to
libname testlib.subdir "c:\dir\subdir";

it doesn't work. Any suggestion or work around?

thank you in advance.

Re: can I create a library inside one lib?

Peter_C — Tue, 28 Sep 2010 18:45:10 GMT

There is more than one SAS explorer. In what context are you? EG or old SAS?

Re: can I create a library inside one lib?

kwu — Tue, 28 Sep 2010 19:33:08 GMT

I do not know what EG is even. It is in the base SAS. The version I am using is sas9.2.

Re: can I create a library inside one lib?

art297 — Tue, 28 Sep 2010 19:40:22 GMT

Would assigning the directory to My Favorite Folders suffice?

Re: can I create a library inside one lib?

kwu — Tue, 28 Sep 2010 19:58:17 GMT

How do I use the favorite folders as lib in the sas code?

Re: can I create a library inside one lib?

art297 — Tue, 28 Sep 2010 20:17:52 GMT

Peter is probably more familiar with this topic than I am. I understood that you were simply looking for a way to point-and-click your way to view files within subdirectories.

That said, you could probably combine Favorite Folders with file shortcuts to be able to reference them within your code.

Take a look at: http://support.sas.com/documentation/cdl/en/hostwin/63285/HTML/default/viewer.htm#refextfile.htm
or, in short form: http://xrl.us/bh2uys

Art

Re: can I create a library inside one lib?

kwu — Tue, 28 Sep 2010 20:41:45 GMT

here is what I am trying to do:

we have a datamart which maps to a sas library, now we are partitioning one of the big tables inside the datamart. I hope I can store partitions inside the same sas library but not directly, instead all partitions are stored in a sub library.
is there a way to do so?

Re: can I create a library inside one lib?

art297 — Tue, 28 Sep 2010 20:45:54 GMT

Will concatenating lhe libname to include both suffice?

Art

Re: can I create a library inside one lib?

art297 — Tue, 28 Sep 2010 20:47:40 GMT

If you're not familiar with concatenating libraries take a look at:

http://support.sas.com/documentation/cdl/en/lrcon/62955/HTML/default/viewer.htm#a000933322.htm

Art

Re: can I create a library inside one lib?

kwu — Tue, 28 Sep 2010 21:15:18 GMT

I am aware of the concating lib. It does not really do what I want since the concated lib has all dataset. I do not want to expose the partition datasets in the library.

Re: can I create a library inside one lib?

Reeza — Tue, 28 Sep 2010 22:14:17 GMT

Out of curiousity why not just have two lib statements with a set naming structure to define the two libraries? Yes the character limit is a restriction...

libname orig 'C:\test';
libname origsub 'C:\test\subdir';

If you want to physically view in Explorer use the favorite folders.

Re: can I create a library inside one lib?

Peter_C — Wed, 29 Sep 2010 07:16:22 GMT

> here is what I am trying to do:
>
> we have a datamart which maps to a sas library, now
> we are partitioning one of the big tables inside the
> datamart. I hope I can store partitions inside the
> same sas library but not directly, instead all
> partitions are stored in a sub library.
> is there a way to do so?

Are you seeking to eplore through to the whole data mart as one table instead of partitions?

If so then may I suggest one way and a possible alternative?
Create an SQL view over all partitions in a new library holding only the view.

The alternative would be to create the SAS data mart using a spde library

Re: can I create a library inside one lib?

kwu — Wed, 29 Sep 2010 15:05:56 GMT

thank you very much for all the suggestions. I will just use two libs.

I was expecting to have the lib.sublib.dataset type of structure, which I do not think sas support the nested dot notation thing. 🙂