topic Re: How to select values after multiple conditions in SAS Data Management

How to select values after multiple conditions

idaida — Tue, 29 Aug 2017 09:29:04 GMT

How I can select values after conditions inside multiple groups.

My data looks like

id day timep results flag 
1  1   0     23       
1  1   1     43      X
1  1   2     29                   
1  1   3     14       
2  1   0     17     
2  1   1     32   
2  1   2     54      X
2  1   3     59

How can I select values before X or after X inside the same ID.

For example the wanted output would be like this for before X

id day timep results flag 
1  1   0     23

and after X the results should be:

1  1   2     29                   
1  1   3     14

for id 1.

Re: How to select values after multiple conditions

WarrenKuhfeld — Tue, 29 Aug 2017 11:53:26 GMT

Here is one way.

data x; input id day timep results flag $; cards;
1  1   0     23       .
1  1   1     43      X
1  1   2     29      .             
1  1   3     14       .
2  1   0     17     .
2  1   1     32   .
2  1   2     54      X
2  1   3     59  .
; 
proc print;run;

data before;
set x(keep=flag);
if flag = 'X' then do;
   f = _n_ - 1;
   set x point=f;
   output;
   end;
run;
proc print; run;

data after;
set x(keep=flag) nobs=n;
if flag = 'X' and _n_ + 1 le n then do;
   f = _n_ + 1;
   set x point=f;
   output;
   end;
run;
proc print; run;

Re: How to select values after multiple conditions

Ksharp — Tue, 29 Aug 2017 12:26:15 GMT

data x; 
input id day timep results flag $; 
cards;
1  1   0     23       .
1  1   1     43      X
1  1   2     29      .             
1  1   3     14       .
2  1   0     17     .
2  1   1     32   .
2  1   2     54      X
2  1   3     59  .
; 
run;

data before after;
 set x;
 by id;
 retain found;
 if first.id then call missing(found);
 if flag='X' then found=1;
 if not found then output before;
  else if flag ne 'X' then output after;
  drop found;
run;