I am running the following macro in SAS EG.
The SAS dataset created does NOT have underscores between column names containing 2 or more words. For example, Branch Number does NOT become Branch_Number, but stays Branch Number.
%macro import_xls(data=,sheet=,xls=);
proc import dbms=excelcs out=&data
datafile="&xls"
replace;
server="&machineid..nam.nsroot.net"; /* Name of PC files server */
port=8621; /* Port number listening on the PC server */
version='2002'; /* Excel file version */
sheet="&sheet"; /* Sheet name */
scantext=yes; /* Scan all rows data for the largest size */
usedate=yes; /* Use DATE format for date/time columns */
scantime=yes; /* Scan and identify time columns */
dbsaslabel=none; /* Leave SAS label names to be nulls */
textsize=512; /* Largest text size allowed */
run;
%mend import_xls;