BookmarkSubscribeRSS Feed
Matt3
Quartz | Level 8

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.

1 REPLY 1
Ksharp
Super User
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.


How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1141 views
  • 1 like
  • 2 in conversation