topic Re: Unable to View SAS Datasets in SAS Library in SAS Programming

Unable to View SAS Datasets in SAS Library

yli33 — Fri, 16 Nov 2018 17:36:20 GMT

Hi,

I have encountered a rather odd issue regarding attempting to view the SAS datasets in SAS 9.4 after creating a SAS library. Specifically, I do not see any of the SAS datasets within my first folder when I created a new library in SAS. In other words, I am only able to view the datasets located in the second folder upon assigning it to the same SAS library. Please find below an example of the SAS code that I have used to create the SAS library:

LIBNAME XXXXXX 'FIRST FOLDER PATHNAME';

options validvarname=any;

LIBNAME XXXXXX 'SECOND FOLDER PATHNAME';
options validvarname=any;

Therefore, I would greatly appreciate it if someone could provide a potential solution to this issue. Thanks in advance!

Re: Unable to View SAS Datasets in SAS Library

SuryaKiran — Fri, 16 Nov 2018 17:41:31 GMT

What does the log say when you run your first libname, Is it assigned successfully?

Re: Unable to View SAS Datasets in SAS Library

Kurt_Bremser — Fri, 16 Nov 2018 17:43:01 GMT

If you want to see the contents of more than one directory in one SAS library, google "sas concatenated library".

Re: Unable to View SAS Datasets in SAS Library

yli33 — Fri, 16 Nov 2018 17:51:17 GMT

Hi Suryakiran,

So, I have just tried to run each SAS code separately instead of both codes simultaneously. When I ran the first set of SAS codes, I am able to see all of the SAS datasets from my first folder within the SAS library. However, when I ran the second set of SAS codes, the datasets from the second folder overrode those from the first folder. Perhaps I should create two different libraries?

Re: Unable to View SAS Datasets in SAS Library

yli33 — Fri, 16 Nov 2018 17:53:31 GMT

Hi,

Thank you for suggesting the "sas concatenated library" as an alternative solution to the SAS issue. I will definitely google the specific details involved in this procedure.

Re: Unable to View SAS Datasets in SAS Library

Kurt_Bremser — Fri, 16 Nov 2018 18:06:28 GMT

The second libname re-assigns the library definition; it does not append the second to the first. For that you need concatenated libraries.

Or you use two separate libraries.

Re: Unable to View SAS Datasets in SAS Library

yli33 — Fri, 16 Nov 2018 18:18:55 GMT

Hi,

Thank you so much for clarifying the root cause of my SAS issue. I have already concatenated the two folders into a single library and was able to view all datasets located in both folders. Thanks again!