I have a SAS datasets. I have 18 month columns:
Jul21 Aug21 Sep21 Oct21 Nov21 Dec21 Jan22 Feb22 Mar22 May22 Apr22 Jun22 Jul22 Aug22 Sep22 Oct22 Nov22
Dec22
Each of them has values between 1-100 for each record. I also have a reference_month column which has month values in numbers between 1 to 12. I want to create 7 new columns score0 to score6. For example score0, score1, etc... They will get their values between the column's values starting from Jan22 to Dec22, depending on the reference_month. For example, If reference_month is 1, score0 column will take the value of Jan22 column. If reference_month is 2, score0 column will take the value of Feb22 column. If reference_month is 3, score0 column will take the value of Mar22 column. ... If reference_month is 12, score0 column will take the value of Dec22 column. Then the other 6 score columns (score1, score2, ..., score6) will take he value of the previous month's. For example, If reference_month is 1, score1 column will take the value of Dec21 column score2 column will take the value of Nov21 column score3 column will take the value of Oct21 column score4 column will take the value of Sep21 column score5 column will take the value of Aug21 column score6 column will take the value of Jul21 column How can I do this? Thank you!
... View more