please follow below code
/* because Excel field names often have spaces */
options validvarname=any;
libname np XLSX '/home/userid/EPG194/data/np_info.xlsx';
/* discover member (DATA) names */
proc datasets lib=np; quit;
libname np CLEAR;
Once the library is assigned, we can read the contents of a spreadsheet into a new SAS data set:
/* because Excel field names often have spaces */
options validvarname=any;
libname np XLSX '/home/userid/EPG194/data/np_info.xlsx';
/* read in one of the tables */
data datasetname;
set np.datasetname;
run;
libname np CLEAR;
... View more