At the time of the memory failure, your SAS process consumed 10G of RAM, and I suspect you ran into a limit set (wisely) by the SAS admin.
Use PROC EXPORT, as suggested. Or write your data to a csv file, which does not need to have all the XML data ready before running the zip.
Are you really trying to create a report with 600,000 lines?
I don't think that proc reports is responsible for the out-of-memory error, but ods excel. Try using proc export with the label-option instead.
At the time of the memory failure, your SAS process consumed 10G of RAM, and I suspect you ran into a limit set (wisely) by the SAS admin.
Use PROC EXPORT, as suggested. Or write your data to a csv file, which does not need to have all the XML data ready before running the zip.
Why would writing UTF-8 characters have any impact on writing a text file?
Here is a simple method to create a CSV file from a dataset. If you need a header line make that line first and use the MOD option on the FILE statement in the step that writes the data.
data _null_;
set have;
file 'mydata_noheader.csv' dsd ;
put (_all_) (+0);
run;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.