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;
This file that you reference is an EXCEL file, and the tab you are trying to access, PARKS, doesn't exist.
This file that you reference is an EXCEL file, and the tab you are trying to access, PARKS, doesn't exist.
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.
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').
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!