Hi, I have very limited knowledge of SAS and looking for help:
I have 3 col in table:
Year, State and Rate
2009 MA $150
2009 NH $80
2009 ME $55
2010 MA $155
2010 NH $87
2010 ME $60
I need to change the current Rates according to this statement:
if Year = 2009 and state is MA - Rate * 2
if Year = 2009 and state is NH - Rate * 3
if Year = 2009 and state is ME - Rate * 4
if Year = 2010 and state is MA - Rate * 1.5
if Year = 2010 and state is NH - Rate * 2
if Year = 2010 and state is ME - Rate * 2.5
Any ideas? Thank you
... View more