Advertisement
Guest User

Untitled

a guest
Dec 6th, 2016
54
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.42 KB | None | 0 0
  1. data df1;
  2. set df;
  3. by id;
  4. retain flag_final;
  5. if first.id then do;
  6. if flag eq 0 then flag_final=flag;
  7. else flag_final=.;
  8. end;
  9. else do;
  10. flag_final=flag_final;
  11. end;
  12. new_col=id;
  13. run;
  14.  
  15. df_temp=df[['id','flag']]
  16. df1= df.merge(df_temp.groupby('id').first().reset_index(), on='id').rename(
  17. columns={'flag_x':'flag', 'flag_y':'flag_final'})
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement