proc report data=sashelp.class nowd;
columns name sex age height weight ;
rbreak after/ summarize ;
run;
it gives all numeric variables sums but how to find one variable that is height (sum)
Name | Sex | Age | Height | Weight |
Alfred | M | 14 | 69 | 112.5 |
Alice | F | 13 | 56.5 | 84 |
Barbara | F | 13 | 65.3 | 98 |
Carol | F | 14 | 62.8 | 102.5 |
Henry | M | 14 | 63.5 | 102.5 |
James | M | 12 | 57.3 | 83 |
Jane | F | 12 | 59.8 | 84.5 |
Janet | F | 15 | 62.5 | 112.5 |
Jeffrey | M | 13 | 62.5 | 84 |
John | M | 12 | 59 | 99.5 |
Joyce | F | 11 | 51.3 | 50.5 |
Judy | F | 14 | 64.3 | 90 |
Louise | F | 12 | 56.3 | 77 |
Mary | F | 15 | 66.5 | 112 |
Philip | M | 16 | 72 | 150 |
Robert | M | 12 | 64.8 | 128 |
Ronald | M | 15 | 67 | 133 |
Thomas | M | 11 | 57.5 | 85 |
William | M | 15 | 66.5 | 112 |
|
| 253 | 1184.4 | 1900.5 |
like this?
proc report data=sashelp.class nowd;
columns name sex age height weight ;
define age/display;
define height/display;
rbreak after/ summarize;
run;
You can read about Analysis and Display variables in the relevant section of the PROC REPORT Documentation.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.