DATA Step, Macro, Functions and more

Macro to convert XML to Excel

Accepted Solution Solved
Reply
New Contributor
Posts: 4
Accepted Solution

Macro to convert XML to Excel

Hello,

I have several scheduled task that run in batch overnight and create 'Excel' file through ODS tagset. These files are then sent via email to the end users. I am using tagset for the formatting flexibility. However, some end users want to be able to see the spreadsheets on their i-phone/pad. The only way I know how to accomplish this is to open the file and re-save as an actual excel file.

Does anyone know of a macro or some code that would open and save the file to native excel in base SAS runniong in batch. Please say you do...pretty please.

Thanks,

Tobin


Accepted Solutions
Solution
‎02-27-2013 10:36 AM
Respected Advisor
Posts: 3,799

Re: Macro to convert XML to Excel

Posted in reply to Tobin_Scroggins

All Replies
Solution
‎02-27-2013 10:36 AM
Respected Advisor
Posts: 3,799

Re: Macro to convert XML to Excel

Posted in reply to Tobin_Scroggins
New Contributor
Posts: 4

Re: Macro to convert XML to Excel

Posted in reply to data_null__

Thanks data_null. I haven't had a chance to test but this is what I was looking for. Much appreciated.

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 1902 views
  • 0 likes
  • 2 in conversation