BookmarkSubscribeRSS Feed
sascode
Quartz | Level 8

Hello,

I have dataset as follows:
data have;
input binary Count Percent ;
datelines;
0 70 70
1 30 30
;
run;

 

I would like to add a total row using proc report  and to display as follows :
binary Count Percent

0           70       70
1           30       30

Total     100     100

Thank you.

3 REPLIES 3
PaigeMiller
Diamond | Level 26

Use

 

rbreak after 

as shown in this example: https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.4/proc/p1ai2km76blvcvn12ye0q6i3187a.htm

--
Paige Miller
sascode
Quartz | Level 8

PROC REPORT DATA = have;
columns binary COUNT PERCENT ;
define binary/ display ;
define COUNT/ analysis sum;
define PERCENT/ analysis sum;
rbreak after /summarize ;
compute after;
binary = 'Total';
endcomp;
RUN;

does not print the word "Total" , it displays it as missing.
Thank you.
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
  • 3 replies
  • 1650 views
  • 1 like
  • 2 in conversation