topic import an excel file in sas studio in New SAS User

import an excel file in sas studio

bondtk — Sat, 03 Nov 2018 10:31:32 GMT

I have imported an excel file with this code. it worked fine. I am using sas studio.

PROC IMPORT DATAFILE = '/folders/myfolders/sas littlebook/OnionRing.xls' DBMS=XLS OUT = sales1;
RUN;

I placed another excel file sasdatapractice in my folder: '/folders/myfolders/sas littlebook/

PROC IMPORT DATAFILE = '/folders/myfolders/sas littlebook/sasdatapractice.xls' DBMS=XLS OUT = sdata;
RUN;

when I run the code again , it came with this error:

ERROR: Physical file does not exist, /folders/myfolders/sas littlebook/sasdatapractice.xls

please advise.

Kurt_Bremser — Sat, 03 Nov 2018 11:25:58 GMT

When SAS tells you something isn't there, it's not there. Keep in mind that the Linux VM is case-sensitive, so look at your spelling.

Reeza — Sat, 03 Nov 2018 21:42:09 GMT

Go to the Servers Folders and Files tab in SAS Studio. Find the file. Right click it and select properties, that’s the path you need to use.

bondtk — Sun, 04 Nov 2018 06:02:28 GMT

thanks Reeza, I have worked it out, the path was incorrect. thanks for your help.