topic Re: Export table in excel table in SAS Programming

Export table in excel table

luca87 — Fri, 01 Sep 2023 14:18:15 GMT

Hello,
I wanted to export a SAS table to xlsx and define it inside a table.
In xlsx it would be defined here:

Thanks

Luca

Re: Export table in excel table

Tom — Fri, 01 Sep 2023 15:05:16 GMT

Not sure what you are asking for.

You can export a dataset to SHEET in an XLSX workbook. Either adding or replacing a sheet in an existing workbook, or creating a new workbook.

You can also create a sheet in an XLS workbook but why would anyone use that ancient proprietary format instead of the modern public format of an XLSS workbook.

Re: Export table in excel table

Sajid01 — Sat, 02 Sep 2023 20:07:41 GMT

This feature of creating Excel table is not available in SAS .
One can export a SAS table to an excel sheet or range, but cannot create excel table using SAS code.

Re: Export table in excel table

martrix396 — Sun, 03 Sep 2023 13:25:26 GMT

You can use ODS Excel to output SAS dataset in xlsx format. You can add multiple sheets and also add more than 1 SAS dataset to 1 sheet.

If you don't need to add multiple tables to 1 sheet PROC Export can also be used.