Hi There. I have this data, data A & B I want to ask your expertise how to divide value from total_balance (Data A) to every var cell in data B for each year to get the percentage, so it will show like the picture below. I usually do this manually on excel and I want to improve this. here is my code generate Data A proc tabulate data = data_a; table year, total_balance; var total_balance; class year; run; generate Data B proc tabulate data = lnsx3by; table year, MOBx*balance; var balance; class year MOBx; run; Thank you for your help
... View more