proc sql; select patid, min(date) as min_date, min(your_other_var) as min_other_var ..... from dataset where target is not missing or target2 is not missing group by patid order by patid; quit; run;

Prasad Ravi

Kristie Beth <kristie_35_89@YAHOO. To: SAS-L@LISTSERV.UGA.EDU COM> cc: Sent by: "SAS(r) Subject: proc sql Discussion" <SAS-L@LISTSERV.UGA.E DU>

07/02/2003 11:45 AM Please respond to Kristie Beth

Hi, I have another question (thanks so much for the other help!), this is on proc sql, I am not understanding why or HOW the 'case when' works

For example, if I have the following code,

proc sql, select patid, case when target is not missing then min(date)

from dataset where target is not missing or target2 is not missing group by patid order by patid quit;

What I want to get is the min. date when the variable target is not missing but this code I have written doesn't achieve this. What's wrong? Also, I am trying to get the minimum of multiple variables, not just one but all have the condition of where target is not missing OR target2 is not missing.

I have read the documentation thru and thru on proc sql but still, the conditional statements seem to a problem...

thanks, Kristie

--------------------------------- Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo.