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').