DATA Step, Macro, Functions and more

change value

Reply
Super Contributor
Posts: 673

change value

provider id yr
M 908000 0
M 908000 1937
A 1001750 2000
A 1001750 2003

I have a situation where for a single if there are differenr yr's.
1.if the yr is 0, how to change the value of that yr to the other year value the id has.
for M 90800 should take 1937.
similarly for provider A if there are different values take the first value i.e 2000
Super Contributor
Posts: 359

Re: change value

create table fix as select provider, id, min(yr) as myr
from xxx where yr ^= 0 group by provider, id;
update xxx a set yr = (select myr from fix b where a.provider = b.provider and a.id = b.id);
Super Contributor
Posts: 673

Re: change value

Thanks Flip.
Ask a Question
Discussion stats
  • 2 replies
  • 113 views
  • 0 likes
  • 2 in conversation