Importing XLSX file into SAS

Question

OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

  PROC IMPORT OUT= Census.taxp_lookupDATAFILE="C:\Users\Dhruv\Desktop\Book1.xlsx"
                     DBMS=xlsx REPLACE;
               SHEET="tax_group";
               GETNAMES=YES;
          RUN;

 ERROR: Physical file does not exist, /opt/sasinside/SASConfig/Lev1/SASApp/C:\Users\Dhruv\Desktop\/Book1.xlsx.

I am facing this error while importing excel file into sas. What do i need to change in my code

https://communities.sas.com/t5/General-SAS-Programming/ERROR-Physical-file-does-not-exist-opt-sasinside-SASConfig-Lev1/td-p/147659 — Tim Williams, Oct 12 '16 at 05:20

score 0 · Answer 1 · answered Oct 12 '16 at 05:58

you basically need to specify the data to be read: DATAFILE=""

/** Import an XLSX file.  **/

PROC IMPORT DATAFILE="<Your XLSX File>"
        OUT=WORK.MYEXCEL
        DBMS=XLSX
        REPLACE;
RUN;

/** Print the results. **/

PROC PRINT DATA=WORK.MYEXCEL; RUN;

Video on how to find the excel file and find the right path for SASstudio

PS: to answer the questions: "basically you need to have the file already in My Folders and not path to your local desktop file, also if you are using a server than you need to import, I'm not sure if to SAS University Edition is the option Import on right click folder like in picture listed below: Screen for import is SAS Studio"

Importing XLSX file into SAS

1 Answers1