10-24-2017 03:13 AM
could anyone please tell me if is it possible to group over one variable and then use another group in same table.
I would like to obtain results like that:
GroupVar1 - first level grouping variable
Var2 - sum of var2 in datasets grouped by GroupVar1
GroupVar3 - second level grouping variable
Var4, Var5 - sum of variables grouped by GroupVar1 and GroupVar3
10-24-2017 09:11 AM
You need calculated the sum of var2 firstly, after that PROC REPORT. Better post some sample data and post your question about PROC REPORT at REPORT forum, @Cynthia is there.