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.
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.
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;
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;
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
@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.
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.
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: