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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.