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.
we are using sas 9.3 and excel 2007
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.
Tom
it is about 20 000 000 rows and 50 columns. most of them are text with ~16 symbols length. im not able to check the size of it...
Hi,
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?
--Q.
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.
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.
Tom
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!