change value

[SASPhile]

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

[Flip]

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);

[SASPhile]

Thanks Flip.