topic Help me solve in best way possible without creating extra variables in SAS Programming

Help me solve in best way possible without creating extra variables

deleted_user — Fri, 21 Aug 2009 11:42:07 GMT

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..

Re: Help me solve in best way possible without creating extra variables

Flip — Fri, 21 Aug 2009 12:46:58 GMT

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;

Re: Help me solve in best way possible without creating extra variables

deleted_user — Mon, 24 Aug 2009 15:49:04 GMT

Thanks a ton!!