topic Re: The SAS system stopped processing this step because of insufficient memory. in SAS Enterprise Guide

The SAS system stopped processing this step because of insufficient memory.

Programmer26 — Wed, 02 Jun 2021 09:19:27 GMT

Hi All,

I am using Ods excel to create a excel report but i am getting this error instead(mentioned in the subject line).
The code i am using is
Ods excel file= filepath/abc.xlsx style=htmlblue
Options(sheet_name=xyz);
Proc print data=test;
Run;
Ods excel(sheet_name=xyz1);
Proc print data=test2;
Run;
Ods excel close;
I tried using the memsize=max option but the option is throwing a warning " Option memsize should be used at the start of the sas system. Option ignored.
I relaunched the session but the same result.

Kindly help me out on this.

Re: The SAS system stopped processing this step because of insufficient memory.

Kurt_Bremser — Wed, 02 Jun 2021 10:28:22 GMT

How many observations and variables do those datasets have, and how large are the observation sizes?

(run PROC CONTENTS)

Re: The SAS system stopped processing this step because of insufficient memory.

Programmer26 — Wed, 02 Jun 2021 10:33:24 GMT

Observations=220k
Vars=6

Re: The SAS system stopped processing this step because of insufficient memory.

Programmer26 — Wed, 02 Jun 2021 10:35:57 GMT

Obs=227920
Var=6
Obs length=161

Re: The SAS system stopped processing this step because of insufficient memory.

Kurt_Bremser — Wed, 02 Jun 2021 10:41:08 GMT

@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.

Re: The SAS system stopped processing this step because of insufficient memory.

Programmer26 — Wed, 02 Jun 2021 11:04:23 GMT

Kurt,
When i am using the code as you mentioned it is throwing a error stating
Could not find 'workbook.xml.rels'
Error: file myex.xyz does not exist.

Re: The SAS system stopped processing this step because of insufficient memory.

Kurt_Bremser — Wed, 02 Jun 2021 11:11:11 GMT

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.

Re: The SAS system stopped processing this step because of insufficient memory.

Programmer26 — Wed, 02 Jun 2021 11:47:48 GMT

Thank you Kurt.
I checked and there were multiple files stored by the same name in that folder.
It is working fine now.

Thank you for the help!! 🙂