topic Re: update status if one meets the criteria in a group in SAS Programming

update status if one meets the criteria in a group

Yvegunta — Fri, 18 Nov 2016 00:06:30 GMT

Hi Everyone

I have created this table, however what i need is the "Status" to be "Not Verified" for all, if one of them is "Not Verified" for the same name.

Current Table:

What i am ideally looking for is:

Thank you

Shmuel — Fri, 18 Nov 2016 01:55:28 GMT

proc sql;

create table want as

select name, rule,

case when (name in (select name from have where rule='not verified'))

then 'not verified' else 'verified' end as status

from have;

quit;

mkeintz — Fri, 18 Nov 2016 02:02:46 GMT

If your data are sorted by name then it's straighforward:

data want;
  merge have
        have (keep=name status where=(status='not Verified'));
  by name;
run;

Yvegunta — Fri, 18 Nov 2016 02:33:17 GMT

Thank you Shmuel, worked exactly as I wanted it.