The SAS Output Delivery System and reporting techniques

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

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 5
Accepted Solution

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

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


Accepted Solutions
Solution
‎12-23-2016 10:11 AM
SAS Employee
Posts: 284

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

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

View solution in original post


All Replies
Super User
Posts: 17,784

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

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

Solution
‎12-23-2016 10:11 AM
SAS Employee
Posts: 284

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

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

Occasional Contributor
Posts: 5

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

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.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 448 views
  • 1 like
  • 3 in conversation