SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

excel add-in problem with large files

Reply
Contributor
Posts: 29

excel add-in problem with large files

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.

Contributor
Posts: 29

Re: excel add-in problem with large files

we are using sas 9.3 and  excel 2007

Trusted Advisor
Posts: 1,030

Re: excel add-in problem with large files

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

Contributor
Posts: 29

Re: excel add-in problem with large files

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

Trusted Advisor
Posts: 1,143

Re: excel add-in problem with large files

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.

Contributor
Posts: 29

Re: excel add-in problem with large files

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.

Trusted Advisor
Posts: 1,030

Re: excel add-in problem with large files

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

Post a Question
Discussion Stats
  • 6 replies
  • 416 views
  • 0 likes
  • 3 in conversation