BookmarkSubscribeRSS Feed
thanikondharish
Calcite | Level 5

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

2 REPLIES 2
PeterClemmensen
Tourmaline | Level 20

like this?

 

proc report data=sashelp.class nowd;
columns name sex age height weight ;
define age/display;
define height/display;
rbreak after/ summarize;
run;
PeterClemmensen
Tourmaline | Level 20

You can read about Analysis and Display variables in the relevant section of the PROC REPORT Documentation.

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


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