topic Re: Out of resources select in SAS Programming

Out of resources select

L777 — Sun, 23 Jul 2023 23:58:08 GMT

When I try to merge two datasets by using "proc sql", I always meet this issue. This is my code:

Proc sql;

create table lab.data2 as

slelct a*, b. BMI

from lab.data1 as a

left join lab.data as b

on a. ID=b.ID;

run;

I wonder if is there a compress option for "proc sql". How can I write the code with that option? Additionally, I have already changed sasv9 and set sasuser and work file under D drive.

"lab" folder was saved under Box under C drive. I wonder if it is better to save the new dataset offline rather than online in Box. I think the C disk is full may also be due to Box. Does anyone meet the same situation? How to deal with that?

Re: Out of resources select

SASKiwi — Mon, 24 Jul 2023 01:48:56 GMT

Open Windows Explorer and check how much free disk space you have on D and C drives. It's not clear from your description which drive you are running out of space on as you will be writing to both. Delete any unwanted files on these drives. Check your D SASWORK folder and delete any old _TDnnnn folders that aren't for your current SAS session. If you have freed up significant space, try rerunning your program.

Re: Out of resources select

Kurt_Bremser — Mon, 24 Jul 2023 06:08:25 GMT

Have you made sure (by using PROC SORT with NODUPKEY) that ID is unique in at least one of the datasets, or is this a many-to-many join?

How large are the datasets (number of observations, total file size for lab.data1)?

Depending on this information, a sequence of PROC SORTs and a DATA step can do it, and if lab.data is not too large (number of observations) and unique with regard to ID, a single DATA step with a hash object will achieve your join much more efficiently.