SAS上机实习考试21
1、为比较两种方法对乳酸饮料中脂肪含量测定结果是否不同，某人随机抽取了10份乳酸饮料制品，分别用脂肪酸水解法和哥特里－罗紫法测定其结果如表3-3第(1)~(3)栏。
问两法测定结果是否不同？表两种方法对乳酸饮料中脂肪含量的测定结果(%)编号(1) 哥特里－罗紫法(2)脂肪酸水解法(3)1 0.840 0.5802 0.591 0.5093 0.674 0.5004 0.632 0.3165 0.687 0.3376 0.978 0.5177 0.750 0.4548 0.730 0.5129 1.200 0.99710 0.870 0.5062、为研究国产四类新药阿卡波糖胶囊的降血糖效果，某医院用20名II型糖尿病病人进行同期随机对照试验。
试验者将这些病人随机等分到试验组(用阿卡波糖胶囊)和对照组(用拜唐苹胶囊)，分别测得试验开始前和8周后的空腹血糖，算得空腹血糖下降值见表3-4，能否认为该国产四类新药阿卡波糖胶囊与拜唐苹胶囊对空腹血糖的降糖效果不同？表3-4 试验组和对照组空腹血糖下降值(mmol/L)试验组(n1=10)-0.70 -5.60 2.00 2.80 0.70 3.50 4.00 5.80 7.10 -0.50对照组(n2=10)3.70 6.50 5.00 5.20 0.80 0.20 0.60 3.40 6.60 -1.103. 两组肿瘤患者，单纯放疗组（A）13 例，口服平消胶囊+放疗组（B）12 例，接受放疗前后，血清Sil-2R水平（U/ml）如表所示。
试评价平消胶囊对接受放疗患者血清Sil-2R水平的影响？两组肿瘤患者的血清Sil-2R水平A组 No. 1 2 3 4 5 6 7治疗前 1183.03 822.52 1294.00 852.50 568.89 532.12 896.36治疗后 983.08 469.34 704.39 979.66 1040.33 895.93 612.27No. 8 9 10 11 12 13治疗前 530.46 808.22 375.44 1055.26 614.55 450.22治疗后 616.70 870.14 1245.54 1753.67 1850.56 538.45B组 No. 1 2 3 4 5 6 7治疗前 992.85 767.33 645.85 709.54 995.41 1043.40 1022.76治疗后 236.66 293.00 166.77 204.81 127.27 186.63 200.80No. 8 9 10 11 12治疗前 486.27 694.28 871.44 973.73 1063.76治疗后 151.47 254.49 178.09 147.19 111.224.大量研究显示汉族足月正常产男性新生儿临产前双顶径（BPD）均数为9.3cm。
某医生记录了某山区12名汉族足月正常产男性新生儿临产前双顶径（BPD）资料如下：9.95 9.33 9.49 9.00 10.09 9.15 9.52 9.33 9.16 9.37 9.11 9.27。
试问该地区男性新生儿临产前双顶径（BPD）的是否大于一般新生儿。
5. 在探讨硫酸氧钒降糖作用的实验中，测得两组动物每日进食量如表6-6 所示。
试问两组动物每日进食量是否相同？两组动物每日进食量糖尿病加钒组糖尿病组26.46 46.8925.19 47.2128.70 42.4223.70 47.7024.48 40.7525.19 41.0328.01 45.9823.70 43.4626.10 44.3424.62 45.326．为研究长跑运动对增强普通高校学生的心功能的效果，某学院对随机抽取15名男生，进行5个月的长跑锻炼，5个月前后测得的晨脉数据如表所示，问长跑锻炼后的晨脉次数有否降低？某校15名学生5个月长跑锻炼前后的晨脉次数（单位：次/分钟）学生号 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 锻炼前70 76 56 63 63 56 58 60 67 65 75 66 56 59 72 锻炼后48 54 60 64 48 55 54 45 50 48 56 48 62 49 507. 某医生为了研究一种降血脂新药的临床疗效，按统一纳入标准选择40名高血脂患者，采用完全随机设计方法将患者等分为4组，进行双盲试验。
6周后测得低密度脂蛋白作为试验结果，见表。
问4个处理组患者的低密度脂蛋白含量总体均数有无差别?表4个处理组低密度脂蛋白测量值(mmol/L)分组测量值3.534.59 4.34 2.66 3.59 3.13 2.64 2.56 3.50 3.25安慰剂组降血脂新药2.423.364.32 2.34 2.68 2.95 1.56 3.11 1.81 1.772.4g组2.86 2.28 2.39 2.28 2.48 2.283.21 2.23 2.32 2.684.8g组0.89 1.06 1.08 1.27 1.63 1.89 1.19 2.17 2.28 1.727.2g组8、某研究者采用随机区组设计进行实验，比较三种抗癌药物对小白鼠肉瘤抑瘤效果，先将15只染有肉瘤小白鼠按体重大小配成5个区组，每个区组内3只小白鼠随机接受三种抗癌药物（具体分配结果见例4-3），以肉瘤的重量为指标，试验结果见表4-9。
问三种不同的药物的抑瘤效果有无差别？表不同药物作用后小白鼠肉瘤重量（g）区组A药B药C药1 0.82 0.65 0.512 0.73 0.54 0.233 0.43 0.34 0.284 0.41 0.21 0.315 0.68 0.43 0.249. 为研究克拉霉素的抑菌效果，某实验室对28个短小芽孢杆菌平板依据菌株的来源不同分成了7个区组，每组4种处理。
给予不同的处理后，观察抑菌圈的直径，结果见表9-31，请对该资料进行分析。
28个平板给予不同处理后的抑菌圈直径(mm)区组 A B C D1 18.02 19.41 18.00 19.462 18.12 20.20 18.91 20.383 18.09 19.56 18.21 19.644 18.30 19.41 18.24 19.505 18.26 19.59 18.11 19.566 18.02 20.12 18.13 19.607 18.23 19.94 18.06 19.5410．某研究者欲研究A、B两种菌对小鼠巨噬细胞吞噬功能的激活作用，将59只小鼠随机分为三组，其中一组为生理盐水对照组，用常规巨噬细胞吞噬功能的监测方法，获得三组的吞噬率(%)（下表），试比较三组吞噬率有无差别？不同菌种对小鼠巨噬细胞的吞噬率（％）A菌组B菌组对照组45.0 64.0 70.0 51.0 62.0 89.0 46.0 44.056.0 66.0 71.0 51.0 68.0 91.0 31.0 36.056.0 66.0 74.0 54.0 68.0 93.0 56.0 36.057.0 66.0 74.0 54.0 70.0 48.0 24.060.3 66.0 76.0 59.0 70.0 43.0 18.063.0 67.0 73.0 61.0 71.0 24.0 36.064.0 70.0 93.0 61.0 70.0 18.0 44.064.0 70.0 95.0 61.0 87.0 36.0 36.011．欲对三位运动员的综合技术作出评价，以不同专业层次的8位教师对三位运动员的技术作评分（下表），问不同教师对三位运动员技术水平的评价有无不同？不同教师对三位运动员的技术所作评分教师编号运动员A 运动员B 运动员C1 5.3 6.2 5.82 5.5 6.4 6.03 5.1 4.8 5.54 5.2 5.0 5.55 5.3 6.0 5.66 5.2 4.9 5.47 5.6 6.7 6.08 5.5 6.2 5.912.为研究三种不同处理下大白鼠血糖浓度随室温(℃)的变化，抽取条件相同或相近的24只大白鼠随机分配于三种不同处理进行实验，结果见表：不同处理下大白鼠的血糖浓度(g/L)处理A 0.98 0.96 1.10 1.08 1.20 1.25 1.40 1.45B 0.86 0.80 1.00 1.16 1.15 1.30 1.20 1.40C 0.90 0.95 0.98 1.20 1.22 1.36 1.35 1.50问:三种处理的血糖浓度是否不同？三13、某院欲比较异梨醇口服液（试验组）和氢氯噻嗪+地塞米松（对照组）降低颅内压的疗效。
将200例颅内压增高症患者随机分为两组，结果见表7-1。
问两组降低颅内压的总体有效率有无差别？表7-1 两组降低颅内压有效率的比较组别有效无效合计有效率（%）试验组99 5 104 95.20对照组75 21 96 78.18合计174 26 200 87.0014、某医师欲比较胞磷胆碱与神经节苷酯治疗脑血管疾病的疗效，将78例脑血管疾病患者随机分为两组，结果见表。
问两种药物治疗脑血管疾病的有效率是否相等？表两种药物治疗脑血管疾病有效率的比较组别有效无效合计有效率（%）胞磷胆碱组46 6 52 88.46神经节苷酯组18 8（4.67）26 69.23合计64 14 78 82.0515、某实验室分别用乳胶凝集法和免疫荧光法对111名可疑系统红斑狼疮患者血清中抗核抗体进行测定，结果见表。
问两种方法的检测结果有无差别？表两种方法的检测结果免疫荧光法乳胶凝集法合计+ －+ 11 23 34－44 33 77合计55 56 11116、某单位研究胆囊腺癌、腺瘤的P53基因表达，对同期手术切除的胆囊腺癌、腺瘤标本各10份，用免疫组化法检测P53基因，资料见表7-6。
问胆囊腺癌和胆囊腺瘤的P53基因表达阳性率有无差别？表7-6 胆囊腺癌与胆囊腺瘤P53基因表达阳性率的比较病种阳性阴性合计胆囊腺癌 6 4 10胆囊腺瘤 1 9 10合计7 13 2017、某医师研究物理疗法、药物治疗和外用膏药三种疗法治疗周围性面神经麻痹的疗效，资料见表7-8。
问三种疗法的有效率有无差别？表7-8 三种疗法有效率的比较疗法有效无效合计有效率（%）物理疗法组199 7 206 96.60药物治疗组164 18 182 90.11外用膏药组118 26 144 81.94合计481 51 532 90.4118、某医师在研究血管紧张素I转化酶(ACE)基因I/D多态与Ⅱ型糖尿病肾病(DN)的关系时，将249例Ⅱ型糖尿病患者按有无糖尿病肾病分为两组，资料见表7-9。
问两组Ⅱ型糖尿病患者的ACE基因型分布有无差别？表7-9 DN组与无DN组2型糖尿病患者ACE基因型分布的比较组别DD ID II 合计DN组42（37.8）48（43.3）21（18.9）111无DN组30（21.7）72（52.2）36（26.1）138合计72（28.9）120（48.2）57（22.9）24919、测得某地5801人的ABO血型和MN血型结果如表7-10，问两种血型系统之间是否有关联？表7-10 测得某地5801人的血型结果ABO血型MN血型合计M N MNO 431 490 902 1823A 388 410 800 1598B 495 587 950 2032AB 137 179 32 348合计1451 1666 2684 580120. 某医院收治186例重症乙型脑炎患者，随机分成两组，分别用同样的方剂治疗，但其中一组加一定量的人工牛黄，治疗结果如表所示。
SAS-Base认证考试—70题(21-30)
SAS-Base认证考试—70题(21-30)SAS Base认证考试—70题(21-30)Q 21Given the SAS data set WORK.PRODUCTS: ProdId Price ProductType Sales Ret urns------ ----- ----------- ----- -------K12S 95.50 OUTDOOR 15 2 B132S 2.99 CLOTHING 300 1 0R18KY2 51.99 EQUIPMENT 25 53KL8BY 6.39 OUTDOOR 125 15DY65DW 5.60 OUTDOOR 45 5DGTY23 34.55 EQUIPMENT 67 2The following SAS program is submitted:data WORK.OUTDOOR WORK.CLOTH WORK.EQUIP;set WORK.PRODUCTS;if Sales GT 30;if ProductType EQ 'OUTDOOR' then output WORK.OUTDOOR;else if ProductType EQ 'CLOTHING' then output WORK.CLOTH;else if ProductType EQ 'EQUIPMENT' then output WORK.EQUIP;run;How many observations does theWORK.OUTDOOR data set contain?A. 1B. 2C. 3D. 6答案：B本题知识点：IF子集、OUPUT语句子集IF语句对满足条件的观测输出到正在被创建的数据集中。
Q 22Which step displays a listing of all the data sets in the WORK library?A. proc contents lib=WORK run;B. proc contents lib=WORK.all;run;C. proc contents data=WORK._all_; run;D. proc contents data=WORK _ALL_; run;答案：C本题知识点：PROC CONTENTS过程默认自动打印最近创建的数据集的描述信息PROC CONTENTS;RUN;打印当前目录下的全部数据集的描述信息PROC CONTENTS DATA=_ALL_;RUN;打印WORK临时逻辑库下数据集的描述信息PROC CONTENTSDATA=WORK._ALL_;RUN;Q 23Which is a valid LIBNAME statement?A. libname "_SAS_data_library_location_";B. sasdata libname"_SAS_data_library_location_";C. libname sasdata"_SAS_data_library_location_";D. libname sasdata sas"_SAS_data_library_location_";答案：C本题知识点：LIBNAME定义逻辑库参考第12题。
SAS统计软件知识要点与试题库
SAS 统计软件知识要点与试题库1. 试述SAS系统中PGM、EDITOR、OUTPUT、EXPLORER、RESULT和LOG窗口的功能。
2. 窗口切换(移至前台并击活)可用以下任一种做法实现：(1)点击窗口本身;(2)由菜单项“窗口（W）”可切换到已打开的窗口,或由查看（View）加入新窗口;(3) Ctrl + T ab 依次切换;(4) 用设置的热键; (5) 发布命令;(6) 点击窗口条中某一窗口图标.3. 发布命令有四种方式：在命令框直接键入命令；使用下拉菜单(弹出菜单)；使用工具条；按功能键(KEYS命令显示功能键所表示的命令).4. SAS数据集可以读取的数据类型：数据行直接输入、流行的数据库、其它文件格式5. SAS数据集的描述部分(创建与修改日期，引擎，变量名，类型，长度，标题，格式等）6. 字符型变量的缺失值用空格符表示数值型变量的缺失值用句号“ . ”表示7. SAS逻辑库包括临时库、永久库两种，区别？8. ViewT able窗口提供两种打开数据的方式：Browse模式和Edit模式，区别？9. SAS数据集的变量属性有6个，哪六个？(变量名及标签,类型,长度,输入输出格式).10. 在SAS系统中浏览和编辑SAS数据集一般必须先设定SAS逻辑库(文件库)，然后将要浏览和编辑的数据集存放在已设定的SAS逻辑库(文件库)中.11. 多个SAS逻辑库可与同一个物理位置项连接;一个SAS逻辑库也可与多个物理位置相连接.12. 新建逻辑库（New Library）的方法:1. 按工具条上图标(New Library)可进入设定新的SAS逻辑库的N ew Library窗口;2. 资源管理器(浏览器)窗口击活时,在下拉菜单中选：文件(File) ⇒新建(New… )⇒逻辑库=>可进入设定新建逻辑库(New Library)窗口.3. 在“SAS 环境”（Environment）处击右键,在弹出的菜单中选新建(New …)=>逻辑库,也可进入新建逻辑库(New Library)窗口.13. 上机试题（1）.用菜单方法建立新库(库标志名为dsta)，此库包含本课程所使用的sas数据集; （2）.用两种方法(菜单或命令)进入ViewT able窗口,并浏览数据集class;（3）先浏览class中SEX=…F‟的观测及AGE>=14的观测,然后浏览全部观测;（4）浏览数据集class的描述信息和数据内容;（5）浏览SAS永久库SASUSER的属性和内容,并浏览数据集AIR的描述信息和数据内容.14. 数据集名应由字母或下划线开始且不超过32个(V6为8) 个字节的字符、数字或下划线构成. 变量名，数组名，库名15. 上机（1）. 用VT命令进入ViewT able窗口,直接输入数据并进行编辑修改后存为sas数据集; （2）. 使用Import窗口菜单系统,将*.txt 转换为sas数据集;（3）. 用数据步建立SAS数据集.16. SAS的Import/Export菜单界面提供一个使用菜单的图形界面:17. SAS语句书写的格式较为灵活:语句可以在某一行的任何位置开始和结束;词间可任意加入空格和换行;一个语句可以写成几行，只要语句中的单词不被断开就可以；多个语句可写在一行；SAS语句用大写字母、小写字母或两者混合书写均可以.18. 通常用DAT A步产生SAS数据集，而用PROC步对SAS数据集中的数据进行分析处理并输出结果. 一个SAS程序可由一个DAT A步或一个PROC步组成；或者由DAT A 步和PROC步两部分组成；也可由多个DAT A步和PROC步组成.19. SAS的字符型变量缺省的长度是8个字符，可以用LENGTH语句直接指定变量长度。
SAS-base-考试必备-70真题(附答案)
1.The following SAS program is submitted:data WORK.TOTAL;set WORK.SALARY;by Department Gender;if First.<_insert_code_> then Payroll=0;Payroll+Wagerate;if Last.<_insert_code_>;run;The SAS data set WORK.SALARY is currently ordered by Gender within Department.Which inserted code will accumulate subtotals for each Gender within Department?A. GenderB. DepartmentC. Gender DepartmentD. Department GenderAnswer: A-------------------------------------2.Given the following raw data records in TEXT:----|----10---|----20---|----30John,FEB,13,25,14,27,FinalJohn,MAR,26,17,29,11,23,CurrentTina,FEB,15,18,12,13,FinalTina,MAR,29,14,19,27,20,CurrentThe following output is desired:Obs Name Month Status Week1 Week2 Week3 Week4 Week51 John FEB Final $13 $25 $14 $27 .2 John MAR Current $26 $17 $29 $11 $233 Tina FEB Final $15 $18 $12 $13 .4 Tina MAR Current $29 $14 $19 $27 $20 Which SAS program correctly produces the desired output?A.data WORK.NUMBERS;length Name $ 4 Month $ 3 Status $ 7;infile 'TEXT' dsd;input Name $ Month $;if Month='FEB' then input Week1 Week2 Week3 Week4 Status $;else if Month='MAR' then input Week1 Week2 Week3 Week4 Week5 Status $;format Week1-Week5 dollar6.;run;proc print data=WORK.NUMBERS;run;B.data WORK.NUMBERS;length Name $ 4 Month $ 3 Status $ 7;infile 'TEXT' dlm=',' missover;input Name $ Month $;if Month='FEB' then input Week1 Week2 Week3 Week4 Status $;else if Month='MAR' then input Week1 Week2 Week3 Week4 Week5 Status $;format Week1-Week5 dollar6.;run;proc print data=WORK.NUMBERS;run;C.data WORK.NUMBERS;length Name $ 4 Month $ 3 Status $ 7;infile 'TEXT' dlm=',';input Name $ Month $ @;if Month='FEB' then input Week1 Week2 Week3 Week4 Status $;else if Month='MAR' then input Week1 Week2 Week3 Week4 Week5 Status $;format Week1-Week5 dollar6.;run;proc print data=WORK.NUMBERS;run;D.data WORK.NUMBERS;length Name $ 4 Month $ 3 Status $ 7;infile 'TEXT' dsd @;input Name $ Month $;if Month='FEB' then input Week1 Week2 Week3 Week4 Status $;else if Month='MAR' then input Week1 Week2 Week3 Week4 Week5 Status $;format Week1-Week5 dollar6.;run;proc print data=WORK.NUMBERS;run;Answer: C-------------------------------------3.The Excel workbook REGIONS.XLS contains the following four worksheets:EASTWESTNORTHSOUTHThe following program is submitted:libname MYXLS 'regions.xls';Which PROC PRINT step correctly displays the NORTH worksheet?A. proc print data=MYXLS.NORTH;run;B. proc print data=MYXLS.NORTH$;run;C. proc print data=MYXLS.'NORTH'e;run;D. proc print data=MYXLS.'NORTH$'n;run;Answer: D-------------------------------------4.The following SAS program is submitted:data WORK.DATE_INFO;Day="01" ;Yr=1960 ;X=mdy(Day,01,Yr) ;run;What is the value of the variable X?A. the numeric value 0B. the character value "01011960"C. a missing value due to syntax errorsD. the step will not compile because of the character argument in the mdy function.Answer: A-------------------------------------5.Which statement specifies that records 1 through 10 are to be read from the raw data ?A. infile 'customer.txt' 1-10;B. input 'customer.txt' stop@10;C. infile 'customer.txt' obs=10;D. input 'customer.txt' stop=10;Answer: C-------------------------------------6.After a SAS program is submitted, the following is written to the SAS log:101 data WORK.JANUARY;102 set WORK.ALLYEAR(keep=product month num_Sold Cost);103 if Month='Jan' then output WORK.JANUARY;104 Sales=Cost * Num_Sold;105 keep=Product Sales;-----22ERROR 22-322: Syntax error, expecting one of the following: !,!!, &, *, **, +, -, , <=, <>, =, >, >=,AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG,NL,NOTIN, OR, ^=, |, ||, ~=.106 run;What changes should be made to the KEEP statement to correct the errors in the LOG?A. keep=(Product Sales);B. keep Product, Sales;C. keep=Product, Sales;D. keep Product Sales;Answer: D-------------------------------------7.Which of the following choices is an unacceptable ODS destination for producing output that can be viewed in Microsoft Excel?A. MSOFFICE2KB. EXCELXPC. CSVALLD. WINXPAnswer: D-------------------------------------8.The SAS data set named WORK.SALARY contains 10 observations for each department,and is currently ordered by Department. The following SAS program is submitted:data WORK.TOTAL;set WORK.SALARY(keep=Department MonthlyWageRate);by Department;if First.Department=1 then Payroll=0;Payroll+(MonthlyWageRate*12);if Last.Department=1;run;Which statement is true?A. The by statement in the DATA step causes a syntax error.B. The statement Payroll+(MonthlyWageRate*12); in the data step causes a syntax error.C. The values of the variable Payroll represent the monthly total for each department in the WORK.SALARY data set.D. The values of the variable Payroll represent a monthly total for all values of WAGERATE in the WORK.SALARY data set.Answer: C-------------------------------------10.The following SAS program is submitted:data WORK.RETAIL;Cost='$20,000';Discount=.10*Cost;run;What is the result?A. The value of the variable Discount in the output data set is 2000.No messages are written to the SAS log.B. The value of the variable Discount in the output data set is 2000.A note that conversion has taken place is written to the SAS log.C. The value of the variable Discount in the output data set is missing. A note in the SAS log refers to invalid numeric data.D. The variable Discount in the output data set is set to zero.No messages are written to the SAS log.Answer: C 因为有一个$符号-------------------------------------11.Given the existing SAS program:proc format;value agegrplow-12 ='Pre-Teen'13-high = 'Teen';run;proc means data=SASHELP.CLASS;var Height;class Sex Age;format Age agegrp.;run;Which statement in the proc means step needs to be modified or added to generate the following results:Analysis Variable : HeightNSex Age Obs Minimum MaximumMean------------------------------------------------------------------F Pre-Teen 3 51.3 59.8 55.8Teen 6 56.5 66.5 63.0 M Pre-Teen 4 57.3 64.8 59.7 Teen 6 62.5 72.0 66.8 --------------------------------------------------------------------A. var Height / nobs min max mean maxdec=1;B. proc means data=SASHELP.CLASS maxdec=1 ;C. proc means data=SASHELP.CLASS min max mean maxdec=1;D. output nobs min max mean maxdec=1;Answer: C-------------------------------------12.The Excel workbook QTR1.XLS contains the following three worksheets:JANFEBMARWhich statement correctly assigns a library reference to the Excel workbook?A. libname qtrdata 'qtr1.xls';B. libname 'qtr1.xls' sheets=3;C. libname jan feb mar 'qtr1.xls';D. libname mydata 'qtr1.xls' WORK.heets=(jan,feb,mar);Answer: A-------------------------------------13.The following SAS program is submitted:data WORK.TEST;set WORK.MEASLES(keep=Janpt Febpt Marpt);array Diff{3} Difcount1-Difcount3;array Patients{3} Janpt Febpt Marpt;run;What new variables are created?A. Difcount1, Difcount2 and Difcount3B. Diff1, Diff2 and Diff3C. Janpt, Febpt, and MarptD. Patients1, Patients2 and Patients3Answer: A-------------------------------------14.Which of the following programs correctly invokes the DATA Step Debugger:A.data WORK.TEST debug;set WORK.PILOTS;State=scan(cityState,2,' ');if State='NE' then description='Central';run;B.data WORK.TEST debugger;set WORK.PILOTS;State=scan(cityState,2,' ');if State='NE' then description='Central';run;C.data WORK.TEST / debug;set WORK.PILOTS;State=scan(cityState,2,' ');if State='NE' then description='Central';run;D.data WORK.TEST / debugger;set WORK.PILOTS;State=scan(cityState,2,' ');if State='NE' then description='Central';run;Answer: c-------------------------------------15.Which statement is true concerning the SAS automatic variable _ERROR_?A. It cannot be used in an if/then condition.B. It cannot be used in an assignment statement.C. It can be put into a keep statement or keep= option.D. It is automatically dropped.Answer: D-------------------------------------16.The following SAS program is submitted:data WORK.DATE_INFO;X='04jul2005'd;DayOfMonth=day(x);MonthOfYear=month(x);Year=year(x);run;What types of variables are DayOfMonth, MonthOfYear, and Year?A. DayOfMonth, Year, and MonthOfYear are character.B. DayOfMonth, Year, and MonthOfYear are numeric.C. DayOfMonth and Year are numeric. MonthOfYear is character.D. DayOfMonth, Year, and MonthOfYear are date values.Answer: B-------------------------------------17.Given the following data step:data WORK.GEO;input City $20.;if City='Tulsa' thenState='OK';Region='Central';if City='Los Angeles' thenState='CA';Region='Western';datalines;TulsaLos AngelesBangor;run;After data step execution, what will data set WORK.GEO contain?A.City State Region----------- ----- -------Tulsa OK WesternLos Angeles CA WesternBangor WesternB.City State Region----------- ----- -------Tulsa OK WesternLos Angeles CA WesternBangorC.City State Region----------- ----- -------Tulsa OK CentralLos Angeles CA WesternBangor WesternD.City State Region----------- ----- -------Tulsa OK CentralLos CA WesternAnswer: A-------------------------------------18.Which statement describes a characteristic of the SAS automatic variable_ERROR_?A. The _ERROR_ variable maintains a count of the number of data errors in a DATA step.B. The _ERROR_ variable is added to the program data vector and becomes part of the data set being created.C. The _ERROR_ variable can be used in expressions in the DATA step.D. The _ERROR_ variable contains the number of the observation that caused the data error.Answer: C-------------------------------------19.The SAS data set WORK.ONE contains a numeric variable named Num and a character variable named Char:WORK.ONENum Char--- ----1 233 231 77The following SAS program is submitted:proc print data=WORK.ONE;where Num='1';run;What is output?A.Num Char--- ----1 23B.Num Char--- ----1 231 77C.Num Char--- ----1 233 231 77D. No output is generated.Answer: D-------------------------------------20. The data set WORK.REALESTATE has the variable LocalFee with a format of 9. and a variable CountryFee with a format of 7.;The following SAS program is submitted:data WORK.FEE_STRUCTURE;format LocalFee CountryFee percent7.2;set WORK.REALESTAT;LocalFee=LocalFee/100;CountryFee=CountryFee/100;run;What are the formats of the variables LOCALFEE and COUNTRYFEE in the output dataset?A. LocalFee has format of 9. and CountryFee has a format of 7.B. LocalFee has format of 9. and CountryFee has a format of percent7.2C. Both LocalFee and CountryFee have a format of percent7.2D. The data step fails execution; there is no format for LocalFee.Answer: C-------------------------------------21.Given the SAS data set WORK.PRODUCTS:ProdId Price ProductType Sales Returns------ ----- ----------- ----- -------K12S 95.50 OUTDOOR 15 2B132S 2.99 CLOTHING 300 10R18KY2 51.99 EQUIPMENT 25 53KL8BY 6.39 OUTDOOR 125 15DY65DW 5.60 OUTDOOR 45 5DGTY23 34.55 EQUIPMENT 67 2The following SAS program is submitted:data WORK.OUTDOOR WORK.CLOTH WORK.EQUIP;set WORK.PRODUCTS;if Sales GT 30;if ProductType EQ 'OUTDOOR' then output WORK.OUTDOOR;else if ProductType EQ 'CLOTHING' then output WORK.CLOTH;else if ProductType EQ 'EQUIPMENT' then output WORK.EQUIP; run;How many observations does the WORK.OUTDOOR data set contain?A. 1B. 2C. 3D. 6Answer: B-------------------------------------22.Which step displays a listing of all the data sets in the WORK library?A. proc contents lib=WORK run;B. proc contents lib=WORK.all;run;C. proc contents data=WORK._all_; run;D. proc contents data=WORK _ALL_; run;Answer: c-------------------------------------23.Which is a valid LIBNAME statement?A. libname "_SAS_data_library_location_";B. sasdata libname "_SAS_data_library_location_";C. libname sasdata "_SAS_data_library_location_";D. libname sasdata sas "_SAS_data_library_location_";Answer: C-------------------------------------24.Given the following raw data records:----|----10---|----20---|----30Susan*12/29/1970*10Michael**6The following output is desired:Obs employee bdate years1 Susan 4015 102 Michael . 6Which SAS program correctly reads in the raw data?A.data employees;infile '' dlm='*';input employee $ bdate : mmddyy10. years;run;B.data employees;infile '' dsd='*';input employee $ bdate mmddyy10. years;run;C.data employees;infile '' dlm dsd;input employee $ bdate mmddyy10. years;run;D.data employees;infile '' dlm='*' dsd;input employee $ bdate : mmddyy10. years;run;Answer: D-------------------------------------25.Given the following code:proc print data=SASHELP.CLASS(firstobs=5 obs=15);where Sex='M';run;How many observations will be displayed?A. 11B. 15C. 10 or fewerD. 11 or fewerAnswer: D-------------------------------------26.Which step sorts the observations of a permanent SAS data set by two variables and stores the sorted observations in a temporary SAS data set?A.proc sort out=EMPLOYEES data=EMPSORT;by Lname and Fname;run;B.proc sort data=SASUSER.EMPLOYEES out=EMPSORT;by Lname Fname;run;C.proc sort out=SASUSER.EMPLOYEES data=WORK.EMPSORT;by Lname Fname;run;D.proc sort data=SASUSER.EMPLOYEES out=SASUSER.EMPSORT;by Lname and Fname;run;Answer: B-------------------------------------27.Given the SAS data set WORK.TEMPS:Day Month Temp--- ----- ----1 May 7515 May 7015 June 803 June 762 July 8514 July 89The following program is submitted: proc sort data=WORK.TEMPS;by descending Month Day; run;proc print data=WORK.TEMPS; run;Which output is correct?A.Obs Day Month Temp --- --- ----- ----1 2 July 852 14 July 893 3 June 764 15 June 805 1 May 756 15 May 7B.Obs Day Month Temp --- --- ----- ----1 1 May 752 2 July 853 3 June 764 14 July 895 15 May 706 15 June 80C.Obs Day Month Temp --- --- ----- ----1 1 May 752 15 May 703 3 June 764 15 June 805 2 July 856 14 July 89D.Obs Day Month Temp--- --- ----- ----1 15 May 702 1 May 753 15 June 804 3 June 765 14 July 896 2 July 85Answer: C-------------------------------------28.Given the SAS data set WORK.P2000:Location Pop2000-------- -------Alaska 626931Delaware 783595Vermont 608826Wyoming 493782and the SAS data set WORK.P2008:State Pop2008-------- -------Alaska 686293Delaware 873092Wyoming 532668The following output is desired:Obs State Pop2000 Pop2008 Difference1 Alaska 626931 686293 593622 Delaware 783595 873092 894973 Wyoming 493782 532668 38886 Which SAS program correctly combines the data?A.data compare;merge WORK.P2000(in=_a Location=State)WORK.P2008(in=_b);by State;if _a and _b;Difference=Pop2008-Pop2000;run;B.data compare;merge WORK.P2000(rename=(Location=State))WORK.P2008;by State;if _a and _b;Difference=Pop2008-Pop2000;run;C.data compare;merge WORK.P2000(in=_a rename=(Location=State)) WORK.P2008(in=_b);by State;if _a and _b;Difference=Pop2008-Pop2000;run;D.data compare;merge WORK.P2000(in=_a) (rename=(Location=State)) WORK.P2008(in=_b);by State;if _a and _b;Difference=Pop2008-Pop2000;run;Answer: C-------------------------------------29.The following SAS program is sumbitted:data ;infile 'DATA';input @1 Company $20. @25 State $2. @;if State=' ' then input @30 Year;else input @30 City Year;input NumEmployees;run;How many raw data records are read during each iteration of the DATA step?A. 1B. 2C. 3D. 4Answer: A-------------------------------------30.You're attempting to read a raw data you see the following messages displayed in the SAS Log:NOTE: Invalid data for Salary in line 4 15-23.RULE: ----+----1----+----2----+----3----+----4----+----5--4 120104 F 46#30 11MAY1954 33Employee_Id=120104 employee_gender=F Salary=. birth_date=-2061 _ERROR_=1 _N_=4NOTE: 20 records were read from the infile 'c:\employees.dat'.The minimum record length was 33.The maximum record length was 33.NOTE: The data set WORK.EMPLOYEES has 20 observations and 4 variables. What does it mean?A. A compiler error, triggered by an invalid character for the variable Salary.B. An execution error, triggered by an invalid character for the variable Salary.C. The 1st of potentially many errors, this one occurring on the 4th observation.D. An error on the INPUT statement specification for reading the variable Salary.Answer: B------------------------------------------------------------------31. Given the following raw data records in DATA:----|----10---|----20---|----30Kim,Basketball,Golf,TennisBill,FootballTracy,Soccer,TrackThe following program is submitted:data WORK.SPORTS_INFO;length Fname Sport1-Sport3 $ 10;infile 'DATA' dlm=',';input Fname $ Sport1 $ Sport2 $ Sport3 $;run;proc print data=WORK.SPORTS_INFO;run;Which output is correct based on the submitted program?A.Obs Fname Sport1 Sport2 Sport31 Kim Basketball Golf Tennis2 Bill Football3 Tracy Soccer TrackB.Obs Fname Sport1 Sport2 Sport31 Kim Basketball Golf Tennis2 Bill Football Football Football3 Tracy Soccer Track TrackC.Obs Fname Sport1 Sport2 Sport31 Kim Basketball Golf Tennis2 Bill Football Tracy SoccerD.Obs Fname Sport1 Sport2 Sport31 Kim Basketball Golf Tennis2 Bill FootballAnswer: C------------------------------------------------------------------32.Consider the following data step:data WORK.NEW;set WORK.OLD;Count+1;run;The variable Count is created using a sum statement. Which statement regarding this variable is true?A. It is assigned a value 0 when the data step begins execution.B. It is assigned a value of missing when the data step begins execution.C. It is assigned a value 0 at compile time.D. It is assigned a value of missing at compile time.Answer: C------------------------------------------------------------------33.The following SAS program is submitted:data WORK.TEST;set WORK.PILOTS;if Jobcode='Pilot2' then Description='Senior Pilot';else Description='Unknown';run;The value for the variable Jobcode is: PILOT2.What is the value of the variable Description?A. PILOT2B. UnknownC. Senior PilotD. ' ' (missing character value)Answer: B------------------------------------------------------------------34.A user-defined format has been created using the FORMAT procedure.How is it stored?A. in a SAS catalogB. in a memory resident lookup tableC. in a SAS dataset in the WORK libraryD. in a SAS dataset in a permanent SAS data libraryAnswer: AThese formats must be stored in the WORK.FORMATS or SASUSER.FORMATS catalog------------------------------------------------------------------35.given the SAS data set SASDATA.TWO:X Y-- --5 23 15 6The following SAS program is submitted:data SASUSER.ONE SASUSER.TWO OTHER;set SASDATA.TWO;if X eq 5 then output SASUSER.ONE;if Y lt 5 then output SASUSER.TWO;output;run;What is the result?A.data set SASUSER.ONE has 5 observationsdata set SASUSER.TWO has 5 observationsdata set WORK.OTHER has 3 observationsB.data set SASUSER.ONE has 2 observationsdata set SASUSER.TWO has 2 observationsdata set WORK.OTHER has 1 observationsC.data set SASUSER.ONE has 2 observationsdata set SASUSER.TWO has 2 observationsdata set WORK.OTHER has 5 observationsD. No data sets are output. The DATA step fails execution due to syntax errors. Answer: A------------------------------------------------------------------36.Given the contents of the raw data file 'EMPLOYEE.TXT':----+----10---+----20---+----30--Xing 2 19 2004 ACCTBob 5 22 2004 MKTGJorge 3 14 2004 EDUCThe following SAS program is submitted:data WORK.EMPLOYEE;infile 'EMPLOYEE.TXT';input@1 FirstName $@15 StartDate@25 Department $;run;Which SAS informat correctly completes the program?A. date9.B. mmddyy10.C. ddmmyy10.D. mondayyr10.Answer: B-------------------------------------------------------------37.The SAS data set Fed.Banks contains a variable Open_Date which hasbeen assigned a permanent label of "Open Date". Which SAS program temporarily replaces the label "Open Date" with the label "Starting Date" in the output?A.proc print data=SASUSER.HOUSES label;label Open_Date "Starting Date";run;B.proc print data=SASUSER.HOUSES label;label Open_Date="Starting Date";run;C.proc print data=SASUSER.HOUSES;label Open_Date="Starting Date";run;D.proc print data=SASUSER.HOUSES;Open_Date="Starting Date";run;Answer: B------------------------------------------------------------------ 38.Given the SAS data set WORK.ONE:X Y Z- - --1 A 271 A 331 B 452 A 522 B 693 B 704 A 824 C 91The following SAS program is submitted:data WORK.TWO;set WORK.ONE;by X Y;if First.Y;run;proc print data=WORK.TWO noobs;run;Which report is produced?A.X Y Z-- -- --1 B 452 A 522 B 693 B 704 A 824 C 91B.X Y Z-- -- --1 A 271 B 452 A 522 B 693 B 704 A 824 C 91C.X Y Z-- -- --1 A 331 B 452 A 522 B 693 B 704 A 824 C 91D. The PRINT procedure fails because the data set WORK.TWO is not created in the DATA step.Answer: B------------------------------------------------------------------39.The following SAS program is submitted:data WORK.AUTHORS;array Favorites{3} $ 8 ('Shakespeare','Hemingway','McCaffrey');run;What is the value of the second variable in the dataset WORK.AUTHORS?A. HemingwayB. HemingwaC. ' ' (a missing value)D. The program contains errors. No variables are created.Answer: B------------------------------------------------------------------40.The following SAS program is submitted:data WORK.PRODUCTS;Prod=1;do while(Prod LE 6);Prod + 1;end;run;What is the value of the variable Prod in the output data set?A. 6B. 7C. 8D. . (missing numeric)Answer: B------------------------------------------------------------------41.Given the raw data record in the :----|----10---|----20---|----30---|Stevens James SALES 304-923-3721 14The following SAS program is submitted:data WORK.PHONES;infile 'phone.txt';input EmpLName $ EmpFName $ Dept $ Phone $ Extension;<_insert_code_>run;Which SAS statement completes the program and results in a value of "James Stevens" for the variable FullName?A. FullName=CATX(' ',EmpFName,EmpLName);B. FullName=CAT(' ',EmpFName,EmpLName);C. FullName=EmpFName!!EmpLName;D. FullName=EmpFName + EmpLName;Answer: A------------------------------------------------------------------42.The following SAS program is submitted:data WORK.ONE;Text='Australia, US, Denmark';Pos=find(Text,'US','i',5);run;What value will SAS assign to Pos?A. 0B. 1C. 2D. 12Answer: D------------------------------------------------------------------43.Given the SAS data set WORK.ORDERS:WORK.ORDERSorder_id customer shipped-------- ------------ ---------9341 Josh Martin 02FEB20099874 Rachel Lords 14MAR200910233 Takashi Sato 07JUL2009The variable order_id is numeric; customer is character; and shipped is numeric, contains a SAS date value, and is shown with the DATE9. format.A programmer would like to create a new variable, ship_note, that shows a character value with the order_id,shipped date, and customer name.For example, given the first observation ship_note would have the value "Order 9341 shipped on 02FEB2009 to Josh Martin".Which of the following statement will correctly create the value and assign it to ship_note?A. ship_note=catx(' ','Order',order_id,'shippedon',input(shipped,date9.),'to',customer);B. ship_note=catx(' ','Order',order_id,'shippedon',char(shipped,date9.),'to',customer);C. ship_note=catx(' ','Order',order_id,'shippedon',transwrd(shipped,date9.),'to',customer);D. ship_note=catx(' ','Order',order_id,'shippedon',put(shipped,date9.),'to',customer);Answer: D------------------------------------------------------------------44.The following SAS program is submitted:data ONE TWO SASUSER.TWOset SASUSER.ONE;run;Assuming that SASUSER.ONE exists, how many temporary and permanent SAS data sets are created?A. 2 temporary and 1 permanent SAS data sets are createdB. 3 temporary and 2 permanent SAS data sets are createdC. 2 temporary and 2 permanent SAS data sets are createdD. there is an error and no new data sets are createdAnswer: D------------------------------------------------------------------45.The following SAS program is submitted:ods csvall file='c:\test.cvs';proc print data=WORK.ONE;var Name Score Grade;by IdNumber;run;ods csvall close;What is produced as output?A. A test.cvs that can only be opened in Excel.B. A text test.cvs that can be opened in Excel or in any text editor.C. A text test.cvs that can only be opened in a text editor.D. A test.cvs that can only be opened by SAS.Answer: C------------------------------------------------------------------46.Given the SAS data set WORK.ONE:Obs Revenue2008 Revenue2009 Revenue2010--- ----------- ----------- -----------1 1.2 1.6 2.0The following SAS program is submitted:。
sas考试题库及答案
sas考试题库及答案1. 在SAS中，如何使用`proc print`步骤来输出数据集的前几行？A. 使用`proc print data=dataset;`命令B. 使用`proc print data=dataset firstobs=5;`命令C. 使用`proc print data=dataset first=5;`命令D. 使用`proc print data=dataset top;`命令正确答案是B。
2. 如果想要在SAS中创建一个数据集，并将某个变量的值替换为缺失值，应该如何操作？A. 使用`data`步骤和`if`语句B. 使用`data`步骤和`replace`函数C. 使用`proc sql`步骤D. 使用`proc means`步骤正确答案是A。
3. 在SAS中，如何将一个数据集的列名从`Var1`更改为`Variable1`？A. 使用`rename`语句：`rename Var1=Variable1;`B. 使用`rename`语句：`rename Variable1=Var1;`C. 使用`proc contents`步骤D. 使用`proc print`步骤正确答案是A。
4. 如何在SAS中使用`proc means`步骤来计算数据集的描述性统计量？A. 使用`proc means data=dataset;`命令B. 使用`proc means data=dataset N NMISS MEAN MEDIAN MAX MIN;`命令C. 使用`proc means data=dataset out=means;`命令D. 使用`proc means data=dataset out=means N NMISS MEAN MEDIAN MAX MIN;`命令正确答案是D。
5. 在SAS中，如何使用`proc sort`步骤对数据集进行排序？A. 使用`proc sort data=dataset;`命令B. 使用`proc sort data=dataset out=sorted_dataset;`命令C. 使用`proc sort data=dataset by variable;`命令D. 使用`proc sort data=dataset out=sorted_dataset by variable;`命令正确答案是D。
SAS认证考试样题(123题)
Exam:A00-201Titl e :SAS Base Programming Ver : 11.30.06QUESTION 1In the following SAS program, the input data files are sorted by the NAMES variable:libnametemp 'SAS-data-library';data temp.sales;merge temp.saleswork.receipt;by names;run;Which one of the following results occurs when this program is submitted?A. The program executes successfully and a temporary SAS data set is created.B. The program executes successfully and a permanent SAS data set is created.C. The program fails execution because the same SAS data set is referenced for both read and write operations.D. The program fails execution because the SAS data sets on the MERGE statement are in two different libraries.Answer: BQUESTION 2When the following SAS program is submitted, the data set SASDATA.PRDSALES contains 5000 observations:libnamesastemp 'SAS-data-library';options obs = 500;proc print data = sasdata.prdsales (firsttobs = 100);run;options obs = max;proc means data = sasdata.prdsales (firsttobs = 500);run;How many observations are processed by each procedure?A. 400 for PROC PRINT4500 for PROC MEANSB. 401 for PROC PRINT4501 for PROC MEANSC. 401 for PROC PRINT4500 for PROC MEANSD. 500 for PROC PRINT5000 for PROC MEANSAnswer: BQUESTION 3The following SAS program is submitted:data work.new;length word $7;amount = 7;if amount = 5 then word = 'CAT';else if amount = 7 then word = 'DOG';else work = 'NONE!!!';amount = 5;run;Which one of the following represents the values of the AMOUNT and WORD variables?A. amount word5 DOGB. amount word5 CATC. amount word7 DOGD. amount word7 ' ' (missing character value)Answer: AQUESTION 4Which one of the following is true of the SUM statement in a SAS DATA step program?A. It is only valid in conjunction with a SUM function.B. It is not valid with the SET, MERGE and UPDATE statements.C. It adds the value of an expression to an accumulator variable and ignores missing values.D. It does not retain the accumulator variable value from one iteration of the SAS DATA step to the next.Answer: CQUESTION 5The following SAS program is submitted:data work.sets;do until (prod gt 6);prod + 1;end;run;Which one of the following is the value of the variable PROD in the output data set?A. 5B. 6C. 7D. 8Answer: CQUESTION 6The following SAS program is submitted:proc print data = sasuser.houses;run;<insert OPTIONS statement here>proc means data = sasuser.shoes;run;Which one of the following OPTIONS statements resets the page number to 1 for the second report?A. option pageno = 1;B. option pagenum = 1;C. options reset pageno = 1;D. options reset pagenum = 1;Answer: AQUESTION 7The contents of the raw data file PRODUCT are listed below:----|----10---|----20---|----3024613 $25.31The following SAS program is submitted:data inventory;infile 'product';input idnum 5. @10 price;run;Which one of the following is the value of the PRICE variable?A. 25.31B. $25.31C. . (missing numeric value)D. No value is stored as the program fails to execute due to errors.Answer: CQUESTION 8The contents of the raw data file TYPECOLOR are listed below:----|----10---|----20---|----30daisyyellowThe following SAS program is submitted:data flowers;infile'typecolor';input type $ 1-5 +1 color $;run;Which one of the following represents the values of the variables TYPE and COLOR?A. type colordaisy yellowB. type colordaisy ellowC. type colordaisyyellow (missing character value)D. No values are stored as the program fails to execute due to syntax errors. Answer: BQUESTION 9A raw data record is listed below:----|----10---|----20---|----30son,Travis,The following output is desired:relation firstnameson TravisWhich one of the following SAS programs reads the data correctly?A. data family / dlm = ',';infile 'file-specification';input relation $ firstname $;run;B. option dlm = ',';data family;infile 'file-specification';input relation $ firstname $;run;C. data family;infile 'file-specification' option dlm = ',';input relation $ firstname $;run;D. data family;infile 'file-specification';input relation $ firstname $ / dlm = ',';run;Answer: CQUESTION 10The following SAS program is submitted:libnamerawdata1 'location of SAS data library';filename rawdata2 'location of raw data file';data work.testdata;infile<insert item here>input sales1 salse2;run;Which one of the following is needed to complete the program correctly?A. rawdata1B. rawdata2C. 'rawdata1'D. 'rawdata2'Answer: BQUESTION 11The following SAS program is submitted and reads 100 records from a raw data file:data work.total;infile 'file-specification' end = eof;input name $ salary;totsal+ salary;<insert IF statement here>run;Which one of the following IF statements writes the last observation to the output data set?A. if end = 0;B. if eof = 0;C. if end = 1;D. if eof = 1;Answer: DQUESTION 12The contents of the raw data file FURNITURE are listed below:----|----10---|----20---|----30chair,,tablechair,couch,tableThe following SAS program is submitted:data stock;infile 'furniture' dsd;input item1 $ item2 $ item3 $;run;Which one of the following is the value of the variable named ITEM2 in the first observation of the output data set?A. tableB. ,tableC. . (missing numeric value)D. ' ' (missing character value)Answer: DQUESTION 13A raw data file is listed below:RANCH,1250,2,1,Sheppard Avenue,"$64,000"SPLIT,1190,1,1,Rand Street,"$65,850"CONDO,1400,2,1.5,Market Street,"80,050"TWOSTORY,1810,4,3,Garris Street,"$107,250"RANCH,1500,3,3,Kemble Avenue,"$86,650"SPLIT,1615,4,3,West Drive,"94,450"SPLIT,1305,3,1.5,Graham Avenue,"$73,650"The following SAS program is submitted using the raw data file as input:data work.condo_ranch;infile'file-specification' dsd;input style $ @;if style = 'CONDO' or style = 'RANCH' theninput sqfeet bedrooms baths street $ price : dollar10.;run;How many observations does the WORK.CONDO_RANCH data set contain?A. 0B. 3C. 5D. 7Answer: DQUESTION 14A raw data file is listed below:RANCH,1250,2,1,Sheppard Avenue,"$64,000"SPLIT,1190,1,1,Rand Street,"$65,850"CONDO,1400,2,1.5,Market Street,"80,050"TWOSTORY,1810,4,3,Garris Street,"$107,250"RANCH,1500,3,3,Kemble Avenue,"$86,650"SPLIT,1615,4,3,West Drive,"94,450"SPLIT,1305,3,1.5,Graham Avenue,"$73,650"The following SAS program is submitted using the raw data file as input:data work.condo_ranch;infile'file-specification' dsd;input style $ @;if style = 'CONDO' or style = 'RANCH';input sqfeet bedrooms baths street $ price : dollar10.;run;How many observations will the output data set contain?A. 0B. 3C. 5D. 7Answer: BQUESTION 15The following SAS program is submitted:data numrecords;infile 'file-specification';input @1 patient $15.relative $ 16-26 @;if relative = 'children' theninput @54 diagnosis $15. @;else if relative = 'parents' theninput @28 doctor $15.clinic $ 44-53@54 diagnosis $15. @;input age;run;How many raw data records are read during each iteration of the DATA step during execution?A. 1B. 2C. 3D. 4Answer: AQUESTION 16The following SAS program is submitted:data work.empsalary;set work.people (in = inemp)work.money(in = insal);if insal and inemp;run;The SAS data set WORK.PEOPLE has 5 observations, and the data setWORK.MONEY has 7 observations.How many observations will the data set WORK.EMPSALARY contain?A. 0B. 5C. 7D. 12Answer: AQUESTION 17The contents of two SAS data sets named EMPLOYEE and SALARY are listed below:EMPLOYEE SALARYname age name salaryBruce 30 Bruce 40000Dan 35 Bruce 35000Dan 37000Dan .The following SAS program is submitted:data work.empsalary;merge work.employee (in = inemp)work.salary(in = insal);by name;if inemp and insal;run;How many observations will the data set WORK.EMPSALARY contain?A. 2B. 4C. 5D. 6Answer: BQUESTION 18The SAS data sets WORK.EMPLOYEE and WORK.SALARY are listed below: WORK.EMPLOYEE WORK.SALARYfnameage fname salaryBruce 30 Bruce 25000Dan 40 Bruce 35000Dan 25000The following SAS program is submitted:data work.empdata;merge work.employeework.salary;by fname;totsal+ salary;run;How many variables are output to the WORK.EMPDATA data set?A. 3B. 4C. 5D. No variables are output to the data set as the program fails to execute due to errors. Answer: BQUESTION 19The SAS data sets WORK.EMPLOYEE and WORK.SALARY are shown below: WORK.EMPLOYEE WORK.SALARYfnameage name salaryBruce 30 Bruce 25000Dan 40 Bruce 35000Dan 25000The following SAS program is submitted:data work.empdata;<insert MERGE statement here>by fname;totsal+ salary;run;Which one of the following statements completes the merge of the two data sets by the FNAME variable?A. merge work.employeework.salary (fname = name);B. merge work.employeework.salary (name = fname);C. merge work.employeework.salary (rename = (fname = name));D. merge work.employeework.salary (rename = (name = fname));Answer: DQUESTION 20The following SAS program is submitted:proc sort data=work.employee;by descending fname;proc sort sort data=work.salary;by descending fname;data work.empdata;merge work.employeework.salary;by fname;run;Which one of the following statements explains why the program failed execution?A. The SORT procedures contain invalid syntax.B. The merged data sets are not permanent SAS data sets.C. The data sets were not merged in the order by which they were sorted.D. The RUN statements were omitted after each of the SORT procedures.Answer: CQUESTION 21The following SAS SORT procedure step generates an output data set:proc sort data = sasuser.houses out = report;by style;run;In which library is the output data set stored?A. WORKB. REPORTC. HOUSESD. SASUSERAnswer: AQUESTION 22The following SAS DATA step is submitted:libnametemp 'SAS-data-library';data temp.report;set sasuser.houses;newvar= price * 1.04;run;Which one of the following statements is true regarding the program above?A. The program is reading from a temporary data set and writing to a temporary data set.B. The program is reading from a temporary data set and writing to a permanent data set.C. The program is reading from a permanent data set and writing to a temporary data set.D. The program is reading from a permanent data set and writing to a permanent data set. Answer: DQUESTION 23Which one of the following SAS DATA steps saves the temporary data set named MYDATA as a permanent data set?A. libname sasdata 'SAS-data-library';data sasdata.mydata;copy mydata;run;B. libname sasdata 'SAS-data-library';data sasdata.mydata;keep mydata;run;C. libname sasdata 'SAS-data-library';data sasdata.mydata;save mydata;run;D. libname sasdata 'SAS-data-library';data sasdata.mydata;set mydata;run;Answer: DQUESTION 24The following SAS DATA step is submitted:data sasdata.atlantasasdata.bostonwork.portlandwork.phoenix;set company.prdsales;if region = 'NE' then output bostan;if region = 'SE' then output atlanta;if region = 'SW' then output phoenix;if region = 'NW' then output portland;run;Which one of the following is true regarding the output data sets?A. No library references are required.B. The data sets listed on all the IF statements require a library reference.C. The data sets listed in the last two IF statements require a library reference.D. The data sets listed in the first two IF statements require a library reference. Answer: DQUESTION 25The following SAS DATA step executes on Monday, April 25, 2000:data newstaff;set staff;start_date=today();run;Which one of the following is the value of the variable START_DATE in the output data set?A. a character string with the value '04/25/2000'B. a character string with the value 'Monday, April 25, 2000'C. the numeric value 14725, representing the SAS date for April 25, 2000D. the numeric value 04252000, representing the SAS date for April 25, 2000 Answer: CQUESTION 26The following SAS program is submitted:data work.new;mon= 3;day = 23;year =2000;date = mdy(mon,day,year);run;Which one of the following is the value of the DATE variable?A. a character string with the value '23mar2000'B. a character string with the value '03/23/2000'C. a numeric value of 14692, which represents the SAS date value for March 23, 2000D. a numeric value of 3232000, which represents the SAS date value for March 23, 2000 Answer: CQUESTION 27The following SAS program is submitted:data revenue;set year_1;var1 = mdy(1,15,1960);run;Which one of the following values does the variable named VAR1 contain?A. 14B. 15C. 1151960D. '1/15/1960'Answer: AQUESTION 28The following SAS program is submitted:data work.report;set work.sales_info;if qtr(sales_date) ge 3;run;The SAS data set WORK.SALES_INFO has one observation for each month in the year 2000 and the variable SALES_DATE which contains a SAS date value for each of the twelve months.How many of the original twelve observations in WORK.SALES_INFO are written to the WORK.REPORT data set?A. 2B. 3C. 6D. 9Answer: CQUESTION 29The following SAS program is submitted:?libnametemp 'SAS-data-library';data work.new;set temp.jobs;format newdate mmddyy10.;qdate= qtr(newdate);ddate= weekday(newdate);run;proc print data = work.new;run;The variable NEWDATE contains the SAS date value for April 15, 2000.What output is produced if April 15, 2000 falls on a Saturday?A. Obs newdate qdate ddate1 APR1520002 6B. Obs newdate qdate ddate1 04/15/20002 6C. Obs newdate qdate ddate1 APR1520002 7D. Obs newdate qdate ddate1 04/15/20002 7Answer: DQUESTION 30A raw data record is shown below:07Jan2002Which one of the following informats would read this value and store it as a SAS date value?A. date9.B. ddmonyy9.C. ddMMMyy9.D. ddmmmyyyy9.Answer: AQUESTION 31The contents of the SAS data set PERM.JAN_SALES are listed below: VARIABLE NAME TYPEidnumcharacter variablesales_datenumeric date valueA comma delimited raw data file needs to be created from the PERM.JAN_SALES data set. The SALES_DATE values need to be in a MMDDYY10 form.Which one of the following SAS DATA steps correctly creates this raw data file?A. libname perm 'SAS-data-library';data_null_;set perm.jan_sales;file 'file-specification' dsd = ',';put idnum sales_date : mmddyy 10.;run;B. libname perm 'SAS-data-library';data_null_;set perm.jan_sales;file 'file-specification' dlm = ',';put idnum sales_date : mmddyy 10.;run;C. libname perm 'SAS-data-library';data_null_;set perm.jan_sales;file 'file-specification';put idnum sales_date : mmddyy 10. dlm = ',';run;D. libname perm 'SAS-data-library';data_null_;set perm.jan_sales;file 'file-specification';put idnum sales_date : mmddyy 10. dsd = ',';run;Answer: BQUESTION 32The contents of the SAS data set named PERM.STUDENTS are listed below:Alfred 14Alice13Barbara 13Carol 14The following SAS program is submitted using the PERM.STUDENTS data set as input:Libnameperm 'SAS-date-library';data students;set perm.students;file 'file-specification';put name $15. @5 age 2.;runWhich one of the following represents the values written to the output raw data file?A. ----|----10---|----20---|----30Alfred 14Alice 13Barbara 13Carol 14B. ----|----10---|----20---|----30Alfr14Alic13Barb13aCaro14C. ----|----10---|----20---|----30Alfr14edAlic13eBarb13araCaro14lD. ----|----10---|----20---|----30Alfred 14Alice 13Barbara 13Carol 14Answer: BQUESTION 33The contents of the raw data file TEAM are listed below:----|----10---|----20---|----30Janice 10Henri 11Michael 11Susan 12The following SAS program is submitted:infile 'team';input name $15. age 2.;file 'file-specification';put name $15. =5 age 2.;run;Which one of the following describes the output created?A. a raw data file onlyB. a SAS data set named GROUP onlyC. a SAS data set named GROUP and a raw data fileD. No output is generated as the program fails to execute due to errors.Answer: CQUESTION 34The following SAS program is submitted:data_null_;set old;put sales1 sales2;run;Where is the output written?A. the SAS logB. the raw data file that was opened lastC. the SAS output window or an output fileD. the data set mentioned in the DATA statementAnswer: AQUESTION 35The following SAS program is submitted:data_null_;set old (keep = prod sales1 sales2);file 'file-specification';put sales1 sales2;run;Which one of the following default delimiters separates the fields in the raw data file created?A. : (colon)B. (space)C. , (comma)D. ;(semicolon)Answer: BQUESTION 36The following SAS program is submitted:data allobs;set sasdata.origin (firstobs = 75 obs = 499);run;The SAS data set SASDATA.ORIGIN contains 1000 observations.How many observations does the ALLOBS data set contain?A. 424B. 425C. 499D. 1000Answer: BQUESTION 37The SAS data set named COMPANY.PRICES is listed below: COMPANY.PRICESprodidprice producttype sales returnsK12S 5.10 NETWORK 15 2B132S 2.34 HARDWARE 300 10R18KY2 1.29 SOFTWARE 25 53KL8BY 6.37 HARDWARE 125 15DY65DW 5.60 HARDWARE 45 5DGTY23 4.55 HARDWARE 67 2The following SAS program is submitted:libnamecompany 'SAS-data-library';data hware inter soft;set company.prices (keep = producttype price);if price le 5.00;if producttype = 'HARDWARE' then output HWARE;else if producttype = 'NETWORK' then output INTER;else if producttype = 'SOFTWARE' then output SOFT;run;How many observations does the HWARE data set contain?A. 0B. 2C. 4D. 6Answer: BQUESTION 38The SASDATA.BANKS data set has five observations when the following SASprogram is submitted:libnamesasdata 'SAS-date-library';data allobs;set sasdata.banks;capital=0;do year = 2000 to 2020 by 5;capital + ((capital+2000) * rate);output;end;How many observations will the ALLOBS data set contain?A. 5B. 15C. 20D. 25Answer: DQUESTION 39A raw data file is listed below:----|----10---|----20---|----30John McCloskey 35 71June Rosesette 10 43TinekeJones 9 37The following SAS program is submitted using the raw data file as input: data work.homework;infile 'file-specification';input name $ age height;if age LE 10;run;How many observations will the WORK.HOMEWORK data set contain?A. 0B. 2C. 3D. No data set is created as the program fails to execute due to errors. Answer: CQUESTION 40The following SAS program is submitted:proc contents data = sasuser.airplanes;run;Which one of the following is produced as output?A. the data portion of every data set in the SASUSER libraryB. the data portion of the data set SASUSER.AIRPLANES onlyC. the descriptor portion of every data set in the SASUSER libraryD. the descriptor portion of the data set SASUSER.AIRPLANES onlyAnswer: DQUESTION 41The following SAS program is submitted:proc datasets lib = sasuser;contents data = class varnum;quit;Which one of the following is the purpose of the VARNUM option?A. to print a list of variable namesB. to print the total number of variablesC. to print a list of the variables in alphabetic orderD. to print a list of the variables in the order they were createdAnswer: DQUESTION 42Which one of the following SAS procedures displays the data portion of a SAS data set?A. PRINTB. FSLISTC. CONTENTSD. DATASETSAnswer: AQUESTION 43On which portion(s) of a SAS data set does the PRINT procedure report?A. the data portion onlyB. the descriptor portion onlyC. the descriptor portion and the data portionD. neither the data portion nor the descriptor portionAnswer: AQUESTION 44The following SAS program is submitted:data work.test;set work.staff (keep = jansales febsales marsales);array diff_sales{3} difsales1 - difsales3;array monthly{3} jansales febsales marsales;run;Which one of the following represents the new variables that are created?A. JANSALES, FEBSALES and MARSALESB. MONTHLY1, MONTHLY2 and MONTHLY3C. DIFSALES1, DIFSALES2 and DIFSALES3D. DIFF_SALES1, DIFF_SALES2 and DIFF_SALES3Answer: CQUESTION 45The following SAS program is submitted:data work.test;array agent{4} $ 12 sales1 - sales4;run;Which one of the following represents the variables that are contained in the outputdata set?A. SALES1, SALES2, SALES3, SALES4B. AGENTS1, AGENTS2, AGENTS3, AGENTS4C. None, the DATA step fails because the ARRAY statement can reference only numeric data.D. None, the DATA step fails because the ARRAY statement can reference onlypre-existing variables.Answer: AQUESTION 46The following SAS program is submitted:data stats;set revenue;array weekly{5} mon tue wed thus fri;<insert DO statement here>total = weekly{i} * .25;Which one of the following DO statements completes the program and processes the elements of the WEEKLY array?A. do i = 1 to 5;B. do weekly {i} = 1 to 5;C. do i = mon tue wed thu fri;D. A DO loop cannot be used because the variables referenced do not end in a digit. Answer: AQUESTION 47Which one of the following statements is true regarding the name of a SAS array?A. It is saved with the data set.B. It can be used in procedures.C. It exists only for the duration of the DATA step.D. It can be the same as the name of a variable in the data set.Answer: CQUESTION 48The observations in the SAS data set WORK.TEST are ordered by the values of the variable SALARY.The following SAS program is submitted:proc sort data = work.test out = work.testsorted;by name;run;Which one of the following is the result of the SAS program?A. The data set WORK.TEST is stored in ascending order by values of the NAME variable.B. The data set WORK.TEST is stored in descending order by values of the NAME variable.C. The data set WORK.TESTSORTED is stored in ascending order by values of the NAME variable.D. The data set WORK.TESTSORTED is stored in descending order by values of the NAME variable.Answer: CQUESTION 49The SAS data set WORK.AWARDS is listed below:fnamepointsAmy 2Amy 1Gerard 3Wang 3Wang 1Wang 2The following SAS program is submitted:proc sort data = work.awards;by descending fname points;run;Which one of the following represents how the observations are sorted?A. Wang 3Gerard 3Wang 2Amy 2Wang 1Amy 1B. Wang 3Wang 2Wang 1Gerard 3Amy 2Amy 1C. Wang 3Wang 1Wang 2Gerard 3Amy 2Amy 1D. Wang 1Wang 2Wang 3Gerard 3Amy 1Amy 2Answer: DQUESTION 50The SAS data set EMPLOYEE_INFO is listed below:IDNumberExpenses2542 100.003612 133.152198 234.342198 111.12The following SAS program is submitted:proc sort data = employee_info;<insert BY statement here>run;Which one of the following BY statements completes the program and sorts the data sequentially by ascending expense values within each ascending IDNUMBER value?A. by Expenses IDNumber;B. by IDNumber Expenses;C. by ascending (IDNumber Expenses);D. by ascending IDNumber ascending Expenses;Answer: BQUESTION 51The following SAS program is submitted:libnamecompany 'SAS-data-library';proc sort data = company.payroll;by EmployeeIDNumber;run;Write access has been granted to the COMPANY library.Which one of the following represents how the observations are sorted?A. COMPANY.PAYROLL is recreated in sorted order by EmployeeIDNumber.B. COMPANY.PAYROLL is stored in original order, and a new data set PAYROLL is created in sorted order by EmployeeIDNumber.C. COMPANY.PAYROLL is stored in original order, and a new data set COMPANY.PAYROLLSORTED is created in sorted order by EmployeeIDNumber.D. COMPANY.PAYROLL is recreated in sorted order by EmployeeIDNumber, and a new data set PAYROLL is created in sorted order by EmployeeIDNumber. Answer: AQUESTION 52The SAS data set QTR1_REVENUE is listed below:destination revenueYYZ 53634FRA 62129FRA 75962RDU 76254YYZ 82174The following SAS program is submitted:proc sort data = qtr1_revenue;by destination descending revenue;run;Which one of the following represents the first observation in the output data set?A. destination revenueYYZ 82174B. destination revenueYYZ 53634C. destination revenueFRA 62129D. destination revenueFRA 75962Answer: DThe SAS data set EMPLOYEE_INFO is listed below:IDNumberExpenses2542 100.003612 133.152198 234.342198 111.12The following SAS program is submitted:proc sort data = employee_info;<insert BY statement here>run;Which one of the following BY statements completes the program and sorts the data sequentially by descending expense values within each descending IDNUMBER value?A. by descending IDNumber Expenses;B. by (IDNumber Expenses) descending;C. by IDNumber descending Expenses descending;D. by descending IDNumber descending Expenses;Answer: DQUESTION 54The following SAS program is submitted:data work.new;length word $7;amount = 4;if amount = 4 then word = 'FOUR';else if amount = 7 then word = 'SEVEN';else word = 'NONE!!!';amount = 7;run;Which one of the following represents the values of the AMOUNT and WORD variables?A. amount word7 FOURB. amount word7 SEVENC. amount word4 FOURD. amount word4 ' ' (missing character value)Answer: A。
SAS上机练习题(全部-含参考答案).docx
重庆医科大学“卫生统计学统计软件包SAS上机练习题（一）1、SAS常用的窗口有哪三个？请在三个基本窗口之间切换并记住这些命令或功能键。
2、请在PGM窗口中输入如下几行程序，提交系统执行，并查看OUTPUT窗和LOG窗中内容，注意不同颜色的含义；并根据口志窗屮的信息修改完善程序。
DATS EXO 101;INPUTT NAME $ AGE SEX;CARDS;XIAOMIN 19 1LIDONG 20 1NANA 18 2PROD PRONT DATS=EX1; RUN;PROC PRINT DATA=EX 1;VAR NAME AGE;RUN;3、将第2题的程序、结果及tl志保存到磁盘。
4、试根据如下例1的程序完成后面的问题：表1某班16名学生3门功课成绩表如下问题：1）建立数据集；2）打印至少有1门功课不及格同学的信息；（提示，使用if语句）参考程序:data a;input id sh wl bl;cards;083 68 71 65 084 74 61 68 085 73 75 46 086 79 80 79 087 75 71 68084 85 85 87085 78 79 75086 80 76 79 087 85 80 82 088 77 71 75 089 67 73 71 080 75 81 70118 70 54 75 083 70 66 84 084 62 73 65 099 82 70 79 run;data b;set a;if sh<60 or wl<60 or bl<60 then output; run;proc print data=b;var id sh wl bl;run;5、根据下列数据建立数据集表2销售数据提示：（格式化输入；数据之间以空格分隔，数据对齐；注意格式后面的长度应以前一个位置结朿开始计算，如果读入错误，可试着调整格式的宽度；显示日期需要使用输出格式）开始时间，输入格式yymmddlO.终止时间，输入格式血tel0.费用，输入格式dollar 12.参考程序:data a;input xl yymmddlO. x2 datclO. x3 dollarl3.; cards; 2005/04/282005 09 18 2007/08/12 20040508run;proc print; run;proc print;format xl yymmddlO. x2 date9. x3 dollarl3.; run;6、手机号码一编码规则一般是：YYY-XXXX-ZZZZ,其YYY 为号段；XXXX —般 为所在地区编码；ZZZZ 为对应的个人识别编号。
SAS试卷模板及解答
统计分析系统SAS试卷及解析班级：学号姓名一、数据集的建立（20分）汉语拼音为名存入你的文件夹。
二、正态性检验（20分，每空2分）对上述数据，用INSIGHT软件进行正态性检验。
1．从SAS主窗口进入INSIGHT软件环境，依次应选择的菜单是：Solutions/Analysis/Interactive Data Analysis。
2．在INSIGHT主窗口中，选择作正态性检验，依次应选择的菜单是：Analyze/Distribution(Y) 。
3．对“每人月平均销售额”数据进行正态性检验，得到的Shapiro-Wilk 检验统计量的P值为0.7022 ，标准差为2211.0832 ，极差为7000 ，该数据的分布为正态（正态/非正态）。
4．对“利润”数据进行正态性检验，得到中位数为11.35，变异系数为46.3469 ，“利润”数据中有25%的值小于 6.6，利润数据的分布为正态（正态/非正态）。
三、绘图（20分，每空4分）在分析家中绘制上述图，相关的选项为：Point symbol: SQUARE,Connect lines: connect points with straight lines, line style: Solid, Number of minor horizontal tick marks: 1, Number of minor vertical tick marks: 0。
解析：①依次点击菜单”Solutions/Analysis/Analyst”进入分析家环境;②在分析家中打开数据集;③依次点击菜单”Graphs/Scatter Plots/ 2dimensions”,在系统弹出的对话框中,作如下设置:(填空如上)四、相关分析（20分，每空3分，正确上传文件5分）1．在SAS的分析家中进行相关分析，得到两变量的相关系数为：0.98738 ，检验概率为：<0.0001 ,你的结论是：两变量的相关关系为：密切相关。
医学统计学SAS上机考试
1-性别-卡方-和年龄-T-的两组比较The FREQ ProcedureTable of sex by groupsex(sex) group(group)频 数Frequency|列百分比Col Pct | 1| 2| Total---------+--------+--------+1 | 38 | 43 | 81| 31.15 | 36.44 |---------+--------+--------+2 | 84 | 75 | 159| 68.85 | 63.56 |---------+--------+--------+Total 122 118 240Statistics for Table of sex by groupStatistic DF Value Prob卡方 Chi-Square 1 0.7516 0.3860 N≥40且T≥5连续矫正卡方Continuity Adj. Chi-Square 1 0.5335 0.4651 N≥40且1≤T＜5Fisher's Exact Test F确切检验Two-sided Pr <= P 0.4146 N≤40或T＜1性别 实验组 对照组 合计男 38 43 81女 84 75 159合计 122 118 240建立检验假设，确定检验水平：H0：不同组男女构成比相等，π1＝π2H1：不同组男女构成比不同，π1≠π2α=0.05计算检验统计量，求得P值。
统计推断结论：P＞0.05，按α=0.05水平不拒绝H0，差异无统计学意义，根据现有资料认为：The TTEST ProcedureLower CL Upper CL Lower CL Upper CLVariable group N Mean Mean Mean Std Dev Std Dev Std Dev Std Errage 1 122 34.941 37.025 39.108 10.327 11.625 13.3 1.0525age 2 118 34.959 36.89 38.82 9.3889 10.589 12.144 0.9748T-TestsVariable Method Variances DF t Value Pr > |t|age Pooled Equal 238 0.09 0.9254 方差齐age Satterthwaite Unequal 237 0.09 0.9252 方差不齐Equality of VariancesVariable Method Num DF Den DF F Value Pr > Fage Folded F 121 117 1.21 0.3107 P＞0.05方差齐P＜0.05不齐实验组 对照组组别P值MEAN STD MEAN STD年龄 37.025 11.625 36.89 10.589 0.9254建立检验假设，确定检验水平：H0：不同组平均年龄相等，μ1＝μ2H1：不同组平均年龄不同，μ1≠μ2α=0.05计算检验统计量，求得P值。
SAS认证考试样题(50题)
SAS 中文论坛网站1.A raw data file is listed below.1---+----10---+----20---+---son Frank 01/31/89daughter June 12-25-87brother Samuel 01/17/51The following program is submitted using this file as input:data work.family;infile 'file-specification';<insert INPUT statement here >run;Which INPUT statement correctly reads the values for the variable Birthdate as SAS date values?a. i nput relation $ first_name $ birthdate date9.;b.i nput relation $ first_name $ birthdate mmddyy8.; c.i nput relation $ first_name $ birthdate : date9.; d.i nput relation $ first_name $ birthdate : mmddyy8.; Correct answer: dAn informat is used to translate the calendar date to a SAS date value. The date values are in the form of two-digit values for month-day-year, so the MMDDYY8. informat must be used. When using an informat with list input, the colon-format modifier is required to correctly associate the informat with the variable name.You can learn about•informats in Reading Date and Time Values • the colon-format modifier in Reading Free-Format Data .2.A raw data file is listed below.1---+----10---+----20---+---Jose,47,210Sue,,108The following SAS program is submitted using the raw data file above as input: data employeestats;<insert INFILE statement here>input name $ age weight;run;The following output is desired:name age weight Jose 47 210 Sue . 108Which of the following INFILE statements completes the program and accesses the data correctly?a. infile 'file-specification ' pad;b. infile 'file-specification ' dsd;SAS 中文论坛网站c. infile 'file-specification ' dlm=',';d. infile 'file-specification ' missover;Correct answer: bThe PAD option specifies that SAS pad variable length records with blanks. TheMISSOVER option prevents SAS from reading past the end of the line when reading free formatted data. The DLM= option specifies the comma as the delimiter; however,consecutive delimiters are treated as one by default. The DSD option correctly reads the data with commas as delimiters and two consecutive commas indicating a missing value like those in this raw data file.You can learn about• the PAD option in Reading Raw Data in Fixed Fields•the MISSOVER option in Creating Multiple Observations from a SingleRecord• the DLM= option and the DSD option in Reading Free-Format Data . 3.The following program is submitted:data numrecords;infile cards dlm=',';input agent1 $ agent2 $ agent3 $;cards;jones,,brownjones,spencer,brown;run;What is the value for the variable named Agent2 in the second observation?a.brown b.spencer c.' ' (missing character value) d. There is no value because only one observation is created.Correct answer: dThe CARDS statement enables you to read instream data. Any number of consecutive commas are considered to be a single delimiter as a result of the DLM= option, and the length of each variable defaults to 8 bytes. Therefore, the values jones , brownjon , and spencer are assigned to Agent1, Agent2, and Agent3, respectively, for the firstobservation. The rest of the data on the record is not read by the INPUT statement and is not output to the data set.You can learn about•the CARDS statement in Creating SAS Data Sets from Raw Data • the default length of variables in Reading Free-Format Data .4.A raw data file is listed below.1---+----10---+----20---+----30---+----40---+----50TWOSTORY 1040 2 1SANDERS ROAD $55,850CONDO 2150 4 2.5JEANS AVENUE $127,150The following program is submitted using this file as input:data work.houses;infile 'file-specification';<insert INPUT statement here>run;Which one of the following INPUT statements reads the raw data file correctly?a.input @1 style $8.+1 sqfeet 4.+1 bedrooms 1.@20 baths 3.street 16.@40 price dollar8;b.input @1 style $8+1 sqfeet 4.+1 bedrooms 1.@20 baths 3.street $16@40 price dollar8.;c.input @1 style $8.+1 sqfeet 4.+1 bedrooms 1.@20 baths 3.street $16.@40 price dollar8.;d.input @1 style $8.+1 sqfeet 4.+1 bedrooms 1.@20 baths 3street 16.@40 price dollar8.;Correct answer: cFormatted input requires periods as part of the informat name. The period is missing from the variables Style and Street in Answer b, the variable Baths in Answer d, and the variable Price in Answer a (which is also missing a dollar sign to read the variable Street as a character value).You can learn about formatted input and informats in Reading Raw Data in Fixed Fields.5. The following SAS program is submitted at the start of a new SAS session:libname sasdata 'SAS-data-library';data sasdata.sales;set sasdata.salesdata;profit=expenses-revenues;run;SAS中文论坛网站SAS 中文论坛网站proc print data=sales;run;The SAS data set Sasdata.Salesdata has ten observations. Which one of the following explains why a report fails to generate?a. The DATA step fails execution.b. The SAS data set Sales does not exist.c. The SAS data set Sales has no observations.d. The PRINT procedure contains a syntax error.Correct answer: bThe DATA step creates a permanent SAS data set, Sasdata.Salesdata . The PRINTprocedure is printing a temporary SAS data set, Sales , that is stored in the Work library. At the beginning of the SAS session, Work.Sales does not exist.You can learn about•creating permanent data sets with the DATA step in Creating SAS Data Setsfrom Raw Data• temporary data sets in Basic Concepts . 6. Which action assigns a reference named SALES to a permanent SAS data library? a. Issuing the command:libref SALES 'SAS-data-library'b. Issuing the command:libname SALES 'SAS-data-library'c.Submitting the statement: libref SALES 'SAS-data-library';d. Submitting the statement: libname SALES 'SAS-data-library';Correct answer: dThe LIBNAME statement assigns a reference known as a libref to a permanent SAS data library. The LIBNAME command opens the LIBNAME window.You can learn about the LIBNAME statement in Referencing Files and Setting Options .7. The following SAS program is submitted:data newstaff;set staff;<insert WHERE statement here>run;Which one of the following WHERE statements completes the program and selects only observations with a Hire_date of February 23, 2000?a. where hire_date='23feb2000'd;b. where hire_date='23feb2000';c. where hire_date='02/23/2000'd;d.where hire_date='02/23/2000';Correct answer: aA SAS date constant must take the form of one- or two-digit day, three-digit month, and two- or four-digit year, enclosed in quotation marks and followed by a d('ddmmmyy<yy>'d).You can learn about SAS date constants in Creating SAS Data Sets from Raw Data. 8. Which one of the following SAS date formats displays the SAS date value for January 16, 2002 in the form of 16/01/2002?a. DATE10.b. DDMMYY10.c. WEEKDATE10.d. DDMMYYYY10.Correct answer: bThe requested output is in day-month-year order and is 10 bytes long, so DDMMYY10. is the correct format. Although WEEKDATE10. is a valid SAS format, it does not display the SAS date value as shown in the question above. DDMMYYYY10. is not a valid SAS date format, and the DATE w. format cannot accept a length of 10.You can learn about•the DDMMYY10. format in Creating List Reports•the WEEKDATE10. format in Reading Date and Time Values.9. Which one of the following displays the contents of an external file from within a SAS session?a. the LIST procedureb.the PRINT procedurec.the FSLIST procedured.the VIEWTABLE windowCorrect answer: cThe PRINT procedure and VIEWTABLE window display the values in SAS data sets. The FSLIST procedure displays the values in external files. There is no LIST procedure in SAS.You can learn about•the PRINT procedure in Creating List ReportsSAS中文论坛网站SAS 中文论坛网站• the VIEWTABLE window in Referencing Files and Setting Options .10. The SAS data set Sashelp.Prdsale contains the variables Region and Salary with 4 observations per Region . Sashelp.Prdsale is sorted primarily by Region and within Region by Salary in descending order.The following program is submitted:data one;set sashelp.prdsale;retain temp;by region descending salary;if first.region thendo;temp=salary;output;end;if last.region thendo;range=salary-temp;output;end;run;For each region, what is the number of observation(s) written to the output data set? a. 0b. 1c. 2d. 4Correct answer: cThe expression first.region is true once for each region group. The expression last.region is true once for each region group. Therefore, each OUTPUT statement executes once for a total of 2 observations in the output data set.You can learn about the FIRST.variable expression and the OUTPUT statement in Reading SAS Data Sets .11. The following SAS program is submitted:proc contents data=sasuser.houses;run;The exhibit below contains partial output produced by the CONTENTS procedure. Data Set NameSASUSER.HOUSES Observations 15 Member TypeDATA Variables 6 EngineV9 Indexes 0 CreatedTuesday, April 22, 2003 03:09:25 PMObservation Length 56 Last ModifiedTuesday, April 22, 2003 03:09:25 PMDeleted Observations0 Protection CompressedNOData Set Type Sorted NOLabel Residential housingfor saleData Representation WINDOWS_32Encoding wlatin1 Western(Windows)Which of the following describes the Sasuser.Houses data set?a.The data set is sorted but not indexed.b.The data set is both sorted and indexed.c.The data set is not sorted but is indexed.d.The data set is neither sorted nor indexed.Correct answer: dThe exhibit above shows partial output from the CONTENTS procedure, In the top right-hand column of the output, you see that Indexes has a value of 0, which indicates that no indexes exist for this data set. Also, Sorted has a value of NO, which indicates that the data is not sorted.You can learn about the CONTENTS procedure in Referencing Files and Setting Options.12.The following SAS program is submitted:proc sort data=work.test;by fname descending salary;run;Which one of the following represents how the observations are sorted?a. The data set Work.Test is stored in ascending order by both Fname and Salary values.b. The data set Work.Test is stored in descending order by both Fname and Salary values.c. The data set Work.Test is stored in descending order by Fname and ascending order by Salary values.d. The data set Work.Test is stored in ascending order by Fname and in descending order by Salary values.Correct answer: dThe DESCENDING keyword is placed before the variable name it modifies in the BY statement, so the correct description is in descending order by Salary value within ascending Fname values.You can learn about the SORT procedure and the DESCENDING keyword in Creating List Reports.13.The following SAS program is submitted:data names;SAS中文论坛网站title='EDU';if title='EDU' thenDivision='Education';else if title='HR' thenDivision='Human Resources';else Division='Unknown';run;Which one of the following represents the value of the variable Division in the output data set?catiocationc.Human Red.Human ResourcesCorrect answer: bThe length of the variable Division is set to 9 when the DATA step compiles. Since the value of the variable Title is EDU, the first IF condition is true; therefore, the value of the variable Division is Education.You can learn about•the length of a variable in Understanding DATA Step Processing•IF-THEN statements in Creating and Managing Variables.14.Which one of the following SAS programs creates a variable named City with a value of Chicago?a.data work.airports;AirportCode='ord';if AirportCode='ORD' City='Chicago';run;b.data work.airports;AirportCode='ORD';if AirportCode='ORD' City='Chicago';run;c.data work.airports;AirportCode='ORD';if AirportCode='ORD' then City='Chicago';run;d.data work.airports;AirportCode='ORD';if AirportCode='ORD';then City='Chicago';run;Correct answer: cThe correct syntax for an IF-THEN statement is: IF expression THEN statement;In this example, the variable City is assigned a value of Chicago only if the expression AirportCode='ORD' is true.SAS中文论坛网站SAS 中文论坛网站You can learn about IF-THEN statements in Creating and Managing Variables .15.The following SAS program is submitted:data work.building;code='DAL523';code='SANFRAN604';code='HOUS731';length code $ 20;run;Which one of the following is the length of the code variable?a. 6b. 7c. 10d. 20Correct answer: aThe DATA step first goes through a compilation phase, then an execution phase. The length of a variable is set during the compilation phase and is based on the first time the variable is encountered. In this case, the variable code is set to the length of the text string DAL523 which is 6 characters long. The next assignment statements are ignored during compilation. The LENGTH statement is also ignored since the length has already been established, but a note will be written to the log.You can learn about•the compilation phase of the DATA step in Understanding DATA StepProcessing• the LENGTH statement in Creating and Managing Variables .16. Which of the following statements creates a numeric variable named IDnumber with a value of 4198?a. IDnumber=4198;b. IDnumber='4198';c. length IDnumber=8;d. length IDnumber $ 8;Correct answer: aThe first reference to the SAS variable in the DATA step sets the name, type, and length of the variable in the program data vector (PDV) and in the output SAS data set. The assignment statement IDnumber=4198; is the first reference and creates a numeric variable named IDnumber with a default storage length of 8 bytes.You can learn about• creating variables in the DATA step in Understanding DATA Step ProcessingSAS 中文论坛网站• numeric variables in Basic Concepts .17. The following program is submitted:data fltaten;input jobcode $ salary name $;cards;FLAT1 70000 BobFLAT2 60000 JoeFLAT3 30000 Ann;run;data desc;set fltaten;if salary>60000 then description='Over 60';else description='Under 60';run;What is value of the variable named description when the value for salary is 30000? a.Under 6 b.Under 60 c.Over 60 d. ' ' (missing character value)Correct answer: aThe variable description is being created by the IF-THEN/ELSE statement during compilation. The first occurrence of the variable description is on the IF statement, and since it is assigned the value Over 60, the length of the variable is 7. Therefore, for the salary value of 30000, description has the value of Under 6 (the 0 is truncated.) You can learn about•the compilation phase of the DATA step in Understanding DATA StepProcessing• IF-THEN/ELSE statements in Creating and Managing Variables .18. A raw data file is listed below.1---+----10---+----20---+---10232015The following program is submitted:data all_sales;infile 'file-specification';input receipts;<insert statement(s) here>run;SAS 中文论坛网站Which statement(s) complete(s) the program and produce(s) a running total of the Receipts variable?a. total+receipts;b.total 0; sum total;c. total=total+receipts;d. total=sum(total,receipts);Correct answer: aThe SUM function and the assignment statement do not retain values across iterations of the DATA step. The sum statement total+receipts; initializes total to 0, ignores missing values of receipt , retains the value of total from one iteration to the next, and adds the value of receipts to total .You can learn about the sum statement in Creating and Managing Variables .19.A raw data file is listed below.1---+----10---+----20---+---1901 21905 11910 61925 11941 1The following SAS program is submitted and references the raw data file above: data money;infile 'file-specification';input year quantity;total=total+quantity;run;What is the value of total when the data step finishes executing?a.0 b.1 c.11 d. . (missing numeric value)Correct answer: dThe variable Total is assigned a missing value during the compilation phase of the DATA step. When the first record is read in, SAS processes: total=.+2; which results in a missing value. Therefore the variable Total remains missing for all observations. You can learn about• the compilation phase of the DATA step in Understanding DATA StepProcessingSAS 中文论坛网站• using missing values with arithmetic operators in Creating SAS Data Sets fromRaw Data .20.The following program is submitted:data test;average=mean(6,4,.,2);run;What is the value of average ?a.0 b.3 c.4 d. . (missing numeric value)Correct answer: cThe MEAN function adds all of the non-missing values and divides by the number of non-missing values. In this case, 6 + 4 + 2 divided by 3 is 4.You can learn about the MEAN function in Transforming Data with SAS Functions .21.The following SAS program is submitted:data work.AreaCodes;Phonenumber=3125551212;Code='('!!substr(Phonenumber,1,3)!!')';run;Which one of the following is the value of the variable Code in the output data set? a. ( 3)b. (312)c. 3d. 312Correct answer: aAn automatic data conversion is performed whenever a numeric variable is used where SAS expects a character value. The numeric variable is written with the BEST12. format and the resulting character value is right-aligned when the conversion occurs. In this example, the value of Phonenumber is converted to character and right-aligned before the SUBSTR function is performed. Since there are only 10 digits in the value ofPhonenumber , the right-aligned value begins with two blanks. Therefore the SUBSTR function picks up two blanks and a 3, and uses the BEST12. format to assign that value to Code . Then, the parentheses are concatenated before and after the two blanks and a 3. You can learn about automatic data conversion and the SUBSTR function inTransforming Data with SAS Functions .22.The following SAS program is submitted:data work.inventory;products=7;SAS 中文论坛网站do until (products gt 6);products+1;end;run;Which one of the following is the value of the variable products in the output data set? a. 5b. 6c. 7d. 8Correct answer: dA DO UNTIL loop always executes at least once because the condition is not evaluated until the bottom of the loop. In the SAS program above, the value of Products isincremented from 7 to 8 on the first iteration of the DO UNTIL loop, before the condition is checked. Therefore the value of Products is 8.You can learn about DO UNTIL loops in Generating Data with DO Loops .23.The following program is submitted:data work.test;set work.staff (keep=salary1 salary2 salary3);<insert ARRAY statement here>run;Which ARRAY statement completes the program and creates new variables?a. array salary{3};b. array new_salary{3};c. array salary{3} salary1-salary3;d. array new_salary{3} salary1-salary3;Correct answer: bAlthough each of the ARRAY statements listed above is a valid statement, only AnswerB creates new variables named new_salary1, new_salary2 and new_salary3. AnswerC and AnswerD both create an array that groups the existing data set variables salary1, salary2, and salary3. Since the array in Answer A is named salary , it also uses the existing data set variables.You can learn about creating new variables in an ARRAY statement in Processing Variables with Arrays .24.Which of the following permanently associates a format with a variable?a. the FORMAT procedureb. a FORMAT statement in a DATA stepc. an INPUT function with format modifiersd. an INPUT statement with formatted style inputCorrect answer: bSAS 中文论坛网站To permanently associate a format with a variable, you use the FORMAT statement in a DATA step. You can use the FORMAT procedure to create a user-defined format. You use the INPUT function to convert character data values to numeric values with an informat. You use the INPUT statement to read data into a data set with an informat. You can learn about•permanently assigning a format to a variable in Creating and Managing Variables •the FORMAT statement in Creating List Reports •the FORMAT procedure in Creating and Applying User-Defined Formats •the INPUT function in Transforming Data with SAS Functions • the INPUT statement in Reading Raw Data in Fixed Fields .25.The following report is generated:Styleof homesn A skingPriceCONDO 4 $99,313RANCH 4 $68,575SPLIT3 $77,983 TWOSTORY4 $83,825Which of the following steps created the report?a. proc freq data=sasuser.houses;tables style price /nocum;format price dollar10.;label style="Style of homes"price="Asking price";run;b.proc print data=sasuser.houses; class style;var price;table style,n price*mean*f=dollar10.;label style="Style of homes"price="Asking price";run;c.proc means data=sasuser.houses n mean; class style;var price;format price dollar10.;label style="Style of homes"price="Asking price";run;d.proc report data=sasuser.houses nowd headline; column style n price;define style / group "Style of homes";define price / mean format=dollar8."Asking price";run;Correct answer: dThe FREQ procedure cannot create the average asking price. The CLASS statement and the VAR statement are not valid for use with the PRINT procedure. The MEANS procedure output would have both the N statistic and the N Obs statistic since a CLASS statement is used. The REPORT procedure produced the report.You can learn about•the FREQ procedure in Producing Descriptive Statistics•the PRINT procedure in Creating List Reports•the MEANS procedure in Producing Descriptive Statistics•the REPORT procedure in Creating Enhanced List and Summary Reports. 26.A SAS report currently flows over two pages because it is too long to fit within the specified display dimension. Which one of the following actions would change the display dimension so that the report fits on one page?a.Increase the value of the LINENO option.b.Decrease the value of the PAGENO option.c.Decrease the value of the LINESIZE option.d.Increase the value of the PAGESIZE option.Correct answer: dThe PAGESIZE= SAS system option controls the number of lines that compose a page of SAS procedure output. By increasing the number of lines available per page, the report might fit on one page.You can learn about the PAGESIZE= option in Referencing Files and Setting Options.27.Which one of the following SAS REPORT procedure options controls how column headings are displayed over multiple lines?a. SPACE=b. SPLIT=c. LABEL=d. BREAK=Correct answer: bThe SPLIT= option specifies how to split column headings. The SPACE=, LABEL= and BREAK= options are not valid options in PROC REPORT.You can learn about the SPLIT= option for the REPORT procedure in Creating Enhanced List and Summary Reports.SAS中文论坛网站28.The following SAS program is submitted:ods html file='newfile.html';proc print data=sasuser.houses;run;proc means data=sasuser.houses;run;proc freq data=sasuser.shoes;run;ods html close;proc print data=sasuser.shoes;run;How many HTML files are created?a. 1b. 2c. 3d. 4Correct answer: aBy default, one HTML file is created for each FILE= option or BODY= option in the ODS HTML statement. The ODS HTML CLOSE statement closes the open HTML file and ends the output capture. The Newfile.html file contains the output from the PRINT, MEANS, and FREQ procedures.You can learn about the ODS HTML statement in Producing HTML Output.29.A frequency report of the variable Jobcode in the Work.Actors data set is listed below.Jobcode Frequency Percent CumulativeFrequency CumulativePercentActor I233.33233.33Actor II233.33466.67Actor III233.336100.00Frequency Missing = 1The following SAS program is submitted:data work.joblevels;set work.actors;if jobcode in ('Actor I', 'Actor II') thenjoblevel='Beginner';if jobcode='Actor III' thenjoblevel='Advanced';else joblevel='Unknown';run;Which of the following represents the possible values for the variable joblevel in the Work.Joblevels data set?a.Advanced and Unknown onlySAS中文论坛网站SAS 中文论坛网站b. Beginner and Advanced onlyc. Beginner , Advanced , and Unknownd. ' ' (missing character value)Correct answer: aThe DATA step will continue to process those observations that satisfy the condition in the first IF statement Although Joblevel might be set to Beginner for one or more observations, the condition on the second IF statement will evaluate as false, and the ELSE statement will execute and overwrite the value of Joblevel as Unknown . You can learn about•the IF statement in Creating SAS Data Sets from Raw Data • the ELSE statement in Creating and Managing Variables .30.The descriptor and data portions of the Work.Salaries data set are shown below. Variable Type Len Posname Char 8 0salary Char 8 16status Char 8 8name status salary Liz S 15,600 Herman S 26,700 Marty S 35,000The following SAS program is submitted:proc print data=work.salaries;where salary<20000;run;What is displayed in the SAS log after the program is executed?a. A NOTE indicating that 1 observation is read.b. A NOTE indicating that 0 observations were read.c. A WARNING indicating that character values have been converted to numeric values.d. An ERROR indicating that the WHERE clause operator requires compatible variables. Correct answer: dSalary is defined as a character variable. Therefore, the value in the WHERE statement must be the character value 20,000 enclosed in quotation marks.You can learn about the WHERE statement in Creating List Reports .31.Which of the following statements is true when SAS encounters a syntax error in a DATA step?SAS 中文论坛网站a. The SAS log contains an explanation of the error.b. The DATA step continues to execute and the resulting data set is complete.c. The DATA step stops executing at the point of the error and the resulting data set contains observations up to that point.d. A note appears in the SAS log indicating that the incorrect statement was saved to a SAS data set for further examination.Correct answer: aSAS scans the DATA step for syntax errors during the compilation phase. If there are syntax errors, those errors get written to the log. Most syntax errors prevent further processing of the DATA step.You can learn about how SAS handles syntax errors in the DATA step in Understanding DATA Step Processing .32.Which TITLE statement would display JANE'S DOG as the text of the title?a. title "JANE"S DOG";b. title 'JANE"S DOG';c. title "JANE'S DOG";d. title 'JANE' ' 'S DOG';Correct answer: cThe title in a TITLE statement must be enclosed in a pair of matched quotation marks. Unbalanced quotation marks can cause problems for SAS. To hide an unmatched single quotation mark, surround the title text with matched double quotation marks.You can learn about•the TITLE statement in Creating List Reports • unbalanced quotation marks in Editing and Debugging SAS Programs .33.The following SAS program is submitted:data test;input animal1 $ animal2 $mlgrams1 mlgrams2;cards;hummingbird ostrich 54000.39 90800000.87;run;Which one of the following represents the values of each variable in the output data set?a. animal1 animal2 mlgrams1 mlgrams2 hummingb ostrich 54000.39 90800000b. animal1 animal2 mlgrams1 mlgrams2 hummingb ostrich 54000.39 90800000.87c. animal1 animal2 mlgrams1 mlgrams2 hummingbird ostrich 54000.39 90800000d. animal1 animal2 mlgrams1 mlgrams2。
四川省21次机试试题及参考答案
21-1套参考答案：一、程序调试题（文件名test1-1.c）（40分）软盘上有一个名为test1-1.c的C程序文件，其功能是将字符串中的小写字母都改成对应的大写字母，其他字母不变。
请更改程序中的错误。
注意:不得增行或删行，也不得更改程序的结构。
#include <stdio.h>#include <string.h>char *fun( char str) /* 改为*str*/{ int i ;for(i=0 ; str; i++) /* 改为str[i]*/if(('a'<=str[i])||(str[i]<='z')) /* 改为&& */str[i]+=32; /* 改为-= */return *str; /* 改为str */}main(){char str[81];printf("\n Please enter a string:");gets(str[81]); /* 改为str */printf("\n The result string is:\n%s" , fun(str));}评分标准：每改对1处得5分，结果正确得10分。
二、编写程序（程序文件取名为test1-2.c）（60分）在磁盘上的test1-2.txt文件中放有10个不小于2的正整数，用函数调用方式编写程序。
要求实现:1. 在被调函数prime中，判断和统计10个整数中的素数以及个数。
2. 在主函数中将全部素数追加到磁盘文件test1-2.txt的尾部，同时输出到屏幕上。
评分标准：1．被调函数编写正确20分2．文件打开、数据读入正确和定位正确10分3．函数调用正确5分4．屏幕输出和文件输出正确20分5．程序结构合理5分参考程序：# include <stdio.h># include <math.h>int prime(int a[],int n){ int i,j,k=0,flag=0;for(i=0;i<n;i++){ for(j=2;j<a[i];j++)if(a[i]%j==0){ flag=0;break;else flag=1;if(flag)a[k++]=a[i];}return k;}main(){ int n,i,a[10];FILE *fp;fp=fopen("test1-2.txt","r+");for(n=0;n<10;n++)fscanf(fp,"%d",&a[n]);n=prime(a,n);fseek(fp,0,2);for(i=0;i<n;i++){ printf("%5d",a[i]);fprintf(fp,"%5d",a[i]);}fclose(fp);}21-2套参考答案：一、程序调试题（文件名为test2-1.c）（40分）N个有序数数列已放在一维数组中。