@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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: