title: SAS: export multiple procedures output to Excel using ODS
body: <p>I am running bunch of tobit models on SAS. I want to transfer the output to Excel, but I want the output from all models to be in one Excel book (as opposed to creating one book for each model.) How would one do that? Many thanks. </p>
  
  <p>I have the following code, but it only reports on of the results </p>
  
  <pre><code>  ODS TAGSETS.EXCELXP
    file='C:\Documents and Settings\Administrator\My Documents\...\Results.xls'
    STYLE=minimal
    OPTIONS ( Orientation = 'landscape'
    FitToPage = 'yes'
    Pages_FitWidth = '1'
    Pages_FitHeight = '100' );
  
    Proc qlim Data=AD.Data;
    class var1;
    model don =var1 var2;
    endogenous don ~ truncated (lb = 1);
    Run;
  
    Proc qlim Data=AD.Data;
    class var1;
    model don =var1 var2 var1*var2;
    endogenous don ~ truncated (lb = 1);
    Run;
    quit;
    ods tagsets.excelxp close;
  </code></pre>