Help me solve in best way possible without creating extra variables

[deleted_user]

Hi,

i just need to retain records where for every unique value of var1,
if var2 hold values 'g' & 'b' then should reatin rows with value 'g',
else if it hold only 'g' all the rows, if only 'b' even all the rows should be retianed,
i have enclosed the ouput which would help understand much better.

data a;
input var1 var2 $;
datalines;
1 g
1 g
1 b
1 g
2 b
2 b
3 g
3 g
;
run;

o/p
1 g
1 g
1 g
2 b
2 b
3 g
3 g

Thanks!
Sri..

[Flip]

proc sql;

create table two as select a.* from a
where put(var1, 1.)|| var2 in (select put(var1, 1.)|| max(var2) from a group by var1);
quit;

[deleted_user]

Thanks a ton!!