SAS上机练习试题[全部,含参考答案解析]

1、重庆医科大学-卫生统计学统计软件包SAS上机练习题一1、SAS常用的窗口有哪三个？请在三个根本窗口之间切换并记住这些命令或功能键.2、请在PGM窗口中输入如下几行程序,提交系统执行,并查看OUTPUT窗和LOG窗中内容,注意不同颜色的含义；并根据日志窗中的信息修改完善程序.DATSEX0101;INPUTTNAME$AGESEX;CARDS;XIAOMIN191LIDONG201NANA1825PRODPRONTDATS=EX1;RUN;PROCPRINTDATA=EX1;VARNAMEAGE;RUN;3、将第2题的程序、结果及日志保存到磁盘.4、试根据如下例1的程序完成后面的问题：表1某班1

2、6名学生3门功课成绩表如下问题：1建立数据集；2打印至少有1门功课不及格同学的信息；提示,使用if语句dataa;inputidshwlbl;cards;083687165084746168085737546086798079087757168084858587085787975086807679087858082088777175089677371080758170118705475083706684084627365099827079;run;datab;seta;ifsh60orwl60orbl60thenoutput;run;procprintdata=b;varidshwlbl;ru

3、n;5、根据以下数据建立数据集表2销售数据开始时间终止时间费用2005/04/2825MAY2021$123,345,0002005091805OCT2021$33,234,5002007/08/1222SEP2021$345,6002004050830JUN2021$432,334,500提示：格式化输入；数据之间以空格分隔,数据对齐；注意格式后面的长度应以前一个位置结束开始计算,如果读入错误,可试着调整格式的宽度；显示日期需要使用输出格式开始时间,输入格式yymmdd10.终止时间,输入格式date10.费用,输入格式dollar12.参考程序:dataa;inputx1yymmdd10.

4、x2date10.x3dollar13.cards;2005/04/2825MAY2021$123,345,0002005091805OCT2021$33,234,5002007/08/1222SEP2021$345,6002004050830JUN2021$432,334,500;run;procprint;run;procprint;formatx1yymmdd10.x2date9.x3dollar13.run;6、号一编码规那么一般是：YYY-XXXX-ZZZZ,其YYY为号段；XXXX一般为所在地区编码；ZZZZ为对应的个人识别编号.下面有一组号(来源于网络,末位以X替换),请用程序完

5、成下列要求：(1)分别列出属于联通、移动、电信的号；(2)分别提取地区编号及个人识别编号.(提示：列输入方式或者字符串操作)说明：移动：134-139、150、151、152、157、158、159、188联通：130、131、132、155、156电信：133、153、180、189号号1508320464X1313654836X1510291126X1351425709X1339644156X1303612231X1532464828X1383824855X1365721647X1522322763X1523105754X1357851051X1592624347X1508311759X1

6、331237668X1327313520X1370048578X1556443719X1507244457X1804346016X1321246707X1513441713X1368464734X1308279203X1394913242X1897876466X参考程序：dataa;inputy1-3x$4-7z$8-11;if134=y=139oryin(150,151,152,157,158,159,188)thenygrp=移动;ifyin(130,131,132,155,156)thenygrp=联通;ifyin(133,153,180,189)thenygrp=电信；cards;15

7、08320464X1510291126X1339644156X0000001513441713X1308279203X1897876466X;procprint;run;7、下表是某班学生几门功课的成绩,其中形势课是考查课,其它均为测试课.请完成以下处理并且保存程序、结果和日志：(注意函数在DATASTEP中使用的位置)(1)用Mean()函数求出每位同学的平均分,将其保存在变量中；(2)用sum()函数或者表达式求出每位同学的总分,将其保存在变量中；(3)如果每门测试课权重是0.75,每门考查课权重为0.25,试求每位同学的加权平均分；(4)将数据集保存为永久数据集,保存位置为“；(5)调用

8、上面的永久数据集,并将男、女生的成绩分别保存在数据集Dmale和Dfemale中.表3某班同学几门功课的成绩学号性别(0=女,1=男)高数生理人解数理统计形势(考查)08317373647475)4141907971857805641978789918007741406061657508731686560767508741746856607508751734665668708761797974898708771756855607008781766064718008801817360758208811768184897808831776060667508840858784859008850787

9、5626680088608079777383088708582818480088807775746780088906771716990089007570756980089106976767990089206671606078089317084758085089416265656981089519178616678089615160424478089816773677385089917972786880090017668638490090108170708279参考程序：libnamepbD:mydata;datapb.score;inputid$xbgsslrjsltjxs;mscore=me

10、an(ofgsslrjsltjxs);tscore=sum(ofgsslrjsltjxs);wmscore=(gs+sl+rj+sltj)*0.75+xs*0.25)/(0.75*4+0.25);cards;0083173736474750414190797185780564197878991800774140606165750873168656076750874174685660750875173466566870876179797489870877175685560700878176606471800880181736075820881176818489780883177606066750

11、88408587848590088507875626680088608079777383088708582818480088807775746780088906771716990089007570756980089106976767990089206671606078089317084758085089416265656981089519178616678089615160424478089816773677385089917972786880090017668638490090108170708279Jdatadmaledfemale;setpb.score;ifxb=1thenoutput

12、dmale;ifxb=0thenoutputdfemale;run;8、下面是3个大类疾病的ICD-10编码及对应的疾病名.请完成以下任务：(1)建立数据集；(2)提取每种疾病的大类编码；(3)分别将3个大类的疾病存入3个数据集.(提示：ICD10编码中小数点前面的三位表示大类；length语句定义字符变量长度；字符串取子串函数)表44类疾病的ICD10编码及对应疾病名ICD10DiseaseA01.001伤寒A01.002A01.003+伤寒杆菌性败血症伤寒性脑膜炎A01.101甲型副伤寒A01.201A01.301A01.401乙型副伤寒丙型副伤寒副伤寒A02.001B群沙门氏菌肠炎A02

13、.002A02.004C群沙门氏菌肠炎沙门氏菌性肠炎A02.006沙门氏菌胃肠炎A02.007鼠伤寒沙门氏菌性肠炎A02.008婴儿沙门氏菌肠炎A02.101沙门氏菌败血症A02.201+沙门氏菌性肺炎A02.202+沙门氏菌性关节炎A02.203+沙门氏菌性脑膜炎A02.901沙门氏菌感染A02.902鼠伤寒沙门氏菌感染A02.903沙门氏菌属食物中毒A03.001什密氏志贺菌痢疾A03.101弗氏志贺菌痢疾A03.201鲍氏志贺菌痢疾A03.301宋内氏志贺菌痢疾A03.802菌痢混合感染A03.901细菌性痢疾A03.902慢性细菌性痢疾急性发作A03.903慢性细菌性痢疾A03.905

14、慢性迁延型细菌性痢疾A03.906中毒性痢疾参考程序：dataa;inputICD10$Disease:$24.;cat=substr(ICD10,1,3);cards;A01.001伤寒A01.002伤寒杆菌性败血症A01.003+伤寒性脑膜炎A01.101甲型副伤寒A01.201乙型副伤寒A01.301丙型副伤寒A01.401副伤寒A02.001端沙门氏菌肠炎A02.002C群沙门氏菌肠炎A02.004沙门氏菌性肠炎A02.006沙门氏菌胃肠炎A02.007鼠伤寒沙门氏菌性肠炎A02.008婴儿沙门氏菌肠炎A02.101沙门氏菌败血症A02.201+沙门氏菌性肺炎A02.202+沙门氏菌性

15、关节炎A02.203+沙门氏菌性脑膜炎A02.901沙门氏菌感染|A02.902鼠伤寒沙门氏菌感染A02.903沙门氏菌属食物中毒A03.001什密氏志贺菌痢疾A03.101弗氏志贺菌痢疾A03.201鲍氏志贺菌痢疾A03.301宋内氏志贺菌痢疾A03.802菌痢混合感染A03.901细菌性痢疾A03.902慢性细菌性痢疾急性发作A03.903慢性细菌性痢疾A03.905慢性迁延型细菌性痢疾A03.906中毒性痢疾；datacat01cat02cat03;seta;ifcat=A01thenoutputcat01;ifcat=A02thenoutputcat02;ifcat=A03thenou

16、tputcat03;run;9、现有两个文件,内容如下:A文件B文件学号统计体育年龄学号性别班级0187832301男10256962202女10393751903男30477842404男20588551805女208女3要求：打印至少有一门功课不及格的同学的年龄、性别和班级.参考程序：datafileA;inputno$tjtyage;cards;0187832302569622039375190477842405885518；datafileB;inputno$sex$bj;cards;男女男男女女1020304050813223Jprocsortdata=fileA;byno;proc

17、sortdata=fileB;byno;datafileAB;mergefileAfileB;byno;ifmin(tj,ty)run;procprint;run;10、显示100到200以内的素数.(提示：素数即只能被1和本身整除的数,如2,3,5,7等等；循环语句,条件语句,取余数函数mod(a,b)参考程序:dataa;doi=100to200;flag=0;doj=2toi-1;ifmod(i,j)=0thenflag=1;end;ifflag=0thenoutput;end;keeprun;procprint;run;彭斌,2021-3-23SAS上机练习题(二)1、某农村地区199

18、9年14岁女孩的身高资料列于表1.表1谋农村地区1999年14岁女孩身高资料(cm)142.3148.8142.7144.4144.7145.1143.3154.2152.3142.7156.6137.9143.9141.2139.3145.8142.2137.9141.2150.6142.7151.3142.4141.5141.9147.9125.8139.9148.9154.9145.7140.8139.6148.8147.8146.7132.7149.7154.0158.2138.2149.8151.1140.1140.5143.4152.9147.5147.7162.6141.6143

19、.6144.0150.6138.9150.8147.9136.9146.5130.6142.5149.0145.4139.5148.9144.5141.8148.1145.4134.6130.5145.2146.2146.4142.4137.1141.4144.0129.4142.8132.1141.8143.3143.8134.7147.1140.9137.4142.5146.6135.5146.8156.3150.0147.3142.9141.4134.7138.5146.6134.5135.1141.9142.1138.1134.9146.7138.5139.6139.2148.8150

20、.3140.7143.5140.2143.6138.7138.9143.5139.9134.4133.1145.9139.2137.4142.3160.9137.7142.9126.8问题：(1)计算均数、中位数；计算均数的95%可信区间;(2)计算四分位间距、标准差、变异系数；计算标准误;(3)请进行正态性检验；(4)观察频数分布情况；参考程序:dataa;inputx;cards;142.3148.8142.7144.4144.7145.1143.3154.2152.3142.7156.6137.9143.9141.2139.3145.8142.2137.9141.2150.6142.71

21、51.3142.4141.5141.9147.9125.8139.9148.9154.9145.7140.8139.6148.8147.8146.7132.7149.7154.0158.2138.2149.8151.1140.1140.5143.4152.9147.5147.7162.6141.6143.6144.0150.6138.9150.8147.9136.9146.5130.6142.5149.0145.4139.5148.9144.5141.8148.1145.4134.6130.5145.2146.2146.4142.4137.1141.4144.0129.4142.8132.11

22、41.8143.3143.8134.7147.1140.9137.4142.5146.6135.5146.8156.3150.0147.3142.9141.4134.7138.5146.6134.5135.1141.9142.1138.1134.9146.7138.5139.6139.2148.8150.3140.7143.5140.2143.6138.7138.9143.5139.9134.4133.1145.9139.2137.4142.3160.9137.7142.9126.8;procmeansdata=anmeanmedianclmqrangestdcvstderr;varx;pro

23、cunivariatedata=anormal;histogramx;varx;run;2、某研究员欲分析急性染毒对肝脏功能的影响,将40只小鼠分为两组,雄雌各半,试验组进行急性染毒试验,染毒后2小时测定血液中的ALT,整理的结果见下表.(1)比拟实验组与对照组的ALT有无差异；ALT(丙氨酸转氨酶)NOmaleFemalecontrolTreaetmentcontrolTreaetment138.457.839.755.7230.662.434.663.8325.557.540.559.9429.949.944.349.7529.055.641.248.8633.647.325.651.37

24、39.450.130.653.8842.548.737.642.6946.757.939.561.71049.360.425.165.3参考程序：dataa2;dosex=M,F;dogrp=C,T;inputalt;output;endjend;cards;38.457.839.755.730.662.434.663.825.557.540.559.929.949.944.349.729.055.641.248.833.647.325.651.339.450.130.653.842.548.737.642.646.757.939.561.749.360.425.165.3procanovad

25、ata=a2;classsexgrp;modelalt=sexgrp;meansgrp;run;quit;3、24名志愿者随机分成两组,每组12人,接受降胆固醇试验,甲组为特殊饮食组,乙组为药物治疗组.受试者试验前后各测量一次血清胆固醇(mmol/L),数据见下表：受试者试验前试验后受试者试验前试验后16.116.0016.906.9326.816.8326.406.3536.484.4936.486.4147.597.2847.007.1056.426.3056.536.4166.946.6466.706.6879.178.4279.109.0587.337.0087.316.8396.94

26、6.5896.966.91107.677.22106.816.73118.156.57118.167.65126.606.17126.986.52问题：(1)试建立能够满足以下统计分析的SAS数据集.(2)试判断两组受试者试验前血清胆固醇水平是否相等?(3)分别判断两种降胆固醇举措是否有效？(4)试判断两种降胆固醇举措的效果是否相同？参与程序：cards;16.116.0016.906.9326.816.8326.406.3536.484.4936.486.4147.597.2847.007.1056.426.3056.536.4166.946.6466.706.6879.178.4279.1

27、09.0587.337.0087.316.8396.946.5896.966.91107.677.22106.816.73118.156.57118.167.65126.606.17126.986.52Jprocttestdata=a3;classgrp;varbefore;procttestdata=a3;pairedbefore*after;wheregrp=甲组；run;procttestdata=a3;pairedbefore*after;wheregrp=乙组；run;procttestdata=a3;classgrp;varcharun;4、某职业病防治所对30名矿工分别测定血清铜

28、蓝蛋白含量mol/L,资料如下.问各期血清铜蓝蛋白含量的测定结果有无差异？疾病分期测定结果0期8.09.05.86.35.48.55.65.45.57.25.6I期8.54.311.09.06.79.010.57.77.7II期11.37.09.58.59.610.89.012.613.96.5请用秩和检验完成分析.参考程序：dataa4;inputx;if_n_=11thengrp=O;elseif_n_=20thengrp=1期;elsegrp=2期；cards;8.09.05.86.35.48.55.65.45.57.25.68.54.311.09.06.79.010.57.77.711

29、.37.09.58.59.610.89.012.613.96.5procnparlwaywilcoxon;classgrp;varx;run;教材上的练习题卫生统计学,方积乾主编,第六版t检验p121页,1,3,4题第一题方法一：dataa1;inputx;cards;20.9920.4120.1020.0020.1922.6020.9920.4120.0023.0022.00；procttestdata=a1h0=20.70;varx;|run;方法二：dataa1;inputx;d=x-20.70;cards;20.9920.4120.1020.0020.1922.6020.9920.41

30、20.0023.0022.00;procttestdata=a1;vard;|run;第三题dataa3;inputx;if_n_=10thengrp=1;elsegrp=2;cards;6.23.75.82.73.96.16.77.83.86.98.56.811.39.49.37.35.67.97.28.2;run;procttestdata=a3;classgrp;varx;run;第四题dataa4;inputx1x2;一|cards;|16.8416.7919.0219.2210.4410.4014.8715.1422.3121.8924.8324.8226.8927.0031.063

31、1.4236.7636.0741.6740.99;run;procttestdata=a4;pairedx1*x2;run;卡方检验p159例9.2例9.3例9.4例9.2,2X2表,卡方检验dataa1;dorow=1to2;docol=1to2;inputf;output;end;end;cards;64215133;run;procfreqdata=a1;tablesrow*col/chisq;weightf;run;例9.3,2X2表,校正卡方或Fisher精确检验dataa2;inputrowcolf;cards;1121 2102 1143 214;run;procfreqdata

32、=a2;tablesrow*col/chisq;weightf;run;例9.4,3X2表,卡方检验dataa3;dorow=1to3;docol=1to2;inputf;output;end;end;cards;3552010725;run;procfreqdata=a3;tablesrow*col/chisq;weightf;run;秩和检验p179例10.2例10.6p193例10.2,配对秩和检验dataa1;inputx1x2;d=x1-x2;cards;10.58.821.618.814.913.530.227.68.49.17.77.016.414.719.517.2127.01

33、55.018.716.39.59.5;run;procunivariatedata=a1;vard;run;例10.6,等级资料,秩和检验dataa2;dorow=1to4;docol=1to3;inputf;output;endjend;cards;2420202616227224141863222;procnpar1waydata=a2wilcoxon;classcol;varrow;freqf;run;p1937题,等级资料,配对设计,用Friedman检验dataa3;doid=1to10;dogrp=1to2;inputx$;fx=治愈thenx1=3;fx=有效thenx1=2;f

34、x=无效thenx1=1;output;end;end;cards;有效无效有效治愈有效有效无效有效无效治愈Jprocfreqdata=a3;tableid*grp*x1/cmhscores=ranknoprint;run;彭斌,2021-4-18SAS上机练习题三1、方差分析某研究人员研究3种刺激因素高葡萄糖、高胰岛素和过氧化氢刺激大鼠肾小球系膜细胞对单核细胞趋化蛋白表达的影响,在四种条件下对大鼠肾小球系膜细胞进行培养,检测结果如表1.表1不同刺激因素作用下蛋白表达结果分组表达结果光密度值对照组0.35470.36520.38420.35980.37420.3925局葡萄糖组1.22471.

35、23541.21361.22861.24151.2275高胰岛素组1.14531.15261.13751.15471.12941.1659过氧化氢组1.35821.36571.35181.32591.37261.3318问题1:计算每一组的平均光密度,观察各个组间均数的差异大小；问题2:进行方差分析,将结果整理成方差分析表,观察变异、均方及F值之间的关系；问题3:分别米用SNK法和Dunnett法进行多重比拟；问题4:对上述结果进行解释.参考程序:dataa;dogrp=1to4;doi=1to6;inputx;output;end;end;cards;0.35470.36520.38420.

36、35980.37420.39251.22471.23541.21361.22861.24151.22751.14531.15261.13751.15471.12941.16591.35821.36571.35181.32591.37261.3318J或者dataa;lengthgrp$10;inputgrp$;doi=1to6;inputx;output;end;cards;对照组0.3547高葡萄糖组1.2247高胰岛素组1.1453过氧化氢组1.35820.36520.38420.35981.23541.21361.22861.15261.13751.15471.36571.35180.3

37、7420.39251.24151.22751.12941.16591.32591.37261.3318procglm;classgrp;modelx=grp;meansgrp/snkdunnettmeansgrp;run;quit;2、方差分析研究枸杞多糖对脂肪肝的预防作用,按窝别作为区组标志,每一区组3只大鼠,随机分配到三个组：生理盐水组、酒精组、酒精+枸杞多糖组,三组灌胃5周,检测肝脏中谷胱甘肽GSH的含量mg/gprot,结果见表2.表2三组小鼠肝脏中谷胱甘肽GSH的含量mg/gprot区组酒精组LBP预防组生理盐水130.4865.0879.15231.2563.0475.46333.

38、2867.5979.32434.6168.5875.98528.3564.1276.55629.1766.5580.34727.3466.8984.35830.5867.1588.14934.2568.0587.351027.3165.4872.151128.0964.3874.611230.4565.0486.331333.2566.8494.351434.0467.5692.051534.2567.4696.42问题1:根据随机区组设计进行分析,处理组间、区组间效应是否有差异？问题2：忽略区组,根据完全随机设计进行分析,处理组间效应是否有差异？问题3:对上述两个方差分析表进行比拟,找出相同

39、项与不同项？观察处理组间比拟的F值变化,会得出怎样的结论？问题4:根据分析结果对该研究下一个结论.参考程序：dataa;inputblk;dogrp=7酉精组,LBP预防组,生理盐水;inputx;output;end;cards;130.4865.0879.15231.2563.0475.46333.2867.5979.32434.6168.5875.98528.3564.1276.55629.1766.5580.34727.3466.8984.35830.5867.1588.14934.2568.0587.351027.3165.4872.151128.0964.3874.611230.4

40、565.0486.331333.2566.8494.351434.0467.5692.051534.2567.4696.42；procglm;classgrpblk;modelx=grpblk;meansgrp/snk;run;quit;procglm;classgrp;modelx=grp;meansgrp/snk;run;quit;3、方差分析研究人员研究某种物质的毒性,将40只小鼠分为两组,雄雌各半,试验组给予研究物质,2小时后测定血液中碱性磷酸酶的含量,结果如下.表340只小鼠给予不同物质后血液中碱性磷酸酶的含量碱性磷酸酶性别分组雄性对照组367.9408.6375.6354.9421

41、.7374.5432.7401.3399.4367.5试验组423.8446.9432.5478.1437.5421.6489.0432.5421.0420.4雌性对照组378.1345.2390.6399.0421.1341.3322.5365.4321.6401.9试验组420.4473.2450.3405.5427.4460.5420.1394.4389.6420.5问题1:研究者考虑了几个影响因素？问题2:性别对碱性磷酸酶有无影响？问题3:该物质对碱性磷酸酶有无影响？参考程序：dataa;dosex=M,F;dogrp=C,T;doi=1to10;inputx;output;end;e

42、nd;end;cards;367.9408.6375.6354.9421.7374.5432.7401.3399.4367.5423.8446.9432.5478.1437.5421.6489.0432.5421.0420.4378.1345.2390.6399.0421.1341.3322.5365.4321.6401.9420.4473.2450.3405.5427.4460.5420.1394.4389.6420.5Jprocglm;classsexgrp;modelx=sexgrp;run;quit;4、回归分析浓度.以下是制作标准曲线时对应的浓度和吸光度值,试求出标准曲线.并求出A=

43、1.15时的表4/、同浓度对应的吸光度值浓度A值0.970.31.270.561.570.931.881.352.181.51参考程序：dataa;inputca;cards;ZZ0.970.301.270.561.570.931.881.352.181.51.1.15procreg;modelc=a/p;plotc*a;run;quit;5、(相关分析、回归分析)27名糖尿病人的血清总胆固醇、甘油三脂、空腹胰岛素、糖化血红蛋白、空腹血糖的测量值列于表中,试分析血糖与其它几项指标关系的关系.表527名糖尿病人的血糖及有关变量的测量结果序号总胆固醇i(mmol/L)X1(mmol/L)X2胰岛素

44、(U/ml)X3糖化血红蛋白(%)X4(mmol/L)Y15.681.904.538.211.223.791.647.326.98.836.023.566.9510.812.344.851.075.888.311.654.602.324.057.513.466.050.641.4213.618.374.908.5012.608.511.187.083.006.7511.512.193.852.1116.287.99.6104.650.636.597.18.4114.591.973.618.79.3124.291.976.617.810.6137.971.937.579.98.4146.191.

45、181.426.99.6156.132.0610.3510.510.9165.711.788.538.010.1176.402.404.5310.314.8186.063.6712.797.19.1195.091.032.538.910.8206.131.715.289.910.2215.783.362.968.013.6225.431.134.3111.314.9236.506.213.4712.316.0247.987.923.379.813.22511.5410.891.2010.520.0265.840.928.616.413.3273.841.206.459.610.4问题1:计算各指标之间的pearson相关系数及spearman相关系数；问题2:以血糖为