BookmarkSubscribeRSS Feed
Ronein
Onyx | Level 15

Hello

Why a summary row is not created here?

Data tbl;
input ID  y;
cards;
1 10
2 20
3 30
4 40
5 50
;
run;

proc report data=tbl nowd;
  column ID y ;
  define ID / display;
  define y / display;
  rbreak after / summarize;
run;
1 REPLY 1
PeterClemmensen
Tourmaline | Level 20

Because you define all the variables as display variables. PROC REPORT creates a summary row for analysis variables only. If you define y as an analysis variable like below, a summary row is created

proc report data=tbl nowd;
  column ID y ;
  define ID / display;
  define y / analysis;
  rbreak after / 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
  • 841 views
  • 0 likes
  • 2 in conversation