Export to Excel Table

[Moroho]

Is there way to export to Excel and have SAS format as Excel table? 

Regards,

Joe

[MelissaM]

ODS EXCEL has OPTIONS to utilize filters, if that's what you're looking for. Are there specific features of a table you're looking for?

[Moroho]

It might be easier for me to explain by showing what I do in Excel. 

Here's my data in Excel. 

I highlight the range and click this button... 

...and now it looks like this.  

I would like it if SAS could save me the step of converting my data into a Table.  The reason I want it in this format is Power Automate can pick up my Excel file from my One Drive and insert the data into a Sharepoint list.  This is a workaround because IT won't let us create an API in case you're wondering.  🙂

Thanks!

Joe

[SASKiwi]

If you have the SAS Add-In to MS Office, then reading a SAS table into SAS provides that layout by default:

[ghosh]

Your question is vague.   There are many posts that show how to export to a file that can be opened in excel.  However, to create a formatted workbook, take a look here:

https://blogs.sas.com/content/sgf/2022/06/16/automating-excel-workbooks-creation-using-sas/