topic Re: proc dataset file does not exist error in New SAS User

proc dataset file does not exist error

supp — Thu, 26 Dec 2019 19:00:35 GMT

In our shop we have a library we use to store datasets that we want to keep longer than our WORK library. I wanted to explore this library a little so I ran this code:

proc datasets lib=<libref>;
    contents data=_ALL_
	     memtype = data;
quit;

I get the following error:

ERROR: File <libref>.<data_set_name>.DATA does not exist.

Any thoughts on what is causing this?

I am using EG on a windows device with SAS running in a grid environment on Linux. SAS v9.4.

Re: proc dataset file does not exist error

novinosrin — Thu, 26 Dec 2019 19:04:25 GMT

Why didn't you mention the library reference name i.e libref in your code that you would have assigned with a libname statement?

Also you could try

proc contents data=libref._all_ nods;

run;

@supp wrote:

In our shop we have a library we use to store datasets that we want to keep longer than our WORK library. I wanted to explore this library a little so I ran this code:
proc datasets lib=<libref>;
    contents data=_ALL_
	     memtype = data;
quit;
I get the following error:

ERROR: File <libref>.<data_set_name>.DATA does not exist.

Any thoughts on what is causing this?

I am using EG on a windows device with SAS running in a grid environment on Linux. SAS v9.4.

Re: proc dataset file does not exist error

supp — Thu, 26 Dec 2019 19:09:45 GMT

My code doesn't have a libname statement. I assume the library must be getting assigned automatically with the way we have our environment set up. I use the library regularly and have created multiple datasets there.

Re: proc dataset file does not exist error

novinosrin — Thu, 26 Dec 2019 19:14:43 GMT

Okay well I think you have stumped me as I am clueless.

Anyways, is it possible for you to run the below and examine the log to see your desired name is in the list?

libname _all_ list;

Re: proc dataset file does not exist error

supp — Thu, 26 Dec 2019 19:14:54 GMT

When I run:

proc contents data=libref._all_ nods;

run;

The program runs but I get no output

When I remove the 'nods' I get the same error message as the original proc datasets program.

Re: proc dataset file does not exist error

supp — Thu, 26 Dec 2019 19:20:09 GMT

When I run:

libname _all_ list;

I can find the library of interest in my log. I don't think it is a problem with the library, but rather the specific data set associated with the file not found error. I don't understand how the proc datasets can identify the data set name and state it doesn't exist?

Re: proc dataset file does not exist error

novinosrin — Thu, 26 Dec 2019 19:21:08 GMT

So what is the name of library of interest?

Re: proc dataset file does not exist error

Kurt_Bremser — Thu, 26 Dec 2019 19:24:27 GMT

One thing I would look for is a .sas7bdat file there where the filename is not all lowercase.

Re: proc dataset file does not exist error

supp — Thu, 26 Dec 2019 19:32:23 GMT

@Kurt_Bremser, I viewed the linux file location using IPSwitch. Indeed the filename ends with a capital "_TEST". Is the capitalization causing my error? Since this isn't my dataset, is there a way to work around this without changing the file name?

Re: proc dataset file does not exist error

Kurt_Bremser — Thu, 26 Dec 2019 19:38:00 GMT

The capitalization is the problem. Rename (or have renamed) the file to lowercase. As long as it is there in its current form, it will cause problems.

Proc datasets goes searching for all files with .sas7bdat, .sas7bvew or .sas7bcat extensions, and then opens those with the usual means/engines, which then fails. SAS data files must be all lowercase, period.

Re: proc dataset file does not exist error

VSPNandury — Tue, 17 Mar 2020 09:39:06 GMT

proc contents data=libref._all_;

run;

The above works for me, and the result window shows details of all the data sets in the library.

However if I use libref._all_nods I'm getting an error stating that librf._all_nods.data does not exist.

Well we need to give a small space after _all_ since nods is an option for the proc statement.

proc contents data=libref._all_ nods;

run;

works just fine.