help np file unattainable

[Landon2]

the software is showing ERROR: File NP.parks.DATA does not exist. despite the numerous attempts to access NP.parks I don't know if the file does not exist or if the file is somehow unretained do to possible human error, I've been signed up to SAS® OnDemand for Academics and my course code is ba1c035c-9872-4391-973f-ce865df9c9d9

libname data "/home/ncvpssas0/my_content/EPG194/data";
libname np xlsx "/home/ncvpssas0/my_shared_file_links/ncvpssas0/EPG194/data/np_info.xlsx";
proc contents data=np.parks;

run;

[PaigeMiller · Accepted solution]

This file that you reference is an EXCEL file, and the tab you are trying to access, PARKS, doesn't exist.

[tom_grant]

So are you the one that created the course?  I see that in your libname statement:

libname np xlsx "/home/ncvpssas0/my_shared_file_links/ncvpssas0/EPG194/data/np_info.xlsx";

the user id is the same as the course creator (ncvpssas0) 

If you are the course creator - this is correct but if you enrolled in the course, the first id should be your userid.

You can always get the correct path by right-clicking on the folder or file & selecting Properties.

Also, in your first libname statement:

libname data "/home/ncvpssas0/my_content/EPG194/data";

Did you create a subfolder called my_content under your Files(Home) directory?

For the Programming 1 course - we highly suggest that you copy the course directory (EPG194) directly under your Files(Home) directory & then you can use the path macro & libname statement:

%let path=~/EPG194/data;
libname PG1 "&path";

The ~ symbol will default to the user's Files(Home) directory & so this will work for everyone.

One another note:  It looks like you may be using an older version of the Programming 1 class - there is a newer version EPG1V2 - not sure if much changed.

Hope that helps.

[tom_grant]

So the correct libname statement for np_info.xlsx would be:
libname np xlsx "/home/your user id/my_shared_file_links/ncvpssas0/EPG194/data/np_info.xlsx";

where you replace 'your user id' with your actual userid

[Landon2]

how do i update....im quite new to sas

[tom_grant]

So just update the libname statement above with your user id - you can find your user id by clicking on your name in top right on the welcome.oda.sas.com page (usually starts with the a 'u').

[obiobi]

I have the same problem of not being able to find the NP folder after creating it.

This is the code I used below:

libname np xlsx "S:/workshop/EPG1V2/data/np_info.xlsx";

The log syas:

NOTE: Libref NP was successfully assigned as follows:
Engine: XLSX
Physical Name: S:/workshop/EPG1V2/data/np_info.xlsx

However I cannot find the NP folder anywhere on the navigation pane.

[Rachel_McLawhon]

Hello! With the libname statement, you've created a library, which is like a pointer to your data. To see the NP library, go to the Libraries tab on the left side pane. There are some pre-defined libraries, as well as your newly-created NP library!

[obiobi]

Thanks.

The key issue is that there is no folder named LIBRARY at any level on my left navigation pane. I have gone through every single folder and sub folder.

[obiobi]

[obiobi]

I should also state that I am using the virtual lab for the training.

Thanks.

[obiobi]

I have also tried adding my user iD to the file path and I still cannot see the NP library that was created. As such I am stuck.

[JackieJ_SAS]

Hi, Try clicking the "More application options" button in the upper right. It looks like three horizontal lines. Then select "View". Make sure that "Libraries" is checked.

Once it is checked you should see a selection for "Libraries" at the bottom of the set of menus on the left side. For example:

[obiobi]

I found the solution in an old (2019) post and I can now see my libraries
folder.
Thanks.

[hollandnumerics]

Is parks the name of a sheet in that Excel file?
Try using the following code to list ALL of the data sets in NP:

PROC CONTENTS DATA=NP._ALL_;
RUN;