PROC SQL - FROM clause question

[boilerbujddy]

Looking into creating subfolders in our libraries to help organize our info better.  In the FROM clause of a SELECT statement, we reference data sets using <library name>.<dataset name>.  Is there a way to reference a subfolder under a library?  For example, say we have a subfolder named "Company" under a library.  I don't think <library name>.Company.<dataset name> works.  Thanks in advance. 

Note we are using Enterprise Guide  7.15 HF6

[Kurt_Bremser]

SAS libraries are one level only. You can't have a library within a library.

So if you have

saspath
    libraries
        lib1
            lib2

in your directory structure, you have to do

libname lib2 '/saspath/libraries/lib1/lib2';

and use

lib2.dataset

but you can't address lib2 by simply assigning lib1:

libname lib1 '/saspath/libraries/lib1';

and then use

lib1.lib2.dataset

in your code.

[boilerbujddy · Accepted solution]

That worked perfectly, thank you!

[novinosrin]

Hi @boilerbujddy   You missed to mark @Kurt_Bremser  solution .  Request you to kindly change so that viewers can find the solution at ease during their search.