文档介绍：该【SASbase70答案详解 】是由【才艺人生】上传分享，文档一共【137】页，该文档可以免费在线阅读，需要了解更多关于【SASbase70答案详解 】的内容，可以使用淘豆网的站内搜索功能，选择自己适合的文档，以下文字是截取该文章内的部分文字，如需要获得完整电子版，请下载此文档到您的设备，方便您编辑和打印。SASbase70答案详解SasCrackmanpracticeContents1) 5Thefollowingexampleisbetter: 6Equivalentcoding: ******@missoverdsmdlm 11Infiledsd 11Infiledlm 13Infilemissover 13Input@ 143Libnamedatasetexcel‘’ 154FunctionMDYcharacterversusnumericvariable 175Infileobs 186Keepstatementandkeepoption 197ODSexcelfile 219Thevalueisnotintherangeprocformatvalue 2210Charactervariablebeingautomaticallyconvertedtothenumericvariable 2311Theoutputoftheprocmeans 2512libnamedataset‘’; 2713Twowaystodefinearrays 28Datadatasetname/debug; 3116Day()function 3219WHERE=parisons 3520subsettingif ; 3822libnameprog2'C:\Users\dude\Desktop\prog2'; 4149Anarraycannotbereferencedonakeep=datasetoption 9650Interleavingdatasetswithbystatement:esfirst. 98ontentsdata=_all_; 10453Retainstatementinitializesthevaluetomissingbydefault. 10554retainCity'BeverlyHills'; :noblankbefored. *variable2 11357Sasdatefunction 11658Procformat;valuename(noperiod) 11959Delimitedrawdatafileandtruncover 12060Dropoptioninthedatastep 12361ifAgenotin(15,16)then 12462odshtmlfile='' 12563Dountil 12665Permanentlyassignlabelsinthedatastep 12766doloop 13067Seeamissingvalueasnegativeinfinity . 13569whereCodelike'E_U%'; 13570Datastepdropoption 1361),in跟crackman做sasbase认证试题,bycrackmanBasically,:;;byDepartmentGender;ifFirst.<_insert_code_>thenPayroll=0;Payroll+Wagerate;ifLast.<_insert_code_>;run;?:AComment::datatemp;inputgroupx;cards;;run;/**************************************************.**************************************************/datanew;settemp;bygroup;first=;last=;run;procprint;title'';run;/**************************************************,.**************************************************/datasingledup;settemp;bygroup;;elseoutputdup;run;/**************************************************.**************************************************/datacusum(keep=groupsum);settemp;bygroup;=0;sum+x;;run;procprintdata=cusumnoobs;title'SumofXwithineachgroup';run;SumofXwithineachgroup08:30Wednesday,May23,20127groupsum11022414331435Equivalentcoding:/**************************************************Asanaside,ifyousimplywantthesumofXwithineachgroup,oneofthemanywayofobtainingthisiswithPROCPRINT.**************************************************/procprintdata=temp;title'AlldatawithXsummedwithineachgroup';bygroup;sumx;sumbygroup;run;procmeansdata=tempsum;bygroup;run;AlldatawithXsummedwithineachgroup808:30Wednesday,May23,2012--------------------------------------------group=1-----------------------------------------------------group102--------------------------------------------group=2---------------------------------------------Obsx5786927458899341076--------group414--------------------------------------------group=3---------------------------------------------Obsx1131--------------------------------------------group=4---------------------------------------------Obsx12231312--------group35===582AlldatawithXsummedwithineachgroup908:30Wednesday,May23,2012--------------------------------------------group=1---------------------------------------------TheMEANSProcedureAnalysisVariable:xSum????????????????????????--------------------------------------------group=2---------------------------------------------AnalysisVariable:xSum????????????????????????--------------------------------------------group=3---------------------------------------------AnalysisVariable:xSum????????????????????????--------------------------------------------group=4---------------------------------------------AnalysisVariable:xSum????????????????????????本题考察的是:。本题的意思,数据集SALAR已经按照department和gender排序,现在计算每一个department下每一个gender的某一个变量值的累积和。根据本题的意思,写了一个模拟程序:datacrackman;inputdepartment$gender$salary@;datalines;marketf6000marketm5000marketf5500marketm8000marketf6000marketm7000salesf6000selesm4000salesf6000selesm4000salesf6000selesm4000;procsortdata=crackman;bydepartmentgender;run;dataresult;setcrackman;/*1*/bydepartmentgender;=salary;/*2*/elsesubtotal+salary;/*3*/;/*4*/run;/*5*/这个DATARESULT部分程序执行的过程是这样(不是编译过程):/*我把执行的语句分为标记12345*/