SAS Base

[Pandu]

Hi,

data abc;
input name$ status sal;
datalines;
hhh 0 4500
hhh 1 5600
ddd 0 7688
uhd 1 7544
yhd 0 6666
;
run;

i have 3 variables name , status and sal.

i want to pick status 0 when the names are same(as 0 is original status and 1 is duplicated).

ex: we have two observation above with same name 

hhh 0
hhh 1

so i want to pick the values with 0 status.

thanks in advance.

[japelin · Accepted solution]

If you only have either 0 or 1 Status per person, how about the following code to do it?

proc sort data=abc out=sorted;
  by name status;
run;

data want;
  set sorted;
  by name status;
  if first.name;
run;