topic Importing XLSX file from Desktop in SAS Programming

Importing XLSX file from Desktop

KALLEN — Thu, 08 Nov 2018 19:04:13 GMT

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;

Re: Importing XLSX file from Desktop

KALLEN — Thu, 08 Nov 2018 19:08:01 GMT

I believe where I am going wrong is in datafile=

Re: Importing XLSX file from Desktop

Reeza — Thu, 08 Nov 2018 19:19:55 GMT

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.

Re: Importing XLSX file from Desktop

Kurt_Bremser — Thu, 08 Nov 2018 19:30:48 GMT

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

Re: Importing XLSX file from Desktop

Kurt_Bremser — Thu, 08 Nov 2018 19:30:49 GMT

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

Re: Importing XLSX file from Desktop

KALLEN — Thu, 08 Nov 2018 20:21:21 GMT

I am using EG on a remote server

Re: Importing XLSX file from Desktop

KALLEN — Thu, 08 Nov 2018 20:19:51 GMT

I'm using SAS EG on a remote server

Re: Importing XLSX file from Desktop

ChrisHemedinger — Thu, 08 Nov 2018 20:29:47 GMT

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.

Re: Importing XLSX file from Desktop

KALLEN — Thu, 08 Nov 2018 21:15:19 GMT

Great! Really like this solution.