hi all: my code is: proc report data=sashelp.class nowd split='*'; column ('sex' sex) ('age' age) name ,( height weight ) height=ht weight=wt var2; define name / across '' ; define sex / group ''; define age / analysis ''; define height / analysis ''; define weight / analysis '' ; define ht / analysis '' noprint; define wt / analysis '' noprint; define var2 / computed " " style(column)={just=c protectspecialchars=off cellwidth=1.5in}; compute var2 / character length=75; var2 = catt(put(wt,5.0),'(',put(ht,5.1),')'); endcomp; break after sex /summarize; rbreak after/ summarize dol dul; run; How to use the "proc report" to get the following data: sex age Alfred Alice Barbara Carol Henry James Jane Janet Jeffrey John Joyce Judy Louise Mary Philip Robert Ronald Thomas William F 119 . 56.5(84) 65.3(98) 62.8(102.5) . . 59.8(62.5) 62.5(112.5) . . 51.3(50.5) 64.3(90) 56.3(77) 66.5(112) . . . . . 811(545.3) F 119 . 56.5(84) 65.3(98) 62.8(102.5) . . 59.8(62.5) 62.5(112.5) . . 51.3(50.5) 64.3(90) 56.3(77) 66.5(112) . . . . . 811(545.3) M 134 69(112.5) . . . 63.5(102.5) 57.3(83) . . 62.5(84) 59(99.5) . . . . 72(150) 64.8(128) 67(133) 57.5(85) 66.5(112) 1090(639.1) M 134 69(112.5) . . . 63.5(102.5) 57.3(83) . . 62.5(84) 59(99.5) . . . . 72(150) 64.8(128) 67(133) 57.5(85) 66.5(112) 1090(639.1) 253 69(112.5) 56.5(84) 65.3(98) 62.8(102.5) 63.5(102.5) 57.3(83) 59.8(62.5) 62.5(112.5) 62.5(84) 59(99.5) 51.3(50.5) 64.3(90) 56.3(77) 66.5(112) 72(150) 64.8(128) 67(133) 57.5(85) 66.5(112) 1901( 1184)
... View more