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.