11-04-2014 04:11 PM
My excel gets crashed every time when I try to save it after pulling data from SAS stored procedure.
Did any one face this issue before or have any suggestion to fix this?
11-04-2014 06:32 PM
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.
11-05-2014 06:47 AM
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.
11-05-2014 03:16 PM
11-06-2014 01:18 AM
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.