No, @Reeza's code with the small edit by you works perfectly at my end now. I was in Enterprise Guide, not SAS 9.4 (face palm) I told you guys I am new to this 🙂 Now, I need to figure out how to incorporate this with my extremely large dataset. It said I submitted a code that contains lines longer than 6000 characters and aborted the submission lol. I broke it up by year and lower variables (I have up to 200+ and working with 5 years' worth of monthly data).   Thank you both very much. Much appreciated for the code to work off from!  ... View more

Hope you had a great weekend. I tried your top code - no errors and calculated correctly. But it only calculated Jan 2022's numbers. I'm thinking I need to incorporate DO loops? Second code with transposing would still need repetitive coding for the other rates. Thank you though! ... View more

@Quentin You are so kind for all your msgs and code! I did not know I would get such support asking on here. 🙂 I will test out your code on Monday and let you know. Have a great weekend! ... View more

I tested it out, and it did not work. I will check out the UCLA source you provided. 🙂 ... View more

Thanks so much Reeza! I'll test this code out with my data set. ... View more

I am new. I apologize. Here is what was similar to my example in the Excel sheet. I'll work on creating that test code with the instructions you provided. Thanks ballardw. 🙂   Dataset Month Year Population Variable 1 Variable 2 Variable 3 Jan 2022 20 1 0 1 Feb 2022 40 0 1 7 Mar 2022 60 2 8 3   Desired Month Year Population Variable 1 Calc Rate 1 Variable 2 Calc Rate 2 Variable 3 Calc Rate 3 Jan 2022 20 1 1/20*100  0 0/20*100 1 1/20*100 Feb 2022 40 0 0/40*100 1 1/40*100 7 7/40*100 Mar 2022 60 2 2/60*100 8 8/60*100 3 3/60*100 ... View more

Hi Quentin, Thanks for the reply! I uploaded an example in Excel. First tab is the data. Second tab is the desired additional calculated columns. Do you think I need to transpose this data to get the code to work?   ... View more