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.