the tutorial to generate inflation adjusted time series. 
Posted: 02 January 2013 09:08 PM   [ Ignore ]
Newbie
Rank
Total Posts:  23
Joined  2012-10-24

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

Profile
 
 
Posted: 02 January 2013 09:34 PM   [ Ignore ]   [ # 1 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

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

 Signature 

To reply/post new questions: Please use the group WRDS/SAS on Google Groups! http://groups.google.com/d/forum/wrdssas

Profile
 
 
Posted: 02 January 2013 09:38 PM   [ Ignore ]   [ # 2 ]
Newbie
Rank
Total Posts:  23
Joined  2012-10-24

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

Profile
 
 
Posted: 02 January 2013 10:20 PM   [ Ignore ]   [ # 3 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

hi Kejia,

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

filename m1 url 'http://www.wrds.us/macros/array_functions.sas';
%include 
m1

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

 Signature 

To reply/post new questions: Please use the group WRDS/SAS on Google Groups! http://groups.google.com/d/forum/wrdssas

Profile
 
 
Posted: 04 January 2013 07:37 AM   [ Ignore ]   [ # 4 ]
Newbie
Rank
Total Posts:  23
Joined  2012-10-24

Thank you, Joost.

pwyw000

Profile