Is there way to export to Excel and have SAS format as Excel table?
Regards,
Joe
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
If you have the SAS Add-In to MS Office, then reading a SAS table into SAS provides that layout by default:
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/
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.