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.


hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

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
  • 1006 views
  • 1 like
  • 2 in conversation