BookmarkSubscribeRSS Feed
Moroho
Calcite | Level 5

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

 

Regards,

Joe

4 REPLIES 4
MelissaM
Obsidian | Level 7
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
Calcite | Level 5

 

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

Here's my data in Excel. 

Moroho_2-1706114545254.png

I highlight the range and click this button... 

Moroho_3-1706114657534.png

...and now it looks like this.  

Moroho_0-1706114485532.png

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
PROC Star

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

SASKiwi_0-1706123719007.png

 

ghosh
Barite | Level 11

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/ 

sas-innovate-wordmark-2025-midnight.png

Register Today!

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.


Register now!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 757 views
  • 0 likes
  • 4 in conversation