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/
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.