Write and run SAS programs in your web browser

How do I open a sas dataset uploaded in SAS Studio University Edition

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 17
Accepted Solution

How do I open a sas dataset uploaded in SAS Studio University Edition

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


Accepted Solutions
Solution
2 weeks ago
Super User
Super User
Posts: 6,718

Re: How do I open a sas dataset uploaded in SAS Studio University Edition

[ Edited ]

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


All Replies
Super User
Posts: 18,603

Re: How do I open a sas dataset uploaded in SAS Studio University Edition

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.

 

Occasional Contributor
Posts: 17

Re: How do I open a sas dataset uploaded in SAS Studio University Edition

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

 

Super User
Posts: 18,603

Re: How do I open a sas dataset uploaded in SAS Studio University Edition

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?

Occasional Contributor
Posts: 17

Re: How do I open a sas dataset uploaded in SAS Studio University Edition

Windows for both.

 

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

Error for the above code attached.error_log1.png

Super User
Posts: 18,603

Re: How do I open a sas dataset uploaded in SAS Studio University Edition

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.

Occasional Contributor
Posts: 17

Re: How do I open a sas dataset uploaded in SAS Studio University Edition

Reeza

 

I will try the xport option and confirm.

Solution
2 weeks ago
Super User
Super User
Posts: 6,718

Re: How do I open a sas dataset uploaded in SAS Studio University Edition

[ Edited ]

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.

Occasional Contributor
Posts: 17

Re: How do I open a sas dataset uploaded in SAS Studio University Edition

Hi Tom,

 

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

 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 8 replies
  • 172 views
  • 6 likes
  • 3 in conversation