11-17-2014 10:34 AM
I need to obtain a total based to two group variables(Subgrp_Total shown in the below table).
I have tried calculating the cumulative total for the group by using the Id and Sub_group as the two by variable and the total obtained in the last observation of the sub group, but I need to assign the total for a sub group to each observation. Also is there a alternate way by using sas procedures.
Thanks in advance for the help!
Need further help from the community? Please ask a new question.