1) What sas version are you using ?
2) Is your sas on windows OS platform?
You can import .xlsm file by defining: libname myxl '<path and file name>.xlsm';
You can relate to any sheet in your excel as if it is a sas dataset, that is:
data new;
set myxl.<sheet name> ;
... any other sas statements ...
run;
you can run proc contents to verify how sas imported the xlsm sheet by:
proc contents data=myxl.<sheet-name>; run;
... View more