Hi Friend, I am new to SAS and while solving the problem stuck in very basic step. I have three coloumn data is like Grade sub Grade and their average value. I have take average of Grade and Sub-grade. Thank you... Data Example InputData Output Col 1 Col 2 Avg Average of Avg A A1 15 Col 1 Col 2 Total A A2 13 A A1 15 A A3 16 A2 13 A A4 11 A3 16 B B1 12 A4 11 B B2 11 A Avg 13.75 B B3 13 B B1 12 C C1 17 B2 11 C C2 18 B3 13 C C3 13 B Avg 12 C C4 20 C C1 17 C C5 20 C2 18 C3 13 C4 20 C5 20 C Avg 17.6 Grand Total 14.91666667
... View more