Rename quarter and years?
Posted: Thu Sep 20, 2012 6:56 am
Is there an easy way to rename quarters and years in an existing workfile. I have data already read in that is quarterly. After doing some initial calculations, I want to reallocate the data so that data for 1990 Quarter 1 becomes the data for 1990 Quarter 2; 1990Q2 becomes 1990Q3; 1990Q3 becomes 1990Q4; 1990Q4 becomes 1991Q1; 1991Q1 becomes 1991 Q2 and so on, through the end of my data set. Data for each quarter would now become the data for the next quarter, with quarter 4 data becoming first quarter data for the next year. I'm not sure where to start.
Thanks for any suggestions.
Thanks for any suggestions.