Exporting results to excel with ODS

[stats2555]

I'm currently exporting results of my proc mixed analysis using ODS with the following code:

FILENAME out 'filename.xls';
ods listing close;
ods excel file=out;

<code here>

ods excel close;
ods listing;

It's giving my results in excel format, but each table from my results ends up in a different tab in the excel file.  Is it possible to only export one table (i.e. least square means)?

Thanks!

[ballardw · Accepted solution]

First, you should be using an XLSX extension.

All the tables generated between and ODS destination and it's close will go to the ODS destination.

If you one want one table from a procedure that produces more then you would add an "ODS SELECT <tablename>; statement. Tablename is the specific table output you want. Without knowing the code you ran I can't guess which that would be.

You can place your procedure code between an ODS Trace on; <proc> ; Ods trace off; pair and the LOG will show the names of all the tables generated by the procedure.