delete rows after certain group

monday89 — Fri, 29 May 2020 19:22:02 GMT

I have the following dataset. What I want to do is that if group = treatment, i would like to drop all the records AFTER formgroup = 'surgical'

ID	date_time	volume	formgroup	group
1234	1/2/2020 13:12	53.1	first	placebo
1234	1/2/2020 20:12	32.9	second	placebo
1234	1/3/2020 9:12	23.1	third	placebo
4522	3/2/2020 1:19	20.5	first	treatment
4522	3/2/2020 14:10	24.1	surgery	treatment
4522	3/3/2020 13:12	19.2	third	treatment

I have no idea how to start.

ID	date_time	volume	formgroup	group
1234	1/2/2020 13:12	53.1	first	placebo
1234	1/2/2020 20:12	32.9	second	placebo
1234	1/3/2020 9:12	23.1	third	placebo
4522	3/2/2020 1:19	20.5	first	treatment
4522	3/2/2020 14:10	24.1	surgery	treatment

i was thinking adding if statement then delete row

Re: delete rows after certain group

novinosrin — Fri, 29 May 2020 19:26:24 GMT


data have;
input ID	date_time $18. 	(volume	formgroup	group) (:$15.);
cards;
1234	1/2/2020 13:12	53.1	first	placebo
1234	1/2/2020 20:12	32.9	second	placebo
1234	1/3/2020 9:12	23.1	third	placebo
4522	3/2/2020 1:19	20.5	first	treatment
4522	3/2/2020 14:10	24.1	surgery	treatment
4522	3/3/2020 13:12	19.2	third	treatment
;

data want;
 do until(last.id);
  set have;
  by id;
  if _n_=0 then continue;
  if formgroup='surgery' and group='treatment' then _n_=0;
  output;
 end;
run;

topic delete rows after certain group in SAS Programming

delete rows after certain group

Re: delete rows after certain group