Dear Joost,

I was trying to apply the tutorial code
“Macro to adjust timeseries data for inflation (CPI)” but failed.

Under the %Array and %Do_over loop, sas comments
“ERROR 180-322: Statement is not valid or it is used out of proper order”

Could you help me check with the tutorial code and see if something is missing? Thank you.

pwyw000

hi Pwyw000,

Just before the code starts, there is a remark in red: important: this macro uses the %array and %do_over macros from Clay (available here http://www.sascommunity.org/wiki/Tight_Looping_with_Macro_Arrays).

Clay’s macro’s come in handy a lot, by the way.

best regards,

Joost

Joost,

I looked over that pdf file you attached through above link. But do you mean I have to add in some codes from that file?

Best,

Kejia

hi Kejia,

I have the code online, you can include this in your SAS code

I highly recommend to download the code and save it locally on your hard drive (Any code in that sas will execute—a security nightmare).

best regards,

Joost

Thank you, Joost.

pwyw000