topic Error in importing excel files in New SAS User

Error in importing excel files

obi1-design — Sun, 27 Sep 2020 14:28:14 GMT

I have been trying to import an excel file through open grogram means but it keeps encrypting the file and shows like this picture below. help anyone please

Re: Error in importing excel files

Kurt_Bremser — Sun, 27 Sep 2020 14:46:29 GMT

SAS programs are plain text files, XLSX files are ZIP archives of XML data.

You cannot open Excel files as programs, you need to import them as data.

Since you seem to have a locally installed SAS, you can import the Excel data with PROC IMPORT, which you need to write in a program window.

Re: Error in importing excel files

Tom — Sun, 27 Sep 2020 14:50:26 GMT

You cannot open a spreadsheet as if it is a text file. What you are seeing in the program editor are just the binary bytes of the file interpreted as if they were text.

You can import an XLSX file into dataset(s). There is a GUI tool for that (not the Explorer tool you are using). But it is generally easier to write the code yourself. For example just create a libref using the XLSX engine pointing to the file. Then you can read each sheet as a dataset. To copy all of the sheets to dataset you might want to just use PROC COPY.

libname in xlsx '....\Customer_loan_data.xlsx' accress=readonly;
proc copy inlib=in outlib=work;
run;