import an excel file in sas studio

[bondtk]

Hi

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]

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 · Accepted solution]

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]

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