topic Re: Export to Excel Table in SAS Programming

Export to Excel Table

Moroho — Wed, 24 Jan 2024 16:13:40 GMT

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

Regards,

Joe

Re: Export to Excel Table

MelissaM — Wed, 24 Jan 2024 16:33:27 GMT

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?

Re: Export to Excel Table

ghosh — Wed, 24 Jan 2024 16:36:43 GMT

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/

Re: Export to Excel Table

Moroho — Wed, 24 Jan 2024 16:55:26 GMT

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

Re: Export to Excel Table

SASKiwi — Wed, 24 Jan 2024 19:15:39 GMT

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