topic Export data to Excel with summary table at top in SAS Enterprise Guide

Export data to Excel with summary table at top

madara155 — Mon, 29 Aug 2022 06:48:26 GMT

I need to export a SAS data table (with hundreds of rows) to excel with a summary of the data appearing at the top of the excel file (See the image below).

I can export data to Excel, but not sure how to get the summary at the top while displaying the rest of the data below it (I can get the summary to a new sheet using ODS EXCEL OPTIONS)

Thanks in advance for any input.

Re: Export data to Excel with summary table at top

Ksharp — Mon, 29 Aug 2022 12:33:20 GMT

You could use " ods excel options(sheet_interval='none' ) ; " to put two table in the same sheet.
Or Check this tagset:
https://support.sas.com/rnd/base/ods/odsmarkup/msoffice2k/index.html

Re: Export data to Excel with summary table at top

JosvanderVelden — Mon, 29 Aug 2022 13:08:22 GMT

You can also have a look at this blog post https://blogs.sas.com/content/sgf/2019/04/23/ods-excel-control/.