Hi all, I'm migrating a lot of PC-SAS reporting over to SAS EG. Many of the programs relied heavily upon proc export to update many different sheets in an excel workbook. I know proc export doesn't work with SAS EG (at least to local excel workbooks), but I am using to what I assume is the next best option, the SAS Excel add-on. Only issue with this is that it seems that I have to open each workbook after I run my SAS EG projects and select the 'Manage Content' and then 'Update all.' So my question is, Is there a better way to do this? Can I run a script or something else that will update all the datasets in the excel files without having to open each one? Appreciate the time.
... View more