BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
krisraa
Quartz | Level 8

Hi Moderators,

 

I'm using sas studio UE and trying to upload sas datasets in sas studio UE.

 

Though the files are loaded successfully but when I try to open the sas data set I'm getting the below error.

 

File _TEMP7.EN.DATA does not exist.

 

as an example.

 

Any advise / help will be appreciated.

 

Regards

Ramnath

1 ACCEPTED SOLUTION

Accepted Solutions
Tom
Super User Tom
Super User

You cannot use uppercase letters in the name of the physical file that stores the SAS dataset on a Unix machine. Unix is case sensitive so AE.sas7bdat and ae.sas7bdat are two different files.  SAS will look for the file with the lowercase letters.

image.png

Just rename the file and you should be able to read it.

View solution in original post

8 REPLIES 8
Reeza
Super User

It can be case sensitive. Can you post the full code and log you tried, as well as include a screenshot of the file in the myfolders pane.

 

krisraa
Quartz | Level 8

Hi Reeza

 

Thanks for the help.

 

I haven't wrote any code, just tried to open the dataset AE (screenshot attached) and it throws the error.

 

Note: The same dataset I can open in SAS EG without issue.

error_SasStudioUE.png

 

Reeza
Super User

What's the OS in EG? Windows or UNIX? I suspect it's that type of issue.

 

What happens when you do try to access the file via code?

krisraa
Quartz | Level 8

Windows for both.

 

libname ADAM0001 '/folders/myfolders/ADAM0001';
Data AE_New;
set ADAM0001.AE;
run;

Error for the above code attached.error_log1.png

Reeza
Super User

If you can try using an XPORT file instead of SAS7BDAT file. 

 

You can also try reinstalling, and are you by chance using SAS UE with a different language browser?

 

You can also search in the Analytics U forum. This has happened before, but I can't remember the fix or what the issue is. I'm 99% certain re-installing and file location were possible issues.

krisraa
Quartz | Level 8

Reeza

 

I will try the xport option and confirm.

Tom
Super User Tom
Super User

You cannot use uppercase letters in the name of the physical file that stores the SAS dataset on a Unix machine. Unix is case sensitive so AE.sas7bdat and ae.sas7bdat are two different files.  SAS will look for the file with the lowercase letters.

image.png

Just rename the file and you should be able to read it.

krisraa
Quartz | Level 8

Hi Tom,

 

Great Thanks! it worked after renaming the file to lower case.

 

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!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

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
  • 8 replies
  • 3972 views
  • 6 likes
  • 3 in conversation