09-05-2014 02:58 PM
Does anyone have code that will import all excel files (.xlsx) in a folder regardless of the name of the file?
All files have one sheet named ALL_INJ.
Also, is it possible to capture the name of the excel file in a macro or in each SAS dataset that is created?
09-05-2014 04:49 PM
%macro <macroname> is the beginning of the macro
%mend is the end of the macro
All that use in between %macro and %mend is the what you want the macro to run
/* first step of the macro xls2sas*/
and %mend is where the macro for xls2sas ends
The next step is to call the macro and this is how you call it.
Did this help?