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

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

krisraa — Mon, 11 Sep 2017 16:33:05 GMT

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

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

Reeza — Mon, 11 Sep 2017 17:11:36 GMT

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.

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

krisraa — Mon, 11 Sep 2017 17:18:51 GMT

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.

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

Reeza — Mon, 11 Sep 2017 17:25:12 GMT

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?

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

krisraa — Mon, 11 Sep 2017 17:51:24 GMT

Windows for both.

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

Error for the above code attached.

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

Reeza — Mon, 11 Sep 2017 17:55:17 GMT

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.

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

Tom — Mon, 11 Sep 2017 18:00:10 GMT

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.

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

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

krisraa — Mon, 11 Sep 2017 18:01:40 GMT

Hi Tom,

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

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

krisraa — Mon, 11 Sep 2017 18:02:31 GMT

Reeza

I will try the xport option and confirm.