Hi SAS Master,    I want to ask, how to simplify this IF-ELSE statement on SAS. Below is the code:   data test; if year = 0 then bucket = 'M0 '; else if year = 1 then bucket = 'M1 '; else if year = 2 then bucket = 'M2 '; else if year = 3 then bucket = 'M3 '; else if year = 4 then bucket = 'M4 '; else if year = 5 then bucket = 'M5 '; else if year = 6 then bucket = 'M6 '; else bucket = 'WO' ; run;   feel free to format the bucket whether this char or numeric.  thank you. ... View more

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

Hi SAS Expert.    I want to ask how to do cumulative sum on previous cell for each row. Here is data from proc tabulate:   The output I want.  So basically the value is the sum from previous cell.   Here is the code i use to to proc tabulate   proc tabulate data = daybalance; table year, day*balance; var balance; class year day; run;   Kindly help with this if you know thank you for your help it means a lot for me. ... View more