topic Re: SAS EG Excel File Export Maximum in SAS Enterprise Guide

SAS EG Excel File Export Maximum

cbrotz — Thu, 01 Nov 2018 20:14:55 GMT

I have a SAS EG project that exports 34 small SAS DATA sets to Excel files. Sometimes they all export and sometimes they do not. I inherited this from another programmer. She originally was using the SAS data sets with the SAS Addin in Excel and switched over to Excel files instead. Either way, when I run the full project, I can see the data has updated in the SAS file but the export does not push the data out until I manually click on the Export process for some of the files. Any ideas why his might be happening?

Thank you

Re: SAS EG Excel File Export Maximum

VDD — Thu, 01 Nov 2018 20:34:23 GMT

Is the export process creating or replacing the Excel worksheet?

If the Excel worksheet exist does the process fail until you do the manual exporting?

Re: SAS EG Excel File Export Maximum

cbrotz — Thu, 01 Nov 2018 20:40:46 GMT

All the Excel files are exported into the same folder. I do not delete them so when the process runs, it is overwriting or replacing them. Sometimes, if we re run the entire process, it will then push the data out correctly. The only pattern I see is that it is happening with files further down stream in the code. I have at times deleted all the Excel files and just let EG re-create them. That works for a while and then they start to not export again. I have not tried to put in a step to delete the files before running. I could try that.

Re: SAS EG Excel File Export Maximum

Doc_Duke — Fri, 02 Nov 2018 18:05:33 GMT

Are you exporting using SAS code or an EG task? Some earlier versions of EG had a bug and did not consistently execute all tasks in the order specified by the project. The only way to tell was to watch the tasks light up or by a careful review of the log.

Re: SAS EG Excel File Export Maximum

cbrotz — Mon, 05 Nov 2018 13:09:33 GMT

This code is about 4 years old so it was written a few versions back and we do keep up with the versions but yes it seems like a bug of some kind. Unfortunately, it happens kind of randomly so I kind of have to wait to see it happen.

Thanks,

Chris

Re: SAS EG Excel File Export Maximum

VDD — Mon, 05 Nov 2018 13:16:50 GMT

bugs like that don't come and go when they choice.