BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
SASGeek
Obsidian | Level 7

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

1 ACCEPTED SOLUTION

Accepted Solutions
Vince_SAS
Rhodochrosite | Level 12

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

3 REPLIES 3
Reeza
Super User

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

Vince_SAS
Rhodochrosite | Level 12

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
Obsidian | Level 7

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.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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