topic Re: Create a library in SAS Programming

Create a library

YTH — Sun, 30 Jun 2019 21:22:19 GMT

I am taking SAS programming 1, in the lesson 2, in the activity of Accessing Data Through Libraries ask us to create a library named NP, I followed the instruction, but I cannot find the NP library in the list of libraries. Is anything wrong in my code and how to access the library that you created?

Code: libname NP xlsx "/folders/myfolders/EPG194/data/np_info.xlsx";

Re: Create a library

ChrisBrooks — Sun, 30 Jun 2019 21:38:33 GMT

I would check that the path and file name are correct - typically when you assign a library the error comes not when you make the assignment but when you try to use the library. I'm not sure why you are not seeing the library in my libraries but that explains why you haven't seen an error in the log.

Re: Create a library

Cynthia_sas — Sun, 30 Jun 2019 23:01:29 GMT

Hi:
Look under Files and Folders. Then in the EPG194 data folder, look for the NP_INFO.XLSX file. If you see the file, that means your data creation program ran correctly. If you do NOT see the file in your Files and Folders pane, then you need to go back to the beginning and run the program that MAKES the data for the class.

Hope this helps,
Cynthia

Re: Create a library

YTH — Mon, 01 Jul 2019 02:57:00 GMT

Hi Cynthia,

I see the NP_INFO.XLSX file in the EPG194, and the program does run correctly, so there is no warning message in the Log. However, I cannot find the NP in the list of the libraries, which is a weird situation if the data creation ran correctly.

Re: Create a library

YTH — Mon, 01 Jul 2019 03:07:19 GMT

The path and the file name are correct, and I actually don't see any error
in the log, but I cannot find NP in the libraries.

Thanks anyway!

Re: Create a library

andreas_lds — Mon, 01 Jul 2019 05:52:42 GMT

Have you refreshed the library list?

Re: Create a library

Cynthia_sas — Mon, 01 Jul 2019 15:19:56 GMT

Hi:

Here's what I see when I run the LIBNAME code on my OnDemand account:

You should be seeing something similar for your University Edition program.

Cynthia

Re: Create a library

YTH — Mon, 01 Jul 2019 19:19:44 GMT

Instead of just typing libname NP xlsx "/folders/myfolders/EPG194/data/np_info.xlsx";

I added two more statements:

proc contents data=np._all_ nods;

run;

and now I can see the NP in the libraries.

Thank you!