BookmarkSubscribeRSS Feed
rakeshvvv
Quartz | Level 8

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.

 

 

7 REPLIES 7
JeffMeyers
Barite | Level 11

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.

 

Shmuel
Garnet | Level 18

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;

rakeshvvv
Quartz | Level 8

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;

ballardw
Super User

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
Kurt_Bremser
Super User

@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.

SuryaKiran
Meteorite | Level 14
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.

Thanks,
Suryakiran

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 7 replies
  • 1091 views
  • 0 likes
  • 6 in conversation