Reading an Excel file into SAS
AMC Concord 22 2930 4099
AMC Pacer 17 3350 4749
AMC Spirit 22 2640 3799
Buick Century 20 3250 4816
Buick Electra 15 4080 7827
PROC IMPORT OUT= WORK.auto1 DATAFILE= "C:\auto.xl"
- The out= option in the proc import tells SAS what the name should be for the newly-created SAS data file and where to store the data set once it is imported.
- Next the datafile= option tells SAS where to find the file we want to import.
- The dbms= option is used to identify the type of file being imported.
- The replace option will overwrite an existing file.
- To specify which sheet SAS should import use the sheet="sheetname" statement. The default is for SAS to read the first sheet. Note that sheet names can only be 31 characters long.
- The getnames=yes is the default setting and SAS will automatically use the first row of data as variable names. If the first row of your sheet does not contain variable names use the getnames=no.
Writing Excel files out from SAS
dbms = xlsx replace;