FILENAME REFFILE $\text{'}/$path$/$to$/$file$/$rawData$.$xIsx';

PROC IMPORT DATAFILE $=$ REFFILE

$DBMS=xLSx$

OUT $=$ WORK.IMPORT;

GETNAMES $=$ YES;

RUN;

$1/$path$/$to$/$file$/$mydata$.$xlsx$\text{'}$ Provide the path to the raw data file

FILENAME REFFILE

DBMS $=xLSx$

Create an internal reference to a file called REFFILE

OUT $=$ WORK.IMPORT

Specify that the data file is a newer version of an excel file

GETNAMES $=$ YES

Choose...