It seems incompatibility with the version of .NET on my machine was causing this issue.
I applied following Hotfix to correct this:
Has this only just started happening or has it never worked? Do other SAS users have the same problem or is it just your PC? Rather than waste a lot of time troubleshooting I suggest you try re-installing the SAS Add-In to Microsoft Office as a starting point.
I suggest you track this to SAS Tech Support in that case.
Try running the stored process from EG, and save the results to an Excel file. Then see if it is something in the data that causes Excel to crash.
Long shot: Is your SAS a 32-bit version and Excel 64 bits or vice versa?
Don't do "Send to Excel". That's about as crappy as can get, basically it means that SAS simulates an Excel user typing in values. Takes forever and a day with big data. And is completely dependent upon what your Excel version of the day _thinks_ you wanted to "type".
Save/Export the data to a file and then open that from Excel.
My personal favorite for getting data into Excel is tagsets.excelxp. Works on all SAS platforms and completely avoids the microcrap while working with SAS.
It seems incompatibility with the version of .NET on my machine was causing this issue.
I applied following Hotfix to correct this:
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!