topic determining first encounter of event in SAS Programming

determining first encounter of event

sbopster — Mon, 29 Jun 2020 18:08:34 GMT

How can I determine the first encounter of the condition and flag it? I need to flag that 'M' had occurred on 06/02/2020 so I can not count cond 'M' as the first encounter on 06/12/2020.

data wide ; 
  input id $ date MMDDYY10. cond1 $ cond2 $; 
  format date date9.;
datalines ; 
1 06/02/2020 M Z
1 06/12/2020 B M  
2 06/22/2020 M B
   
;

Re: determining first encounter of event

ballardw — Mon, 29 Jun 2020 18:13:55 GMT

So if we can't take the first occurrence what is the rule that says we can use the second?

Is it that must occur in a specific variable? Only as the second mention regardless of variable? Something else?

If the rule is a bit complicated you may need to provide more examples of the types of combinations occur and then indicate which are counted.

It will also help if show what the output should look like.

Re: determining first encounter of event

smantha — Mon, 29 Jun 2020 18:31:55 GMT

data wide ; 
  input id $ date MMDDYY10. cond1 $ cond2 $; 
  format date date9.;
datalines ; 
1 06/02/2020 M Z
1 06/12/2020 B M  
2 06/22/2020 M B
   
; 
run;
proc transpose data=wide out=tall;
by id date;
var cond:;
run;

proc sort; by id col1 date;
run;

data tall;
set tall;
by id col1 date;
if first.col1;
run;

By using the above code you get first encounter for each of the conditions. Is this what you want?

Re: determining first encounter of event

sbopster — Tue, 30 Jun 2020 06:05:52 GMT

yes that works. I was using an array. thank you.