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;
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;
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.
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!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.