Macro to convert XML to Excel

[Tobin_Scroggins]

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

[data_null__ · Accepted solution]

See if this thread is helpful.

https://communities.sas.com/message/124238#124238

[Tobin_Scroggins]

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