topic Re: Anyone can help me for the following SAS error? ERROR: File NP. parks. DATA does not exist. in New SAS User

Anyone can help me for the following SAS error? ERROR: File NP. parks. DATA does not exist.

Alexo2025 — Tue, 13 Dec 2022 16:15:38 GMT

LIBNAME NP XLSX "S:/EPG1V2/data/np_info.xlsx";
run;

options validvarname=v7;
proc contents data=np.parks;
run;
libname np clear;

Re: Anyone can help me for the following SAS error? ERROR: File NP. parks. DATA does not exist.

PaigeMiller — Tue, 13 Dec 2022 16:18:17 GMT

If it says DATA does not exist, then the data set you are looking for does not exist. Perhaps you have spelled the name wrong, or you have the wrong LIBNAME statement.

From now on, when you have an error in the log, please show us the ENTIRE log for that PROC or for that DATA step. We need to see the ENTIRE log, not selected parts, not the parts you want to show us, all of it, every single line, for that PROC or DATA step.

Re: Anyone can help me for the following SAS error? ERROR: File NP. parks. DATA does not exist.

Alexo2025 — Tue, 13 Dec 2022 16:27:06 GMT

Thank you for your immediate response.
Okay. I will show the LOG.

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
72
73 LIBNAME NP XLSX "S:/EPG1V2/data/np_info.xlsx";
NOTE: Libref NP was successfully assigned as follows:
Engine: XLSX
Physical Name: S:/EPG1V2/data/np_info.xlsx
74 run;
75
76 options validvarname=v7;
77 proc contents data=np.parks;
ERROR: File NP.parks.DATA does not exist.
78 run;

Re: Anyone can help me for the following SAS error? ERROR: File NP. parks. DATA does not exist.

john_mccall — Tue, 13 Dec 2022 16:27:49 GMT

Hi. Do you have the correct path? For example, you are referencing the S drive.

I tried running your program and it worked okay referencing the file on my local drive. If your path is correct, can you share the full SAS log?

Thanks.

Re: Anyone can help me for the following SAS error? ERROR: File NP. parks. DATA does not exist.

john_mccall — Tue, 13 Dec 2022 16:30:48 GMT

Your Libname statement looks fine per the SAS log notes. I suggest opening the workbook and verifying the name Parks hasn't been inadvertently over written.

Re: Anyone can help me for the following SAS error? ERROR: File NP. parks. DATA does not exist.

Tom — Tue, 13 Dec 2022 17:00:13 GMT

Just because the LIBNAME statement works it does not mean that the XLSX file exists. SAS does not know when you run the LIBNAME statement if your intent was to read from an existing workbook or make a new one.

And even if the XLSX file does exists that does not mean that there is necessarily a sheet in it named PARKS.

Re: Anyone can help me for the following SAS error? ERROR: File NP. parks. DATA does not exist.

Alexo2025 — Sun, 01 Jan 2023 06:29:47 GMT

Yes, a lot thanks!

Re: Anyone can help me for the following SAS error? ERROR: File NP. parks. DATA does not exist.

Alexo2025 — Sun, 01 Jan 2023 06:31:23 GMT

Yes, many thanks!