Export data to Excel with summary table at top

[madara155]

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.

[Ksharp]

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

[JosvanderVelden]

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