Question

How to convert excel file into SAS 9.4

Answer 1

Using the below code, we can convert an excel file into SAS 9.4 dataset:

In the below code, make the necessary replacements for:

• datafile = Specify the location and actual excel file name in your system
• The output data has been named as testdata in the WORK library of SAS. You can change it by specifying the dataset name in out= option in below code.
• Specify the actual excel worksheet name that has the data and need to be imported. I have used "Sheet1" for importing

proc import datafile="E:\file_location\file_name.xlsx" dbms=XLSX out=testdata replace;
   sheet="Sheet1";
run;