SAS (Base SAS)+
proc import datafile="path\\mf_data.xls"
out=males
dbms=excel
replace;
sheet="Males";
run;- DBMS=EXCEL reads the legacy .xls format.
- SHEET selects the worksheet to import.
proc import datafile="path\\mf_data.xls"
out=males
dbms=excel
replace;
sheet="Males";
run;