- **请问:proc means的输出中: 如何不显示年龄组但能使年龄组(岁)按照年龄组的顺序排序?谢谢!;
- data xsbhg2(keep=id county school grade sex nation birth date age age1 age2 weight height1 height2 sclname bmi);
- set xsbhg1;
-
- length age1 3;
- length age2 $ 4;
- format age best4.1;
- format age1 best2.;
- format age2 $4.;
- age=round((date-birth)/365.25,0.1); *date=调查日期,birth=出生日期;
- if age^=. and age<=5 then delete;
- if 6<=age<7 then age1=6;
- else if 7<=age<8 then age1=7;
- else if 8<=age<9 then age1=8;
- else if 9<=age<10 then age1=9;
- else if 10<=age<11 then age1=10;
- else if 11<=age<12 then age1=11;
- else if 12<=age<13 then age1=12;
- else if 13<=age<14 then age1=13;
- else if 14<=age<15 then age1=14;
- else if 15<=age<16 then age1=15;
- else if 16<=age<17 then age1=16;
- else if 17<=age<18 then age1=17;
- else if 18<=age<19 then age1=18;
- else if 19<=age<20 then age1=19;
- else if 20<=age<21 then age1=20;
- else if 21<=age<22 then age1=21;
- else if 22<=age<23 then age1=22;
- if 6<=age<7 then age2="6-";
- else if 7<=age<8 then age2="7-";
- else if 8<=age<9 then age2="8-";
- else if 9<=age<10 then age2="9-";
- else if 10<=age<11 then age2="10-";
- else if 11<=age<12 then age2="11-";
- else if 12<=age<13 then age2="12-";
- else if 13<=age<14 then age2="13-";
- else if 14<=age<15 then age2="14-";
- else if 15<=age<16 then age2="15-";
- else if 16<=age<17 then age2="16-";
- else if 17<=age<18 then age2="17-";
- else if 18<=age<19 then age2="18-";
- else if 19<=age<20 then age2="19-";
- else if 20<=age<21 then age2="20-";
- else if 21<=age<22 then age2="21-";
- else if 22<=age<23 then age2="22-";
- bmi=weight/((height2/100)*(height2/100)); *bmi=体重指数;
- label height2="身高(cm)"
- sex="性别"
- age1="年龄组"
- age2="年龄组(岁)"
- bmi="体质指数";
- run;
- proc means data=xsbhg2 n min max mean std median qrange;
- *format age1 $age_.;
- class sex age1 age2;
- var height2 weight bmi;
- output out=agehw;
- run;