《 SAS基础》相关资料-数表和例题程序

PAGEPAGE52实用SAS基础讲义数表、例题程序一数表表2-1工资原始统计表姓名工号基本工资岗位津贴奖金张三217500300300李四335800400500王五4421000500800表2-2连续10个工作日的股票价格Datexyz05/718.7319.2422.5305/819.8319.3823.5505/1119.9919.5222.8905/1218.9919.4821.7805/1318.9819.2722.2105/1417.9618.9821.6505/1517.4419.3121.4305/1818.6619.4521.5205/1918.5819.2621.8505/2019.2120.2523.78表3-1未被压缩过的5天外汇牌价表日期币种汇率1AUD467.991CHF660.221EUR727.821GDP933.922AUD473.572CHF655.132EUR720.542GDP924.913AUD473.853CHF659.953EUR721.633GDP924.074AUD470.724CHF664.454EUR723.554GDP915.025AUD475.355CHF663.845EUR724.665GDP916.85表3-2初步压缩过的5天外汇牌价表币种周1币种周2币种周3币种周4币种周5AUD467.99AUD473.57AUD473.85AUD470.72AUD475.35CHF660.22CHF655.13CHF659.95CHF664.45CHF663.84EUR727.82EUR720.54EUR721.63EUR723.55EUR724.66GDP933.92GDP924.91GDP924.07GDP915.02GDP916.85表3-3高度压缩后的5天外汇牌价表币种周1周2周3周4周5AUD467.99473.57473.85470.72475.35CHF660.22655.13659.95664.45663.84EUR727.82720.54721.63723.55724.66GDP933.92924.91924.07915.02916.85表3-4两家企业的登记信息AbcdeCo.Ltd.123Shanghaiefghlu123400宇宙电脑股份有限公司某某市某某街8号885表3-5调查表abcd0100aababebcad1010abbbfcdbbaa0010bccef表3-6全英文企业数据nameaddresstaffcapitalabcdeShanghaiefghlu123400YuzhoudiannaoCo.Ltd.8xstretxcity885表3-7d：\wu\test1.dat内的数据1100.14017-0.153392110.004570.004703120.32623-0.163984130.529100.05239514-0.434010.083596150.23856-0.07340716-0.073700.06304817-0.365720.007939180.22740-0.1241610190.029590.048761121-0.269620.0209512220.002820.173421323-0.566220.250051424-0.24555-0.0110415250.29657-0.0287616270.20396-0.058011728-0.144470.0923418300.178770.0053519310.03913-0.110862032-0.15538-0.07615表4-1某人儿子身高体重记录时间身高(单位cm)体重（kg）1980/01/2554.84.31980-04-0162.16.01981-04-1273.810.21982-03-2885.112.6表4-21季度销量monthxy133142321233411表4-32季度销量monthxy434135351463513表4-43季度销量monthxy735142883416309341530表4-5另一2季度销量Monthyz4 13 255 14 276 13 26表4-6待排序数据xyzbb15.4bb53.6ba22.6ba31.8bb44.4表4-7部门1统计销量数据（仅有x，y的数据）monthxy133143321223411表4-8部门2统计销量数据（仅有y，z的数据）monthyz114253122721126表4-9部门3统计销量数据（仅有uv的数据）monthuv122412384731842表4-10部门1统计销量数据（仅有x，y的数据）月xy435141 33 143 32 122 34 11表4-11部门2统计销量数据（仅有y，z的数据）月yz521281 14 253 12 272 11 26表4-12部门3统计销量数据（仅有u、v的数据）月uv1 22 412 38 473 18 42表5-1数据集wxyzu12aC34bd表5-24种数字及其输出格式输出格式替换格式科学输出法BEST8.千位以上带逗号COMMA12.美元计数DOLLAR10.限制字宽6，其中小数点后2位6.2表5-33个医院调查数据 编号no医院hospital年龄age药费medpay1314332.072158341.953336193.544223774.805312618.196215993.797350335.148228409.879211918.4610354251.3611215364.0312334762.4913125983.8314229210.4115132777.6116241420.1917113463.3818271168.3019129833.0720124240.2421228998.8422170519.3223123653.5024320227.1025112563.3226225615.1627325644.7128331166.212922618.0330250159.0731129942.3732133118.5333342179.8834257753.6535142207.1036338559.4337237341.3238138134.083938664.5440351547.24表5-44个病人的医疗费数据编号医院年龄医药费1 c 14 332.072 a58 341.953 c 36 193.544 b 23 774.80表6-1某单位3人的6项原始工资姓名基本工资工龄工资奖励工资出勤补助地区补助车补赵甲2800180300750500500钱乙3300480300750500800孙丙40001600300750500800表6-23名学生的语文，数学，英语成绩以及部分政治思想表现评语（其中后3列得1则表示学生评语中有变量名字，如乐观活泼，团结友爱等；变量值得0则没有）姓名语文数学英语乐观活泼团结友爱尊敬师长赵玲玲959888111钱国华909592101孙建强889987110表6-340名学生的身高体重情况（性别取1代表男性，取2代表女性）编号地区教学班性别身高体重1地区33班1167572地区22班2167483地区21班1172644地区12班1176775地区33班2165436地区32班1170597地区11班2168538地区24班2169519地区13班11777510地区24班11766511地区14班11787412地区23班11746713地区31班21674614地区22班11736215地区13班21715616地区34班21624817地区21班21705018地区12班21695819地区11班11747220地区31班11736021地区33班11675722地区22班21674823地区21班11726424地区12班11767725地区33班21654326地区32班11705927地区11班21685328地区24班21695129地区13班11777530地区24班11766531地区14班11787432地区23班11746733地区31班21674634地区22班11736235地区13班21715636地区33班11675737地区22班21674838地区21班11726439地区12班11767740地区33班2165436-4各种土壤，耕作方法，肥料，和品种搭配后的小麦产量。编号no土壤soil耕作方式farm肥料fertilizer小麦品种strain产量yield111015.891211015.652311017.121411022.487511026.364611025.658711034.506811033.938911036.0281011114.7171111115.171211114.9131311125.4141411126.6041511124.3031611135.031711134.5811811136.9851911215.2362011213.882111215.6612211225.9552311224.8712411225.3332511235.5192611235.3822711235.5852811315.8922911317.0833011314.3173111323.2433211324.9483311323.3443411333.3693511335.9153611334.6283712015.6233812017.4493912014.9424012024.7474112024.3024212025.4564312034.7464412034.5684512034.3424612116.0084712114.8434812117.244912125.7715012125.6185112125.4595212135.5485312136.0485412135.0235512216.2335612214.6645712217.1575812224.9115912225.5726012224.3026112237.0286212235.0056312237.0066412314.1326512314.8026612316.5326712324.7576812325.3346912326.327012333.5557112332.6587212334.1227321017.0627421015.3537521017.567621026.3987721024.4027821025.1437921034.7028021034.9918121035.5948221115.3288321113.9068421116.4678521125.6788621124.7658721126.1078821134.3658921133.9819021136.6279121216.0459221215.6399321214.1719421225.6879521223.4669621224.9139721237.5989821236.3589921234.96710021316.2491012131450210321324.4510421327.06410521323.55610621335.39810721335.1710821334.05710922016.8211022017.67211122016.5531122202426311422024.99411522035.4811622035.82211722034.19911822112.32711922114.20812022113.11112122123.71712222125.7112322125.66812422134.68712522133.53212622135.78312722215.93412822214.67512922214.1713022224.67613122225.76113222224.42513322234.70113422236.52413522236.05913622315.95713722314.29113822315.52513922325.78214022325.49314122325.43514222335.46914322337.83814422335.055表7-1某国10个城市地理坐标和GOP表（虚拟数据）经度纬度GDP（单位亿元）31.585022.5425335613460335420513355268143.31395432115205表7-2某超市肉，禽，鱼的销量季度种类加工金额（万元）1季度肉生202.11季度禽生98.81季度鱼生95.01季度肉熟99.41季度禽熟22.31季度鱼熟2.42季度肉生198.32季度禽生77.22季度鱼生55.02季度肉熟98.32季度禽熟33.42季度鱼熟3.23季度肉生129.43季度禽生75.63季度鱼生75.03季度肉熟87.53季度禽熟34.53季度鱼熟12.54季度肉生221.34季度禽生102.34季度鱼生96.04季度肉熟35.84季度禽熟43.54季度鱼熟1.0表8-1护肤霜销量数据销量（打）y目标人口（千人）每月人均可支配收入（美元）162274245012018032542233753802131205283867862347169266378281983708192330245011619521375553256025243040202323724427144236266010315720882123702605表8-2土壤中可给态磷数据序号y10.4521586420.4231636033.119377140.6341576154.724595461.7651237779.4444681810629173931012.658112511110.937111761223.146114961323.150134771421.64473931523936143541726.8582021681829.95112499表8-38名学生考试成绩数据智商复习时间考试得分105107511012791206681161385122169113087911420981021576表8-4水泥发热数据x1x2x3x4y72666078.5129155274.31156820104.3113184787.675263395.91155922109.2371176102.7131224472.5254182293.12147426115.9140233483.81166912113.31068812109.4表8-5健身馆统计36位健身者数据noX1X2X3X4X5X6y14268.1559.5718.174016617224981.4249.1568.954418018535491.6339.20312.884416817244473.0350.54110.134516816854485.8454.2978.654515616864779.1547.27310.604716216475167.2545.11811.084817217285070.8754.6258.924814615595276.3245.4419.6348164166105177.9146.67210.0048162168113881.8760.0558.6348170186124891.6346.77410.2548162164135759.0850.5459.9349148155145483.1251.85510.3350166170154566.4544.75411.1251176176164861.2447.92011.5052170176175282.7847.46710.5053170172183889.0249.8749.2255178180194976.3248.6739.4056186188204587.6637.38814.0356186192215169.6340.83610.9557168172225773.3739.40712.6358174176234777.4544.81111.6358176176245173.7145.79010.4759186188254075.0745.31310.0762185185265479.3846.08011.1762156165274489.4744.60911.3762178182284481.4239.44213.0863174176294381.1949.09110.8564162170304973.3750.38810.0867168168314075.9845.68111.9570176180表8-630块地化肥用量及土豆产量氮（千克）磷（千克）钾（千克）产量（吨）019637215.183419637221.366719637225.7210119637232.2913519637234.0320219637239.4525919637243.1533619637243.3640419637240.8347119637230.75259037233.462592437232.472594937236.062597337237.962599837241.0425914737240.0925919637241.2625924537242.1725929437240.3625934237242.73259196018.982591964727.352591969334.8625919614038.5225919618638.4425919627937.7325919637238.4325919646543.8725919655842.7725919665146.22表8-7青铜拉力强度数据退火时间\退火温度1502002503003064.962.661.159.24063.65076.174.071.367.26082.980.076.072.3表8-8具有完全共线性问题的数据1.43.241012表8-9具有高度共线问题的数据1.0023335.0029.124.0016.245.99812表8-10跑步者数据年龄体重氧气摄取率1.5英里跑步时间不运动时脉搏跑步时脉搏跑步时最大脉搏4489.4744.60911.37621781824075.0745.31310.07621851854485.8454.2978.65451561684268.1559.5718.17401661723889.0249.8749.22551781804777.4544.81111.63581761764075.9845.68111.95701761804381.1949.09110.85641621704481.4239.44213.08631741763881.8760.0558.63481701864473.0350.54110.13451681684587.6637.38814.03561861924566.4544.75411.12511761764779.1547.27310.60471621645483.1251.85510.33501661704981.4249.1568.95441801855169.6340.83610.95571681725177.9146.67210.00481621684891.6346.77410.25481621644973.3750.38810.08671681685773.3739.40712.63581741765479.3846.08011.17621561655276.3245.4419.63481641665070.8754.6258.92481461555167.2545.11811.08481721725491.6339.20312.88441681725173.7145.79010.47591861885759.0850.5459.93491481554976.3248.6739.40561861884861.2447.92011.50521701765282.7847.46710.5053170172表8-11某国连续11年有关进口总额数据YearimportGDPsaveconsume1149.34.2108.115.92161.24.1114.816.43171.53.1123.219.04175.53.1126.919.15180.81.1132.118.86190.72.2137.720.47202.12.1146.022.78212.45.6154.126.59226.15.0162.328.110231.95.1164.327.611239.00.7167.626.3表8-12自变量x1，x2和因变量y的观测值X1X2X1.41.518.01.81.921.12.02.422.0表8-13某国连续16年国民航数据表yearyx1x2x3x4x51231301018888149114.89180.922298335021958638916.00420.393343368825319220419.53570.254401394127999530021.82776.715445425830549992223.27792.4363914736335810604422.91947.7075545652390511035326.021285.2287447020487911211027.721783.3099977859555210857932.432281.951013109313638611242938.912690.2311144211738803812264537.383169.4812128313176900511380747.192450.141316601438496639571250.681746.2014217816557109699508155.913335.6515288620223129859969383.663311.50163383248821594910545896.084152.70表8-149位女子的身高与腿长数据身高143145146147149150153154155腿长888388919293939596表8-15某市经济开发区经济发展与招商投资数据资料y253547.79553.9620896.34208.556750.323.110012087.052815.405251639.311052.127671.13122.245322863.321400.00751160.00464.0040862.757.50187672.99224.188253357.703427.00120808.47442.8228520.2770.12122901.76538.94743546.182442.79表8-16美国人口统计数据数（1790-1970，单位千人，每隔10年统计1次）3929530872399638128661706923191314433981850155629477599491972105710122775131669151325179323203211表8-17某人血液酒精浓度数据（单位每升毫克，t=0表示饮完酒时间） t511.522.53c3068.0728282.07768.068t3.54.4.556.078.09c5851.0504138.03528.025t1011.01213141516.c1815.012107.074.0表8-18某国连续11年GDP，资金投入，就业人数数据年份GDP单位亿元TK单位亿元TL单位亿人17171.02468.64.819728964.43386.04.9873310202.23846.05.1282411962.54322.05.2783514928.35495.05.4334616909.26095.05.5329718530.76444.05.6740821617.87517.05.8360926635.49636.05.94321034515.114998.06.02201145005.818944.06.1470表8-19牧草生长资料（t表示生长天数，y单位是克）t91421284257637079y8.9310.8018.5922.3339.3556.1161.7364.7267.08表8-202自变量LAD回归数据y134223314425535二例题的程序（为了避免读者使用时出错，程序不加注释）第1章例1.1固定还贷procloanstart=2018:1;fixedamount=1000000rate=4life=360output=house;procprintdata=house;run;气球式还贷procloanstart=2018:1;balloonamount=700000rate=4life=360out=houseballoonpayment=(12=10000036=50000);procprintdata=house;run;例1.2Title‘张三还贷明细’;procloanstart=2018:1;fixedamount=500000rate=4life=300out=house;procprintdata=house;run;第2章例2.2datasalary;inputmingzi$gonghaojibengangtiejiangjin;heji=jiben+gangtie+jiangjin;ifheji>1600thenkoushui=(heji-1600)*0.2;elsekoushui=0;shifa=heji-koushui;datalines;张三 217 500 300 300李四335800 400 500王五 442 1000 500800;Procprintdata=salary;run;例2.3dataw1;inputmingzi$gonghaojibengangtiejiangjin;datalines;张三 217 500 300 300李四335800 400 500王五 442 1000 500800; dataw2;inputmingzi$gonghaojibengangtiejiangjin;ifheji>1600thenkoushui=(heji-1600)*0.2;elsekoushui=0;shifa=heji-koushui;datalines;张三 217 500 300 300李四335800 400 500王五 442 1000 500800;Procprintdata=w1noobs;run;例2.4datasalary;inputmingzi$gonghaojibengangtiejiangjin;heji=jiben+gangtie+jiangjin;ifheji>1600thenkoushui=(heji-1600)*0.2;elsekoushui=0;shifa=heji-koushui;datalines;张三 217 500 300 300李四335800 400 500王五 442 1000 500800;procprintdata=salarynoobs;vargonghaomingzishifa;run;例2.5datasalary;inputmingzi$gonghaojibengangtiejiangjin;heji=jiben+gangtie+jiangjin;ifheji>1600thenkoushui=(heji-1600)*0.2;elsekoushui=0;shifa=heji-koushui;datalines;张三 217 500 300 300李四335800 400 500王五 442 1000 500800;Procprintdata=salary;Sumkoushuishifa;run;例2.6datasalary;inputmingzi$gonghaojibengangtiejiangjin;heji=jiben+gangtie+jiangjin;ifheji>1600thenkoushui=(heji-1600)*0.2;elsekoushui=0;shifa=heji-koushui;datalines;张三 217 500 300 300李四335800 400 500王五 442 1000 500800;procsortdata=salary;bymingzi;Procprintdata=salary;bymingzi;run;第3章例3.1对于表3-1可用如下程序：dataexchenge1;inputdaytrpe$rate;datalines;1 AUD 467.991 CHF 660.221 EUR 727.821 GDP 933.922 AUD 473.572 CHF 655.132 EUR 720.542 GDP 924.913 AUD 473.853 CHF 659.953 EUR 721.633 GDP 924.074 AUD 470.724 CHF 664.454 EUR 723.554 GDP 915.025 AUD 475.355 CHF 663.845 EUR 724.665 GDP 916.85;procprint;run;对于表3-2可用如下程序：dataexchenge2;doday=1to5;inputtype$rate@@;output;end;datalines;AUD 467.99 AUD 473.57 AUD 473.85 AUD 470.72 AUD 475.35CHF 660.22 CHF 655.13 CHF 659.95 CHF 664.45 CHF 663.84EUR 727.82 EUR 720.54 EUR 721.63 EUR 723.55 EUR 724.66GDP 933.92 GDP 924.91 GDP 924.07 GDP 915.02 GDP 916.85;procprint;run;对于表3-3可用如下程序：dataexchange3;inputtype$@;doday=1to5;inputrate@;output;end;datalines;AUD467.99473.57473.85470.72475.35CHF660.22655.13659.95664.45663.84EUR727.82720.54721.63723.55724.66GDP933.92924.91924.07915.02916.85;procprint;run;对于表3-3，如需输出按day排序，可用如下程序：dataexchange3;inputtype$@;doday=1to5;inputrate@;output;end;datalines;AUD467.99473.57473.85470.72475.35CHF660.22655.13659.95664.45663.84EUR727.82720.54721.63723.55724.66GDP933.92924.91924.07915.02916.85;Procsort;Byday;Procprint;run;例3.2建立企业统计表，其中变量name，addres，staff，capital分别表示企业名称，地址，工人数，注册资金（单位万）。2个企业的信息如表3-4。试建立数据集pn让它包含上述信息。datacompn;inputname$1-20addres$21-40staffcapital;datalines;abcdeCo.Ltd.123Shanghaiefghlu123400宇宙电脑股份有限公司某某市某某街8号885;procprint;run;例3.3dataEmployees;inputIdNum$4.+2LName$11.FName$11.JobCode$3.+1Salary5.+1Phone$12.;datalines;1876CHINJACKTA142400212/588-56341114GREENWALDJANICEME338000212/588-10921556PENNINGTONMICHAELME129860718/383-56811354PARKERMARYFA365800914/455-23371130WOODDEBORAHPT236514212/587-0013;Procprint;Run;例3.4datawu;inputx1$1.x2$1.x3$1.x4$1.+4x9$1.x10$1.x11$1.x12$;datalines;abcd0100aababebcad1010abbbfcdbbaa0010bccefrun;procprint;run;例3.5datawww;infile'd:\wu\test1.dat';inputno x1-x3;run;procprintdata=www;run;或filenamewu'd:/wu';datawww;infilewu(test1);inputno x1-x3;procprintdata=www;run;例3.6datasale;infile'd:\wu\douhao.txt'dlm=',';inputname$s1-s5;run;procprintdata=sale;run;例3.7datawu1;infile'd:\wu\column.txt';inputx1$1.x2$1.x3$1.x4$1.x51.x61.x71.x81.x9$1.x10$1.x11$1.+1x12$;run;例3.8datacompn;infile‘D:\wu\cop.txt’;inputname$1-20addres$21-40staffcapital;run;例3.10为了读取D驱上文件wu中SAS数据集文件pdv2，将之存于临时文件test1，可以使用程序：libnamelibv9'd:\wu';datatest1;setlib.pdv2;procprintdata=test1;run;例3.11dataw;inputdate:mmddyy10.highweight@@;cards;05/13/2015784.2806/22/1980693.88;procprint;run;第4章例4.1datastock;inputdate$xyz;xdif=dif(x);ydif=dif(y);zdif=dif(z);datalines;05/7 18.73 19.24 22.5305/8 19.83 19.38 23.5505/9 19.99 19.52 22.8905/10 18.99 19.48 21.7805/11 18.98 19.27 22.2105/14 17.96 18.98 21.6505/15 17.44 19.31 21.4305/16 18.66 19.45 21.5205/17 18.58 19.26 21.8505/18 19.21 20.25 23.78;procprint;run;例4.2Datadepreci;dot=1to13;x=daccdb(t,400000,15,2);y=400000-x;output;end;procprint;run;例4.3datarandom;dot=1to100;r=normal(123456);x=2*r+3;output;end;procprintnoobs;run;例4.4datastock;dropxyz;/*或keepdatexdifydifzdif;*/inputdate$xyz;xdif=dif(x);ydif=dif(y);zdif=dif(z);datalines;05/7 18.73 19.24 22.5305/819.83 19.38 23.5505/919.99 19.52 22.8905/10 18.99 19.48 21.7805/11 18.98 19.27 22.2105/14 17.96 18.98 21.6505/15 17.44 19.31 21.4305/16 18.66 19.45 21.5205/17 18.58 19.26 21.8505/18 19.21 20.25 23.78;procprint;run;例4.5通过程序得到SAS数据集W中有5个变量no，u，x，y，z的10次观测。dataw;inputNo u$ x y z;datalines;1 a 18.73 19.24 22.532 b 19.83 19.38 23.553 c 19.99 19.52 22.894 d 18.99 19.48 21.785 e 18.98 19.27 22.216 f 17.96 18.98 21.657 g 17.44 19.31 21.438 a 18.66 19.45 21.529 c 18.58 19.26 21.8510 d 19.21 20.25 23.78;procprint;run;为得到只包含数据集w的第3行以后部分，可用如下程序Dataw1;Setw(firstobs=3);Run;如果如果想得到数据集w2，让它只包含数据集w的前8行，可用下列语句Dataw2;Setw(obs=8);Run;如果如果想得到数据集w3，让它只包含数据集w的3-8行，可用下列语句Dataw3;Setw(firstobs=3obs=8);Procprintdata=w3;run;如想拷贝SAS数据集W的双数行，可以用下列语句建立SAS数据集w4：Dataw4;Setw;If2*int(no/2)-no=0;Procprintdata=w4;run;例4.6dataseason1;inputmonth x y;datalines;1 33 142 32 123 34 11;dataseason2;inputmonth x y;datalines;4 34 135 35 146 35 13;dataseason3;inputmonth x y;datalines;7 35 14 288 34 16 309 34 15 30;dataall;setseason1season2season3;procprint;run;例4.7dataseas1;inputmonth x y;datalines;1 33 142 32 123 34 11;dataseas2;inputmonth yz;datalines;4 13 255 14 276 13 26; Dataseason;Setseas1seas2;Procprintdata=season;Run;例4.8dataw;inputx$yz;datalines;bb15.4bb53.6ba22.6ba31.8bb44.4;procsort;bydescendingxz;procprint;run;例4.9datasales1;inputmonth x y;datalines;1 33 143 32 122 34 11;procsort;bymonth;datasales2;inputmonth yz;datalines;1 14 253 12 272 11 26;procsort;bymonth;datasales3;inputmonth u v;datalines;1 22 412 38 473 18 42;dataallsales;mergesales1sales2sales3;bymonth;procprintdata=allsales;run;例4.10datasales11;inputmonth x y;datalines;435141 33 143 32 122 34 11;procsort;bymonth;datasales12;inputmonth yz;datalines;521281 14 253 12 272 11 26;procsort;bymonth;datasales13;inputmonth u v;datalines;1 22 412 38 473 18 42;dataallsale;mergesales11sales12sales13;bymonth;procprintdata=allsale;run;第5章例5.1Dataw;Inputxyz$u$;datalines;1 2 a C3 4 b d;filenamett3'd:\wu\test3.dat';dataww;setw;filett3;putxyzu;run; 例5.3libnamelibv9'd:\wu';datalib.pdv3;inputxyz$;datalines;12a35b38c;Run;例5.4数据步调用FORMAT语句databirth1;formatbirthdaymmddyy10.bairimmddyy10.;inputbirthdaymmddyy10.;bairi=birthday+100;datalines;05/13/201506/22/1980;Procprint;Run;加工步调用FORMAT语句databirth;inputbirthdaymmddyy10.;bairi=birthday+100;datalines;05/13/201506/22/1980;Procprint;formatbirthdaymmddyy10.bairimmddyy10.;run;例5.5datanumeric;formatx1BEST8.x2COMMA12.x3DOLLAR10.x47.2;inputx1-x4@@;datalines;12345678923456783456789215.671;procprint;run;例5.6Procformat;Value$typenameAUD=’澳大利亚元’CHF=’瑞士法郎’EUR=’欧元’GDP=’英镑’;dataexchange;formattype$typename.;inputtype$@;doday=1to5;inputrate@;output;end;datalines;AUD467.99473.57473.85470.72475.35CHF660.22655.13659.95664.45663.84EUR727.82720.54721.63723.55724.66GDP933.92924.91924.07915.02916.85;Procsort;Byday;procprint;run;例5.7procformat;valuehospname1='xxxxhospital'2='yyyyhospital'3='zzzzhospital';Valueagename0-<3='baby'3-<13='child'13-<20='teenager'20-<65='adult'65-high='senior';datamedipay;formathospitalhospname.ageagename.;infile'd:\wu\medicine.txt';inputnohospitalagemedpay;procprintdata=medipay;run;例5.8datasalary;inputmingzi$gonghaojibengangtiejiangjin;heji=jiben+gangtie+jiangjin;ifheji>1600thenkoushui=(heji-1600)*0.2;elsekoushui=0;shifa=heji-koushui;labelheji=’员工毛收入’koushui=’员工的缴税额’shifa=’实发’;datalines;张三 217 500 300 300李四335800 400 500王五 442 1000 500800;Procmeansdata=salary;Varjibengangtiejiangjinhejikoushuishifa;run;例5.9OPTIONSnodatenonumberls=80;datasalary;inputmingzi$gonghaojibengangtiejiangjin;heji=jiben+gangtie+jiangjin;ifheji>1600thenkoushui=(heji-1600)*0.2;elsekoushui=0;shifa=heji-koushui;labelheji=’员工毛收入’koushui=’员工的缴税额’shifa=’实发’;datalines;/*以下是数据行*/张三 217 500 300 300李四335800 400 500王五 442 1000 500800;/*空语句，数据行已结束*/Procmeansdata=salary;Varjibengangtiejiangjinhejikoushuishifa;run;例5.10Title'甲公司的工资';Optionsnonumbernodatels=80;datasalary;inputmingzi$gonghaojibengangtiejiangjin;heji=jiben+gangtie+jiangjin;ifheji>1600thenkoushui=(heji-1600)*0.2;elsekoushui=0;shifa=heji-koushui;datalines;张三 217 500 300 300李四335800 400 500王五4421000 500800;Procprintdata=salary;Procmeansdata=salary;Varhejikoushui;run;title;procprintdata=salary;run;例5.11Title'甲公司的工资';footnote1'赵强制表';footnote2'刘大为复核';optionsls=80ps=20;OPTIONSnonumbernodate;datasalary;inputmingzi$gonghaojibengangtiejiangjin;heji=jiben+gangtie+jiangjin;ifheji>1600thenkoushui=(heji-1600)*0.2;elsekoushui=0;shifa=heji-koushui;datalines;张三 217 500 300 300李四335800 400 500王五 442 1000 500800;Procprintdata=salary;Procmeansdata=salary;Varhejikoushui;run;footnote;title;第6章例6.1optionsnodatenonumber;title;datagongzi;inputxingming$ jibengongzigonglinggongzijiangligongzichuqinbuzhudiqubuzhu chebu;heji1=jibengongzi+gonglinggongzi;ifheji1>4500thenshuilv=0.2;elseshuilv=0.1;koushui=heji1*shuilv;zhufangbutie=heji1*0.1;gongjijin=heji1*0.11;yanglaojin=160;shifa=heji1+jiangligongzi+chuqinbuzhu+diqubuzhu+chebu+zhufangbutie-koushui-gongjijin-yanglaojin;datalines;赵甲 2800 180 300 600 500 500钱乙 3300 480 300 600 500 800孙丙 4000 1600300 600500 800;Filenamett3‘d:/test3.txt';datasalary;setgongzi;filett3;put'';put//@10'2016年2月工资单'//@5'姓名'xingming/@5'基本工资'jibengongzi/@5'工龄工资'gonglinggongzi/@5'奖励工资'jiangligongzi/@5'出勤补助'chuqinbuzhu/@5'地区补助'diqubuzhu/@5'车补'chebu/@5'税率'shuilv'扣税'koushui/@5'代缴养老金'yanglaojin/@5'代缴公积金'gongjijin/@5'实发'shifa;put_page_;run;例6.2datahighweig;inputnoarea$team$gender$highweight;datalines; 1 a3 c3 1 167 572 a2 c2 2 167 483 a2 c1 1 172 644 a1 c2 1 176 775 a3 c3 2 165 436 a3 c2 1 170 597 a1 c1 2 168 538 a2 c4 2 169 519 a1 c3 1 177 7510 a2 c4 1 176 6511 a1 c4 1 178 7412 a2 c3 1 174 6713 a3 c1 2 167 4614 a2 c2 1 173 6215 a1 c3 2 171 5616 a3 c4 2 162 4817 a2 c1 2 170 5018 a1 c2 2 169 5819 a1 c1 1 174 7220 a3 c1 1 173 6021 a3 c3 1 167 5722 a2 c2 2 167 4823 a2 c1 1 172 6424 a1 c2 1 176 7725 a3 c3 2 165 4326 a3 c2 1 170 5927 a1 c1 2 168 5328 a2 c4 2 169 5129 a1 c3 1 177 7530 a2 c4 1 176 6531 a1 c4 1 178 7432 a2 c3 1 174 6733 a3 c1 2 167 4634 a2 c2 1 173 6235 a1 c3 2 171 5636 a3 c3 1 167 5737 a2 c2 2 167 4838 a2 c1 1 172 6439 a1 c2 1 176 7740 a3 c3 2 165 43;proctabulate;classarea;varhigh;tablemean*high*(areaall);run; 例6.3datahighweig;inputnoarea$team$gender$highweight;datalines; 1 a3 c3 1 167 572 a2 c2 2 167 483 a2 c1 1 172 644 a1 c2 1 176 775 a3 c3 2 165 436 a3 c2 1 170 597 a1 c1 2 168 538 a2 c4 2 169 519 a1 c3 1 177 7510 a2 c4 1 176 6511 a1 c4 1 178 7412 a2 c3 1 174 6713 a3 c1 2 167 4614 a2 c2 1 173 6215 a1 c3 2 171 5616 a3 c4 2 162 4817 a2 c1 2 170 5018 a1 c2 2 169 5819 a1 c1 1 174 7220 a3 c1 1 173 6021 a3 c3 1 167 5722 a2 c2 2 167 4823 a2 c1 1 172 6424 a1 c2 1 176 7725 a3 c3 2 165 4326 a3 c2 1 170 5927 a1 c1 2 168 5328 a2 c4 2 169 5129 a1 c3 1 177 7530 a2 c4 1 176 6531 a1 c4 1 178 7432 a2 c3 1 174 6733 a3 c1 2 167 4634 a2 c2 1 173 6235 a1 c3 2 171 5636 a3 c3 1 167 5737 a2 c2 2 167 4838 a2 c1 1 172 6439 a1 c2 1 176 7740 a3 c3 2 165 43;proctabulate;classarea;varhigh;tablemean*high*(areaall);run;例6.4（设数据集highweig已生成）制有关身高和体重的2维表可用程序proctabulatedata=highweig;classgenderarea;varhighweight;tablegenderall,mean*high*(areaall);tablegenderall,mean*weight*(areaall);run;如果要身高和体重并行，使用如下程序：optionsls=156;proctabulatedata=highweig;classgenderarea;varhighweight;tablegenderall,mean*(highweight)*(areaall);run;例6.5（设数据集highweig已生成）proctabulatedata=highweig;classteamareagender;varhigh;tablegenderall,teamall,mean*high*(areaall);run;例6.6datad4;infile'd:/wu/yield.txt';inputnosoilfarmfertilizerstrainyield;proctabulatedata=d4;classsoilfarmfertilizerstrain;varyield;tablesoil*farm,fertilizerall,mean*yield*(strainall);run;例6.7proctabulatedata=highweig;classgenderteamarea;tablegender,area,team;run;例6.7procformat;value$gendname1='男'2='女';value$areaname a1='地区1'a2='地区2'a3='地区3';value$teamnamec1='1班'c2='2班'c3='3班'c4='4班';datahighweig1;formatarea$areaname.gender$gendname.team$teamname.;labelarea=’地区’gender=’性别’high='身高'weight='体重';sethighweig;proctabulate; classgenderareateam; varhigh; Tablegenderall,area=''all,mean='’*high='平均身高'*(team='' all)/box='地区\班级' misstext='无数据'; run; 第7章例7.1Symbol1i=jonev=plusc=red;Symbol2i=splinev=dotc=green;Symbol3i=nonev=starc=black;datastock;inputdate$xyzxdifydifzdif;datalines;05/0718.7319.2422.53...05/0819.8319.3823.551.100.141.0205/0919.9919.5222.890.160.14-0.6605/1018.9919.4821.78-1.00-0.04-1.1105/1118.9819.2722.21-0.01-0.210.4305/1417.9618.9821.65-1.02-0.29-0.5605/1517.4419.3121.43-0.520.33-0.2205/1618.6619.4521.521.220.140.0905/1718.5819.2621.85-0.08-0.190.3305/1819.2120.2523.780.630.991.93;Procgplotdata=stock;plotx*datey*datez*date/overlay;run;例7.2axis1width=3;/*axis1的宽度是型号3*/axis2width=3;/*axis2的宽度是型号3*/dataGOP;labely=’纵坐标’x=’横坐标’;/*将图中y，x改为纵坐标和横坐标*/inputyxgdp;datalines;31.58022.5403350346035405130526043.31054301520;procgplot;bubbley*x=gdp/bcolor=redcaxis=bluehaxis=axis1vaxis=axis2;/*以y为纵轴，x为横轴，gdp为气泡面积画图，气泡为红色，轴为蓝色，横轴为axis1，纵轴为axis2*/title1'TheGDPbubbleplot改';/*标题*/改run;例7.3datameatsale;inputno season$ kind$ process$ sales;labelseason=’季节’kind=’种类’process=’生熟’sales=’销量’;datalines;1 1季度 肉 生 202.12 1季度 禽 生 98.83 1季度 鱼 生 95.04 1季度 肉 熟 99.45 1季度 禽 熟 22.36 1季度 鱼 熟 2.47 2季度 肉 生 198.38 2季度 禽 生 77.29 2季度 鱼 生 55.010 2季度 肉 熟 98.311 2季度 禽 熟 33.412 2季度 鱼 熟 3.213 3季度 肉 生 129.414 3季度 禽 生 75.615 3季度 鱼 生 75.016 3季度 肉 熟 87.517 3季度 禽 熟 34.518 3季度 鱼 熟 12.519 4季度 肉 生 221.320 4季度 禽 生 102.321 4季度 鱼 生 96.022 4季度 肉 熟 35.823 4季度 禽 熟 43.524 4季度 鱼 熟 1.0;procgchartdata=meatsale;blockkind/group=processtype=sumsubgroup=seasonsumvar=sales;pattern1c=cyan;pattern2c=yellow;pattern3c=blue;pattern4c=red;run;例7.4procgchartdata=meatsale;vbarkind/group=processtype=sumsubgroup=seasonsumvar=sales;run;例7.5procsortdata=meatsale;byprocess;procgchartdata=meatsale;byprocess;pieseason/group=kindtype=percent