1、重慶醫(yī)科大學(xué)-衛(wèi)生統(tǒng)計(jì)學(xué)統(tǒng)計(jì)軟件包SAS上機(jī)練習(xí)題一1、SAS常用的窗口有哪三個？請?jiān)谌齻€根本窗口之間切換并記住這些命令或功能鍵.2、請?jiān)赑GM窗口中輸入如下幾行程序,提交系統(tǒng)執(zhí)行,并查看OUTPUT窗和LOG窗中內(nèi)容,注意不同顏色的含義；并根據(jù)日志窗中的信息修改完善程序.DATSEX0101;INPUTTNAME$AGESEX;CARDS;XIAOMIN191LIDONG201NANA1825PRODPRONTDATS=EX1;RUN;PROCPRINTDATA=EX1;VARNAMEAGE;RUN;3、將第2題的程序、結(jié)果及日志保存到磁盤.4、試根據(jù)如下例1的程序完成后面的問題：表1某班1

2、6名學(xué)生3門功課成績表如下問題：1建立數(shù)據(jù)集；2打印至少有1門功課不及格同學(xué)的信息；提示,使用if語句dataa;inputidshwlbl;cards;083687165084746168085737546086798079087757168084858587085787975086807679087858082088777175089677371080758170118705475083706684084627365099827079;run;datab;seta;ifsh60orwl60orbl60thenoutput;run;procprintdata=b;varidshwlbl;ru

3、n;5、根據(jù)以下數(shù)據(jù)建立數(shù)據(jù)集表2銷售數(shù)據(jù)開始時間終止時間費(fèi)用2005/04/2825MAY2021$123,345,0002005091805OCT2021$33,234,5002007/08/1222SEP2021$345,6002004050830JUN2021$432,334,500提示：格式化輸入；數(shù)據(jù)之間以空格分隔,數(shù)據(jù)對齊；注意格式后面的長度應(yīng)以前一個位置結(jié)束開始計(jì)算,如果讀入錯誤,可試著調(diào)整格式的寬度；顯示日期需要使用輸出格式開始時間,輸入格式y(tǒng)ymmdd10.終止時間,輸入格式date10.費(fèi)用,輸入格式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、號一編碼規(guī)那么一般是：YYY-XXXX-ZZZZ,其YYY為號段；XXXX一般為所在地區(qū)編碼；ZZZZ為對應(yīng)的個人識別編號.下面有一組號(來源于網(wǎng)絡(luò),末位以X替換),請用程序完

5、成下列要求：(1)分別列出屬于聯(lián)通、移動、電信的號；(2)分別提取地區(qū)編號及個人識別編號.(提示：列輸入方式或者字符串操作)說明：移動：134-139、150、151、152、157、158、159、188聯(lián)通：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=聯(lián)通;ifyin(133,153,180,189)thenygrp=電信；cards;15

7、08320464X1510291126X1339644156X0000001513441713X1308279203X1897876466X;procprint;run;7、下表是某班學(xué)生幾門功課的成績,其中形勢課是考查課,其它均為測試課.請完成以下處理并且保存程序、結(jié)果和日志：(注意函數(shù)在DATASTEP中使用的位置)(1)用Mean()函數(shù)求出每位同學(xué)的平均分,將其保存在變量中；(2)用sum()函數(shù)或者表達(dá)式求出每位同學(xué)的總分,將其保存在變量中；(3)如果每門測試課權(quán)重是0.75,每門考查課權(quán)重為0.25,試求每位同學(xué)的加權(quán)平均分；(4)將數(shù)據(jù)集保存為永久數(shù)據(jù)集,保存位置為“；(5)調(diào)用

8、上面的永久數(shù)據(jù)集,并將男、女生的成績分別保存在數(shù)據(jù)集Dmale和Dfemale中.表3某班同學(xué)幾門功課的成績學(xué)號性別(0=女,1=男)高數(shù)生理人解數(shù)理統(tǒng)計(jì)形勢(考查)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編碼及對應(yīng)的疾病名.請完成以下任務(wù)：(1)建立數(shù)據(jù)集；(2)提取每種疾病的大類編碼；(3)分別將3個大類的疾病存入3個數(shù)據(jù)集.(提示：ICD10編碼中小數(shù)點(diǎn)前面的三位表示大類；length語句定義字符變量長度；字符串取子串函數(shù))表44類疾病的ICD10編碼及對應(yīng)疾病名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+沙門氏菌性關(guān)節(jié)炎A02.203+沙門氏菌性腦膜炎A02.901沙門氏菌感染A02.902鼠傷寒沙門氏菌感染A02.903沙門氏菌屬食物中毒A03.001什密氏志賀菌痢疾A03.101弗氏志賀菌痢疾A03.201鮑氏志賀菌痢疾A03.301宋內(nèi)氏志賀菌痢疾A03.802菌痢混合感染A03.901細(xì)菌性痢疾A03.902慢性細(xì)菌性痢疾急性發(fā)作A03.903慢性細(xì)菌性痢疾A03.905

14、慢性遷延型細(xì)菌性痢疾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、關(guān)節(jié)炎A02.203+沙門氏菌性腦膜炎A02.901沙門氏菌感染|A02.902鼠傷寒沙門氏菌感染A02.903沙門氏菌屬食物中毒A03.001什密氏志賀菌痢疾A03.101弗氏志賀菌痢疾A03.201鮑氏志賀菌痢疾A03.301宋內(nèi)氏志賀菌痢疾A03.802菌痢混合感染A03.901細(xì)菌性痢疾A03.902慢性細(xì)菌性痢疾急性發(fā)作A03.903慢性細(xì)菌性痢疾A03.905慢性遷延型細(xì)菌性痢疾A03.906中毒性痢疾；datacat01cat02cat03;seta;ifcat=A01thenoutputcat01;ifcat=A02thenoutputcat02;ifcat=A03thenou

16、tputcat03;run;9、現(xiàn)有兩個文件,內(nèi)容如下:A文件B文件學(xué)號統(tǒng)計(jì)體育年齡學(xué)號性別班級0187832301男10256962202女10393751903男30477842404男20588551805女208女3要求：打印至少有一門功課不及格的同學(xué)的年齡、性別和班級.參考程序：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以內(nèi)的素?cái)?shù).(提示：素?cái)?shù)即只能被1和本身整除的數(shù),如2,3,5,7等等；循環(huán)語句,條件語句,取余數(shù)函數(shù)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上機(jī)練習(xí)題(二)1、某農(nóng)村地區(qū)199

18、9年14歲女孩的身高資料列于表1.表1謀農(nóng)村地區(qū)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)計(jì)算均數(shù)、中位數(shù)；計(jì)算均數(shù)的95%可信區(qū)間;(2)計(jì)算四分位間距、標(biāo)準(zhǔn)差、變異系數(shù)；計(jì)算標(biāo)準(zhǔn)誤;(3)請進(jìn)行正態(tài)性檢驗(yàn)；(4)觀察頻數(shù)分布情況；參考程序: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只小鼠分為兩組,雄雌各半,試驗(yàn)組進(jìn)行急性染毒試驗(yàn),染毒后2小時測定血液中的ALT,整理的結(jié)果見下表.(1)比擬實(shí)驗(yàn)組與對照組的ALT有無差異；ALT(丙氨酸轉(zhuǎn)氨酶)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名志愿者隨機(jī)分成兩組,每組12人,接受降膽固醇試驗(yàn),甲組為特殊飲食組,乙組為藥物治療組.受試者試驗(yàn)前后各測量一次血清膽固醇(mmol/L),數(shù)據(jù)見下表：受試者試驗(yàn)前試驗(yàn)后受試者試驗(yàn)前試驗(yàn)后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)試建立能夠滿足以下統(tǒng)計(jì)分析的SAS數(shù)據(jù)集.(2)試判斷兩組受試者試驗(yàn)前血清膽固醇水平是否相等?(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、某職業(yè)病防治所對30名礦工分別測定血清銅

28、藍(lán)蛋白含量mol/L,資料如下.問各期血清銅藍(lán)蛋白含量的測定結(jié)果有無差異？疾病分期測定結(jié)果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請用秩和檢驗(yàn)完成分析.參考程序：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;教材上的練習(xí)題衛(wèi)生統(tǒng)計(jì)學(xué),方積乾主編,第六版t檢驗(yàn)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;卡方檢驗(yàn)p159例9.2例9.3例9.4例9.2,2X2表,卡方檢驗(yàn)dataa1;dorow=1to2;docol=1to2;inputf;output;end;end;cards;64215133;run;procfreqdata=a1;tablesrow*col/chisq;weightf;run;例9.3,2X2表,校正卡方或Fisher精確檢驗(yàn)dataa2;inputrowcolf;cards;1121 2102 1143 214;run;procfreqdata

32、=a2;tablesrow*col/chisq;weightf;run;例9.4,3X2表,卡方檢驗(yàn)dataa3;dorow=1to3;docol=1to2;inputf;output;end;end;cards;3552010725;run;procfreqdata=a3;tablesrow*col/chisq;weightf;run;秩和檢驗(yàn)p179例10.2例10.6p193例10.2,配對秩和檢驗(yàn)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,等級資料,秩和檢驗(yàn)dataa2;dorow=1to4;docol=1to3;inputf;output;endjend;cards;2420202616227224141863222;procnpar1waydata=a2wilcoxon;classcol;varrow;freqf;run;p1937題,等級資料,配對設(shè)計(jì),用Friedman檢驗(yàn)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上機(jī)練習(xí)題三1、方差分析某研究人員研究3種刺激因素高葡萄糖、高胰島素和過氧化氫刺激大鼠腎小球系膜細(xì)胞對單核細(xì)胞趨化蛋白表達(dá)的影響,在四種條件下對大鼠腎小球系膜細(xì)胞進(jìn)行培養(yǎng),檢測結(jié)果如表1.表1不同刺激因素作用下蛋白表達(dá)結(jié)果分組表達(dá)結(jié)果光密度值對照組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:計(jì)算每一組的平均光密度,觀察各個組間均數(shù)的差異大小；問題2:進(jìn)行方差分析,將結(jié)果整理成方差分析表,觀察變異、均方及F值之間的關(guān)系；問題3:分別米用SNK法和Dunnett法進(jìn)行多重比擬；問題4:對上述結(jié)果進(jìn)行解釋.參考程序: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、方差分析研究枸杞多糖對脂肪肝的預(yù)防作用,按窩別作為區(qū)組標(biāo)志,每一區(qū)組3只大鼠,隨機(jī)分配到三個組：生理鹽水組、酒精組、酒精+枸杞多糖組,三組灌胃5周,檢測肝臟中谷胱甘肽GSH的含量mg/gprot,結(jié)果見表2.表2三組小鼠肝臟中谷胱甘肽GSH的含量mg/gprot區(qū)組酒精組LBP預(yù)防組生理鹽水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:根據(jù)隨機(jī)區(qū)組設(shè)計(jì)進(jìn)行分析,處理組間、區(qū)組間效應(yīng)是否有差異？問題2：忽略區(qū)組,根據(jù)完全隨機(jī)設(shè)計(jì)進(jìn)行分析,處理組間效應(yīng)是否有差異？問題3:對上述兩個方差分析表進(jìn)行比擬,找出相同

39、項(xiàng)與不同項(xiàng)？觀察處理組間比擬的F值變化,會得出怎樣的結(jié)論？問題4:根據(jù)分析結(jié)果對該研究下一個結(jié)論.參考程序：dataa;inputblk;dogrp=7酉精組,LBP預(yù)防組,生理鹽水;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、方差分析研究人員研究某種物質(zhì)的毒性,將40只小鼠分為兩組,雄雌各半,試驗(yàn)組給予研究物質(zhì),2小時后測定血液中堿性磷酸酶的含量,結(jié)果如下.表340只小鼠給予不同物質(zhì)后血液中堿性磷酸酶的含量堿性磷酸酶性別分組雄性對照組367.9408.6375.6354.9421

41、.7374.5432.7401.3399.4367.5試驗(yàn)組423.8446.9432.5478.1437.5421.6489.0432.5421.0420.4雌性對照組378.1345.2390.6399.0421.1341.3322.5365.4321.6401.9試驗(yàn)組420.4473.2450.3405.5427.4460.5420.1394.4389.6420.5問題1:研究者考慮了幾個影響因素？問題2:性別對堿性磷酸酶有無影響？問題3:該物質(zhì)對堿性磷酸酶有無影響？參考程序：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、回歸分析濃度.以下是制作標(biāo)準(zhǔn)曲線時對應(yīng)的濃度和吸光度值,試求出標(biāo)準(zhǔn)曲線.并求出A=

43、1.15時的表4/、同濃度對應(yīng)的吸光度值濃度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、(相關(guān)分析、回歸分析)27名糖尿病人的血清總膽固醇、甘油三脂、空腹胰島素、糖化血紅蛋白、空腹血糖的測量值列于表中,試分析血糖與其它幾項(xiàng)指標(biāo)關(guān)系的關(guān)系.表527名糖尿病人的血糖及有關(guān)變量的測量結(jié)果序號總膽固醇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:計(jì)算各指標(biāo)之間的pearson相關(guān)系數(shù)及spearman相關(guān)系數(shù)；問題2:以血糖為