title: How do I vertically stack tables in SAS using ODS Excel?
body: <p>I'm exporting a series of crosstabs from SAS 9.3 to Excel using Excel ODS tagsets.</p>
  
  <p>The syntax I've written is as follows:</p>
  
  <pre><code>%include 'C:\Users\MyName\Documents\excltags.tpl';
  ods tagsets.excelxp file = "M:\Assess\1718\PARTIC_3-8.xml"
  
  proc sort data = assess_elem;
     by accommodations_ny participation_ny district;
  run;
  
  proc freq data = assess_elem
     by accommodations_ny participation_ny district;
     tables grade*proficiency / crosslist nocum nocol;
  run;
  
  ods tagsets.excelxp close;
  </code></pre>
  
  <p>The variables are:</p>
  
  <ul>
  <li>accommodations_ny: alphanumeric, N/Y</li>
  <li>participation_ny: alphanumeric, N/Y</li>
  <li>district: alphanumeric, 103 district names</li>
  <li>grade: numeric, 3-8</li>
  <li>proficiency: numeric, 0/1</li>
  </ul>
  
  <p>The syntax above creates a table like this for each of the 103 districts:</p>
  
  <p><a href="https://i.stack.imgur.com/nLMDt.png" rel="nofollow noreferrer">have 103 separate tables</a></p>
  
  <p>What I would like to have is something more like:</p>
  
  <p><a href="https://i.stack.imgur.com/I9AzY.png" rel="nofollow noreferrer">want 1 stacked table</a></p>