Question: how to import multiple excel files into sas?
Answer: Hard code the SAS program you are keen to make efficient with a macro. Ensure the code in step 1 runs correctly. Add a macro. ...  Name your macro. ...  End the macro. ...  Place code from step 1 between %macro MyfirstMacro; and %mend; ...  Run Step 6.