topic Re: excel add-in problem with large files in Microsoft Integration with SAS

excel add-in problem with large files

EdvinasS — Wed, 05 Dec 2012 07:26:27 GMT

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.

Re: excel add-in problem with large files

EdvinasS — Wed, 05 Dec 2012 07:27:03 GMT

we are using sas 9.3 and excel 2007

Re: excel add-in problem with large files

TomKari — Wed, 05 Dec 2012 15:44:31 GMT

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

Re: excel add-in problem with large files

Quentin — Thu, 06 Dec 2012 00:50:13 GMT

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.

Re: excel add-in problem with large files

EdvinasS — Fri, 14 Dec 2012 14:11:19 GMT

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...

Re: excel add-in problem with large files

EdvinasS — Fri, 14 Dec 2012 14:12:47 GMT

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.

Re: excel add-in problem with large files

TomKari — Sat, 15 Dec 2012 18:41:02 GMT

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