hi this is vinod
proc import out=work.superstore1 datafile="C:\Users\user\Desktop\m\sample.xlsx"
dbms=excel replace;
run;
i am getting
ERROR: Unable to open file C:\Users\user\Desktop\m\sample.xls. It does not exist or it is already
opened exclusively by another user, or you need permission to view its data.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.05 seconds
plz tell me the answer is this correct
The path to the file is incorrect.
If you right click the file holding down SHIFT key you can copy the path to the file directly (COPY AS PATH) and use that in your import. Make sure the file isn't in use either as indicated, ie Excel is closed.
Also use DBMS = XLSX not EXCEL.
And if you are running in a server environment the path would be from the Server machine point of view and would not see your desktop.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.