12-05-2012 02:26 AM
Hello, we have problem in using excel add-in. if we load data table bgiger than ~30 MB and run any task from many (for axample tasks->describe->summary statistics) excel crashes. it works fine with smaller datasets. is there any solution for that? Thanks in advance.
12-05-2012 10:44 AM
How many columns and rows are in your SAS dataset that is causing the failure, and how many MB is it? I'm trying to replicate your problem.
12-05-2012 07:50 PM
That sounds odd. If you are running summary statistics, then you probably aren't returning a lot of data to Excel. What happens if you try to run the descriptive statistics from Enterprise Guide or similar?
12-14-2012 09:12 AM
EG works fine. for example we run tasks-> .. -> summary statistics with filter by one column equal to currency USD. when we press OK to run it crashes.
12-15-2012 01:41 PM
I've replicated your functions and volume, and my Excel works fine. I would suggest reporting this to SAS technical support; they may know how to do detailed troubleshooting. I suspect the contributors to this forum won't be able to help with a problem of this nature.