BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
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 ACCEPTED SOLUTION

Accepted Solutions
BrunoMueller
SAS Super FREQ

This can be done with Proc REPORT, you do need to add a dummy content column for the first summarized var.

 

The code below shows an example, please note that there are some additional statements, that where added for verification of the result.

 


data cars;
  set sashelp.cars;
  hpg = 1;
run;
proc report data=cars spanrows;
  column origin hpg horsepower=hpsum type invoice cylinders _dummy;
  define origin / group style={textalign=center VERTICALALIGN=MIDDLE };
  define hpg / group style={textalign=center VERTICALALIGN=MIDDLE };
  define hpsum / analysis sum
/*    noprint*/
  ;
  define type / group;
  define cylinders / analysis;
  define invoice / analysis;
  define _dummy / computed
/*    noprint*/
  ;

  compute before origin;
     tempHpg = hpsum;
  endcomp;

  /* assign value to grouping var */
  compute _dummy;
    /* just for verification */
    _dummy = tempHpg;
    hpg = tempHpg;
  endcomp;

  /* just for validation */
  break after origin / summarize;
run;

View solution in original post

1 REPLY 1
BrunoMueller
SAS Super FREQ

This can be done with Proc REPORT, you do need to add a dummy content column for the first summarized var.

 

The code below shows an example, please note that there are some additional statements, that where added for verification of the result.

 


data cars;
  set sashelp.cars;
  hpg = 1;
run;
proc report data=cars spanrows;
  column origin hpg horsepower=hpsum type invoice cylinders _dummy;
  define origin / group style={textalign=center VERTICALALIGN=MIDDLE };
  define hpg / group style={textalign=center VERTICALALIGN=MIDDLE };
  define hpsum / analysis sum
/*    noprint*/
  ;
  define type / group;
  define cylinders / analysis;
  define invoice / analysis;
  define _dummy / computed
/*    noprint*/
  ;

  compute before origin;
     tempHpg = hpsum;
  endcomp;

  /* assign value to grouping var */
  compute _dummy;
    /* just for verification */
    _dummy = tempHpg;
    hpg = tempHpg;
  endcomp;

  /* just for validation */
  break after origin / summarize;
run;

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

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
  • 1742 views
  • 0 likes
  • 2 in conversation