Proc report grouping twice over two variables

Matt3 — Tue, 24 Oct 2017 07:13:13 GMT

Hi,

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

Thank you.

Re: Proc report grouping twice over two variables

Ksharp — Tue, 24 Oct 2017 13:11:02 GMT

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.

topic Proc report grouping twice over two variables in SAS Programming

Proc report grouping twice over two variables

Re: Proc report grouping twice over two variables