title: Exporting multiple sas datasets into multiple excel sheets with macro?
body: <p>I am looking if there is a macro that would export multiple datasets into separate excel worksheets within a workbook. Would be great if I could have 10 sheets per workbook.</p>
  
  <p>I can do it the usual way as below, but I have more than 100 datasets to export:</p>
  
  <pre><code>PROC EXPORT DATA=HAVE;
  OUTFILE= "S:\MYEXCEL.xlsx" 
          DBMS=EXCEL REPLACE;
  SHEET="NEW_SHEET"; 
  RUN;
  </code></pre>
  
  <p>Thank you!</p>