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

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.
 
 
1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User
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.

View solution in original post

3 REPLIES 3
Reeza
Super User
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
Quartz | Level 8

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

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 1111 views
  • 0 likes
  • 3 in conversation