DATA Step, Macro, Functions and more

Proc report grouping twice over two variables

Reply
Contributor
Posts: 53

Proc report grouping twice over two variables

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:

 

group variable.png

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.

Super User
Posts: 10,044

Re: Proc report grouping twice over two variables

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.


Ask a Question
Discussion stats
  • 1 reply
  • 69 views
  • 1 like
  • 2 in conversation