topic change value in SAS Programming

change value

SASPhile — Mon, 30 Nov 2009 14:47:06 GMT

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

Re: change value

Flip — Mon, 30 Nov 2009 14:59:01 GMT

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

Re: change value

SASPhile — Mon, 30 Nov 2009 15:33:57 GMT

Thanks Flip.