Importing XLSX file from Desktop

[KALLEN]

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;

[KALLEN]

I believe where I am going wrong is in datafile=   

[Reeza]

Are yo using SAS University Edition or SAS on a server? If it's SAS UE you need to place the file in the myfolders and import it from there. If you're using EG you'll need to use the GUI.

[KALLEN]

I'm using SAS EG on a remote server

[Kurt_Bremser]

Your SAS runs on a UNIX system, either on a remote server or in the virtual machine of University Edition. Which is it?

[Kurt_Bremser]

Your SAS runs on a UNIX system, either on a remote server or in the virtual machine of University Edition. Which is it?

[KALLEN]

I am using EG on a remote server

[ChrisHemedinger · Accepted solution]

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.

[KALLEN]

Great! Really like this solution.