topic Re: SAS - Filter in New SAS User

SAS - Filter

usuario_estudo — Tue, 16 Oct 2018 14:53:40 GMT

Hi,

I need help writing a code on Sas Enterprise Guide.

I need to make a filter keeping only the last rows marking "Flag=1" for each ID number.

As shown in the table below in blue:

ID	Flag
1000	2
1000	1
1000	9
1000	1
1000	5
1000	1
1000	1
1000	1
1000	1
2000	11
2000	12
2000	4
2000	1
2000	1
2000	3
2000	1
2000	1
2000	1

Thank you very much!

Re: SAS - Filter

V_27 — Tue, 16 Oct 2018 15:23:12 GMT

Hi @usuario_estudo,

I didn't followed the question fully but here is an attempt.

data have;
input ID Flag;
datalines;
1000	2
1000	1
1000	9
1000	1
1000	5
1000	1
1000	1
1000	1
1000	1
2000	11
2000	12
2000	4
2000	1
2000	1
2000	3
2000	1
2000	1
2000	1
;
run;
proc sort data=have out=new;
by ID descending Flag;
run;
data want;
set new;
by ID;
if last.ID then output;
run;

Re: SAS - Filter

usuario_estudo — Tue, 16 Oct 2018 17:13:18 GMT

Thank you for the code, but it does not return the desired result.

I would like to return the following table:

ID	Flag
1000	1
1000	1
1000	1
1000	1
2000	1
2000	1
2000	1

Thank you very much!

Re: SAS - Filter

Ksharp — Wed, 17 Oct 2018 13:25:50 GMT

data have;
input ID Flag;
datalines;
1000	2
1000	1
1000	9
1000	1
1000	5
1000	1
1000	1
1000	1
1000	1
2000	11
2000	12
2000	4
2000	1
2000	1
2000	3
2000	1
2000	1
2000	1
;
run;
data want;
 do until(last.flag);
  set have;
  by id flag notsorted;
  if last.id then  found=1;
 end;
  do until(last.flag);
  set have;
  by id flag notsorted;
  if found and flag=1 then output;
 end;
 drop found;
 run;