topic ODS Excel and Insufficient Memory Error - how to get around? in ODS and Base Reporting

ODS Excel and Insufficient Memory Error - how to get around?

SASGeek — Thu, 22 Dec 2016 00:17:21 GMT

Hi there,

I'm trying to run an ODS Excel and get and I get an insufficient memory error. Here are my specs

ODS excel file = "C:\MyStuff 2016 run on &sysdate..xlsx";
proc report data = all3 nowd;
column <<35 variables listed>>
run;
ods excel close;

Total observations: 90166
System: Windows7
SAS Ver: 9.4 TS1M3 X64_7PRO Platform
RAM: 16 gig

Any ideas what to do to get the data out? I need it to output to Excel.

Thanks

Re: ODS Excel and Insufficient Memory Error - how to get around?

Reeza — Thu, 22 Dec 2016 01:07:53 GMT

Post your log. There's nothing about your code that should generate that error message with less than 100k records.

Re: ODS Excel and Insufficient Memory Error - how to get around?

Vince_SAS — Thu, 22 Dec 2016 17:21:15 GMT

You may want to try increasing the value of the MEMSIZE system option:

Problem Note 56985: An out of memory condition might occur when you use the ODS destination for Excel with large tables

http://support.sas.com/kb/56/985.html

Submit this code to see the current setting for the option:

proc options option=memsize; run; quit;

Vince DelGobbo

SAS R&D

Re: ODS Excel and Insufficient Memory Error - how to get around?

SASGeek — Fri, 23 Dec 2016 15:11:00 GMT

Thanks everyone for your help. Two things worked:

1. Increasing memsize as Vince pointed out (I used memsize = max)

2. Giving up on ODS altogether and just doing a proc export. I didn't need all the formatting with ODS and the memory it takes up so I just did it that way.

Thanks all for great answers.