Have one more look at Proc Format and there at cntlin and cntlout
... or use simple SQL syntax:
data taxrates;
Year=2008; State='AK'; Taxrate=0.25; output;
Year=2009; State='AK'; Taxrate=0.35; output;
Year=2009; State='NY'; Taxrate=0.30; output;
run;
data have;
State='AK'; Year=2009; Taxrate='0.35'; AdjacentState='NY'; output;
run;
proc sql;
create table want as
select h.state, h.year, h.taxrate, h.AdjacentState,t.taxrate format=4.2 as AdjacentTax
from have as h left join taxrates as t
on h.year=t.year and h.AdjacentState=t.state;
quit;
... or use a hash object:
http://www2.sas.com/proceedings/sugi29/238-29.pdf
(article by one of my absolute favourites in the SAS field - advanced!)
... View more
