How to export Multi-Tab Reports as Multi-Sheet Excel File in SAS Viya

[Mahis]

Hi everyone,

Is it possible in SAS Viya to export a report with multiple tabs as an Excel file with multiple sheets?

[alexjordan]

As per my knowledge, it is possible. In SAS Viya, we can use the "Export Report" functionality in SAS Visual Analytics to export a multi-tab report as an Excel file.

Remember each tab in the report corresponds to a sheet in the Excel file. We need to make sure that we select the "Excel" format during export.

If further customization is needed, you can leverage SAS code with ODS EXCEL to structure multi-sheet output.

Hope this works!