SAS Base

Pandu — Fri, 04 Mar 2022 02:32:03 GMT

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.

Re: SAS Base

japelin — Fri, 04 Mar 2022 02:52:48 GMT

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;