Exporting results to excel with ODS

stats2555 — Fri, 18 Nov 2022 23:39:30 GMT

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;

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!

Re: Exporting results to excel with ODS

ballardw — Fri, 18 Nov 2022 23:47:25 GMT

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.

topic Re: Exporting results to excel with ODS in New SAS User

Exporting results to excel with ODS

Re: Exporting results to excel with ODS