topic Re: PROC SQL - FROM clause question in SAS Programming

PROC SQL - FROM clause question

boilerbujddy — Wed, 23 Jan 2019 15:12:03 GMT

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

Re: PROC SQL - FROM clause question

Kurt_Bremser — Wed, 23 Jan 2019 15:21:51 GMT

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.

Re: PROC SQL - FROM clause question

boilerbujddy — Wed, 23 Jan 2019 15:50:57 GMT

That worked perfectly, thank you!

Re: PROC SQL - FROM clause question

novinosrin — Wed, 23 Jan 2019 16:29:33 GMT

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.