@Programmer26 wrote:
Observations=220k
Vars=6
That's WAY beyond what constitutes a report. Run a simple export using a LIBNAME:
libname myex xlsx "filepath/abc.xlsx";
data myex.xyz;
set test;
run;
data myex.xyz1;
set test2;
run;
libname myex clear;
ODS EXCEL will add all the formatting tags for every cell, which are not necessary when exporting just data.
Since that needs to be kept as text (XML) in memory before the compressed file is written, you run out of memory.
How many observations and variables do those datasets have, and how large are the observation sizes?
(run PROC CONTENTS)
@Programmer26 wrote:
Observations=220k
Vars=6
That's WAY beyond what constitutes a report. Run a simple export using a LIBNAME:
libname myex xlsx "filepath/abc.xlsx";
data myex.xyz;
set test;
run;
data myex.xyz1;
set test2;
run;
libname myex clear;
ODS EXCEL will add all the formatting tags for every cell, which are not necessary when exporting just data.
Since that needs to be kept as text (XML) in memory before the compressed file is written, you run out of memory.
I guess you have a damaged xlsx file. Make sure that it does not exist before you issue the LIBNAME.
After deleting the file, please run the code again and post the whole log using the </> button.
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!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.