this is a problem similar to a battle I have been fighting I have a ton of code that outputs to excel using ODS for a dozen projects. However, the files come out as xml (or html) yet I have the requirement that the 'reports' are in excel. To fix this I had to write a block of code that creates a vbscript file. First my code outputs the all the xml reports. Then I create the vbscript that opens each xml spreadsheet and and then does a save as xlsx. At the end it deletes all the xml files. One problem I've encountered is the timing of batch runs for a dozen or so projects. I have to put waits or sleep commands into my code so a process will have a chance of finishing before another process runs. I wish SAS could output to a native excel file. I'm debating writing an VB program that handles this for all projects
... View more