I am attempting to import an excel file stored on my desktop but I am receiving this error message:
ERROR: Physical file does not exist, /opt/config/Lev1/SASApp/C:\Users\KALLEN.EPECAD\Desktop\/auto
Below is my code and I have attached my data. What am I doing wrong? Thanks.
PROC IMPORT OUT=WORK.auto1 DATAFILE="C:\Users\KALLEN.EPECAD\Desktop\auto.xlsx" DBMS=xlsx REPLACE; SHEET="auto"; GETNAMES=YES; RUN;
Use the Copy Files task to copy the local Excel file to your server, then run your PROC IMPORT from there. The remote SAS session cannot see your Windows desktop system.
Example of the task settings, process flow, and code you might use.
I believe where I am going wrong is in datafile=
Your SAS runs on a UNIX system, either on a remote server or in the virtual machine of University Edition. Which is it?
Your SAS runs on a UNIX system, either on a remote server or in the virtual machine of University Edition. Which is it?
I am using EG on a remote server
Use the Copy Files task to copy the local Excel file to your server, then run your PROC IMPORT from there. The remote SAS session cannot see your Windows desktop system.
Example of the task settings, process flow, and code you might use.
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.