Dealing with PROC SQL message : Out of memory

[LineMoon]

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;

[Reeza]

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

[SASKiwi]

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;

[Kurt_Bremser]

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.