topic Dealing with PROC SQL message : Out of memory in SAS Programming

Dealing with PROC SQL message : Out of memory

LineMoon — Wed, 04 May 2022 22:18:22 GMT

Hello Exprts,

Please, how to deal with the proc sql error message : out of memory.

for the following code applied on a big tables.

The only method allowed is sas sql ( there is no "merge" or "set" allowed ..)

proc sql;

selec m.t1, n.v1, m.t2, n.v2

from toto1 m left join toto2 n

on m.id=n.id

where m.t3='2' and m.t4='4';

quit;

Re: Dealing with PROC SQL message : Out of memory

Reeza — Wed, 04 May 2022 22:42:08 GMT

You probably can't then, if you're not allowed alternatives.
Talk to your IT to increase resources.

Re: Dealing with PROC SQL message : Out of memory

SASKiwi — Wed, 04 May 2022 23:53:38 GMT

What's your SAS MEMSIZE setting? You can check it by running this:

proc options option = memsize;
run;

Large SQL queries often require a lot of memory.

Also you are missing a CREATE TABLE on your SELECT. That might be the causing the memory problem. Change your program like this:

proc sql;
create table want as
selec m.t1, n.v1, m.t2, n.v2
from toto1 m left join  toto2 n
on m.id=n.id
where  m.t3='2' and m.t4='4';
quit;

Re: Dealing with PROC SQL message : Out of memory

Kurt_Bremser — Thu, 05 May 2022 05:00:53 GMT

Without a CREATE TABLE, your SELECT pushes the result to the output window, and that will easily overwhelm your UI.

The "requirement" to not use the most powerful tool available in SAS is as stupid as it gets. I advise to seek employment somewhere else, working for idiots won't get you far.