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;
Any ideas what to do to get the data out? I need it to output to Excel.
Thanks
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
Post your log. There's nothing about your code that should generate that error message with less than 100k records.
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
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.