topic Re: Unable to open a SAS dataset from a library in SAS Programming

Unable to open a SAS dataset from a library

rakeshvvv — Thu, 19 Apr 2018 19:15:23 GMT

Hi All,

Can some one help me below issue.

I am able to open all data sets except for two data sets in my library. All are upcased dataset names and cannot be changed. Any thoughts on how to open dataset in library. I am able open the datasets in the location but not using libname.

Re: Unable to open a SAS dataset from a library

JeffMeyers — Thu, 19 Apr 2018 19:22:03 GMT

A couple of thoughts.

How long are the dataset names? If they are too long (>32 characters) then I don't think the explorer can show them.

Are the datasets from a different operating system than you are currently working on? When I get transferred data sometimes it is created in PC SAS where I am using Linux SAS. I have to go into PC SAS to convert the dataset to a transport file and then unzip it within Linux SAS to be able to see it in my explorer and use it.

Re: Unable to open a SAS dataset from a library

Shmuel — Thu, 19 Apr 2018 19:25:18 GMT

Are you sure that the two datasets are sas datasets?

Do you get any message in the log ? maybe they are damaged?

run next code and post the log;

data test; set <lib.dsname>; run;

Re: Unable to open a SAS dataset from a library

Kurt_Bremser — Thu, 19 Apr 2018 19:25:28 GMT

Please show the logs of successes and failures. And make sure that the names of the files are all lowercase if you're working on UNIX.

Re: Unable to open a SAS dataset from a library

rakeshvvv — Thu, 19 Apr 2018 19:50:47 GMT

Please find the below log.

GOPTIONS ACCESSIBLE;
26 data x;
27 set old.MRI_JUL30;
ERROR: File OLD.MRI_JUL30.DATA does not exist.
28 run;

Re: Unable to open a SAS dataset from a library

ballardw — Thu, 19 Apr 2018 20:47:07 GMT

Can you see OLD.MRI_JUL30.DATA in the SAS explorer data set list? If so and you click on it what happens?

Lower case L   l
may look a lot like upper case "i" in some fonts

Re: Unable to open a SAS dataset from a library

SuryaKiran — Thu, 19 Apr 2018 21:14:58 GMT

PROC SQL;
select distinct memname 
from dictionary.tables 
where libname="<Your Library Name in UPCASE>"
;
quit;

Run this query and check if the tables exists or not, if they exist then @ballardw might be right.

Re: Unable to open a SAS dataset from a library

Kurt_Bremser — Fri, 20 Apr 2018 05:32:33 GMT

@rakeshvvv wrote:

Please find the below log.

GOPTIONS ACCESSIBLE;
26 data x;
27 set old.MRI_JUL30;
ERROR: File OLD.MRI_JUL30.DATA does not exist.
28 run;

This means that no file

mri_jul30.sas7bdat

exists in the directory to which the libname for library OLD points.