topic Re: help np file unattainable in SAS Software for Learning Community

help np file unattainable

Landon2 — Tue, 30 Jan 2024 16:23:39 GMT

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;

Re: help np file unattainable

PaigeMiller — Tue, 30 Jan 2024 16:27:34 GMT

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

Re: help np file unattainable

tom_grant — Tue, 30 Jan 2024 17:55:09 GMT

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.

Re: help np file unattainable

tom_grant — Tue, 30 Jan 2024 18:03:15 GMT

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

Re: help np file unattainable

Landon2 — Wed, 31 Jan 2024 16:57:17 GMT

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

Re: help np file unattainable

tom_grant — Wed, 31 Jan 2024 17:22:49 GMT

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

Re: help np file unattainable

obiobi — Thu, 12 Dec 2024 18:38:38 GMT

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.

Re: help np file unattainable

Rachel_McLawhon — Thu, 12 Dec 2024 18:58:03 GMT

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!

Re: help np file unattainable

obiobi — Thu, 12 Dec 2024 19:00:05 GMT

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.

Re: help np file unattainable

obiobi — Thu, 12 Dec 2024 19:01:51 GMT

Re: help np file unattainable

obiobi — Thu, 12 Dec 2024 19:03:07 GMT

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

Thanks.

Re: help np file unattainable

obiobi — Thu, 12 Dec 2024 19:06:06 GMT

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.

Re: help np file unattainable

JackieJ_SAS — Thu, 12 Dec 2024 20:03:41 GMT

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:

Re: help np file unattainable

hollandnumerics — Thu, 12 Dec 2024 21:27:53 GMT

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;

Re: help np file unattainable

obiobi — Fri, 13 Dec 2024 01:57:48 GMT

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

Re: help np file unattainable

hollandnumerics — Fri, 10 Jan 2025 12:26:21 GMT

Please could you add a link to that 2019 post, so that others can benefit from that information?