sas数据集例题.docx

1、sas数据集例题sas数据集例题LT结果分析一、(1)data class;input id biochemistry$physical pathology;label id=学号 biochemistry=生化 physical=物理 pathology=病理;cards;083 68 71 65084 74 61 68085 73 75 46087 75 71 68084 85 85 87085 78 79 75086 80 76 79089 67 73 71118 70 54 75083 70 66 84084 62 73 65099 82 70 79;run;proc print da

2、ta=class label;run;(2)(3)data class;input id biochemistry $ physical $ pathology $ ave $ ;label id=学号 biochemistry=生化 physical=物理 pathology=病理;ave=mean(biochemistry,physical,pathology); if ave60then ave=E; if 60=ave70then ave=D; if 70=ave=79then ave=C; if 80=ave=89then ave=B; if 90=ave90 and conpute

3、r90;run;proc print;run;三首先导入数据集 data liangbiao; MERGE D1 D2; data lb; set liangbiao D3; proc export data=lb outfile=d:cymSAS作业量表.sav REPLACE ; data lb; array lb72 a1-a50 b1-b22; set lb; lb(1)=6-lb(1);lb(5)=6-lb(5);lb(30)=6-lb(30);lb(43)=6-lb(43); lb(49)=6-lb(49);lb(52)=6-lb(52);lb(56)=6-lb(56);lb(69

4、)=6-lb(69); sum1=sum(of a1-a25); sum2=sum(of a26-a50); sum3=sum(of b1-b22); data lb; set lb; proc standard data=lb out=lb replace; var sum1 sum2 sum3; run; proc sort data=lb; by sum3; data cheng; input group ; datalines; 1 1 1 1 1 1 1 1 1 1 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 3 3 3 3 3 3 3 3 3 3 run; data lg; MERGE lb cheng; run; data lg; set lg; if (group = 1) then sum=高分组; if (group = 2) then sum=中间组; if (group = 3) then sum=低分组; run;结果如下： 成 绩 教师签名