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

[SASGeek]

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

[Reeza]

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

[Vince_SAS · Accepted solution]

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

[SASGeek]

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.