I cross verified with my colleague and your approach and output is right. I was confused with the percentage calculation. Thanks for your help in brief.
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9. Sign up by Dec. 31 to get the 2024 rate of just $495. Register now!
How to Concatenate Values
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.