topic Re: Excel crashes after running SP in Microsoft Integration with SAS

Excel crashes after running SP

Dreamer — Tue, 04 Nov 2014 21:11:33 GMT

Hi,

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?

Thanks

Re: Excel crashes after running SP

SASKiwi — Tue, 04 Nov 2014 23:32:18 GMT

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.

Re: Excel crashes after running SP

Kurt_Bremser — Wed, 05 Nov 2014 11:47:29 GMT

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.

Re: Excel crashes after running SP

Dreamer — Wed, 05 Nov 2014 19:49:58 GMT

Its a problem from long time and everyone in my team is facing this issue. I already re-installed SAS Add-In to Microsoft Office but no luck!!

Re: Excel crashes after running SP

SASKiwi — Wed, 05 Nov 2014 20:11:36 GMT

I suggest you track this to SAS Tech Support in that case.

Re: Excel crashes after running SP

Dreamer — Wed, 05 Nov 2014 20:16:59 GMT

I ran that SP in EG and send data to Excel. But when I tried saving that Excel, I got following error:

This is the case with simple data export (SASHELP.CLASS) as well. No idea whats going on here.

Re: Excel crashes after running SP

ballardw — Wed, 05 Nov 2014 20:39:24 GMT

Long shot: Is your SAS a 32-bit version and Excel 64 bits or vice versa?

Re: Excel crashes after running SP

Kurt_Bremser — Thu, 06 Nov 2014 06:18:27 GMT

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.

Re: Excel crashes after running SP

Dreamer — Wed, 31 Dec 2014 16:20:06 GMT

It seems incompatibility with the version of .NET on my machine was causing this issue.

I applied following Hotfix to correct this:

http://support.sas.com/kb/53301