ImageVerifierCode 换一换
格式:DOCX , 页数:34 ,大小:50.48KB ,
资源ID:769011      下载积分:5 文钱
快捷下载
登录下载
邮箱/手机:
温馨提示:
快捷下载时,用户名和密码都是您填写的邮箱或者手机号,方便查询和重复下载(系统自动生成)。 如填写123,账号就是123,密码也是123。
特别说明:
请自助下载,系统不会自动发送文件的哦; 如果您已付费,想二次下载,请登录后访问:我的下载记录
支付方式: 支付宝    微信支付   
验证码:   换一换

加入VIP,省得不是一点点
 

温馨提示:由于个人手机设置不同,如果发现不能下载,请复制以下地址【https://www.wenke99.com/d-769011.html】到电脑端继续下载(重复下载不扣费)。

已注册用户请登录:
账号:
密码:
验证码:   换一换
  忘记密码?
三方登录: QQ登录   微博登录 

下载须知

1: 本站所有资源如无特殊说明,都需要本地电脑安装OFFICE2007和PDF阅读器。
2: 试题试卷类文档,如果标题没有明确说明有答案则都视为没有答案,请知晓。
3: 文件的所有权益归上传用户所有。
4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
5. 本站仅提供交流平台,并不能对任何下载内容负责。
6. 下载文件中如有侵权或不适当内容,请与我们联系,我们立即纠正。
7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。

版权提示 | 免责声明

本文(SASbase70题无答案版,适合练习.docx)为本站会员(h****)主动上传,文客久久仅提供信息存储空间,仅对用户上传内容的表现方式做保护处理,对上载内容本身不做任何修改或编辑。 若此文所含内容侵犯了您的版权或隐私,请立即通知文客久久(发送邮件至hr@wenke99.com或直接QQ联系客服),我们立即给予删除!

SASbase70题无答案版,适合练习.docx

1、1SAS Base 认证考试70 题Q 11. The following SAS program is submitted:data WORK.TOTAL;set WORK.SALARY;by Department Gender;if First. then Payroll=0;Payroll+Wagerate;if Last.;run;The SAS data set WORK.SALARY is currently ordered by Gender within Department.Which inserted code will accumulate subtotals for e

2、ach Gender within Department?A. GenderB. DepartmentC. Gender DepartmentD. Department GenderQ 2Given the following raw data records in TEXTFILE.TXT:-|-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

3、desired:Obs Name Month Status Week1 Week2 Week3 Week4 Week51 John FEB Final $13 $25 $14 $27 .22 John MAR Current $26 $17 $29 $11 $233 Tina FEB Final $15 $18 $12 $13 .4 Tina MAR Current $29 $14 $19 $27 $20Which SAS program correctly produces the desired output?A. data WORK.NUMBERS;length Name $ 4 Mon

4、th $ 3 Status $ 7;infile TEXTFILE.TXT 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

5、Status $ 7;infile TEXTFILE.TXT 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

6、$ 3 Status $ 7;3infile TEXTFILE.TXT 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

7、 Status $ 7;infile TEXTFILE.TXT 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;Q 3The following SAS program is submitted:data WORK.

8、DATE_INFO;Day=“01“ ;Yr=1960 ;X=mdy(Day,01,Yr) ;run;4What 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.Q 4The Excel workbook REGIONS.XLS c

9、ontains 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.NORTHe;run;D. proc print d

10、ata=MYXLS.NORTH$n;run;Q 5Which statement specifies that records 1 through 10 are to be read from the raw data file customer.txt?A. infile customer.txt 1-10;B. input customer.txt stop10;C. infile customer.txt obs=10;5D. input customer.txt stop=10; Q 6After a SAS program is submitted, the following is

11、 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: !,!, What changes should be made to the KEEP

12、statement to correct the errors in the LOG?A. keep=(Product Sales);B. keep Product, Sales;C. keep=Product, Sales;D. keep Product Sales;Q 7Which of the following choices is an unacceptable ODSdestination for producing output that can be viewed in Microsoft Excel?A. MSOFFICE2K6B. EXCELXPC. CSVALLD. WI

13、NXPQ 8The 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+(MonthlyWag

14、eRate*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 WOR

15、K.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.Q 9data course;input exam;datalines;50.17;run;proc format;value score 1 50 = Fail51 100 = Pass;run;proc report data =course nowd;column exam;define exam / display

16、format=score.;run;What is the value for exam?A. FailB. PassC. 50.1D. No outputQ 10The 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

17、.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

18、 data set is set to zero. No messages are written to the SAS log.8Q 11Given the existing SAS program:proc format;value agegrplow-12 =Pre-Teen13-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

19、 addedto generate the following results:Analysis Variable : HeightNSex Age Obs Minimum Maximum Mean-F Pre-Teen 3 51.3 59.8 55.8Teen 6 56.5 66.5 63.0M Pre-Teen 4 57.3 64.8 59.7Teen 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 dat

20、a=SASHELP.CLASS min max mean maxdec=1;D. output nobs min max mean maxdec=1;Q 12The Excel workbook QTR1.XLS contains thefollowing 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 j

21、an feb mar qtr1.xls;D. libname mydata qtr1.xls WORK.heets=(jan,feb,mar);Q 13The following SAS program is submitted:data WORK.TEST;set WORK.MEASLES(keep=Janpt Febpt Marpt);array Diff3 Difcount1-Difcount3;9array Patients3 Janpt Febpt Marpt;run;What new variables are created?A. Difcount1, Difcount2 and

22、 Difcount3B. Diff1, Diff2 and Diff3C. Janpt, Febpt, and MarptD. Patients1, Patients2 and Patients3Q 14Which 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

23、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 descripti

24、on=Central;run;Q 15Which 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.Q 16The following SAS program is

25、 submitted:data WORK.DATE_INFO;X=04jul2005d;DayOfMonth=day(x);MonthOfYear=month(x);Year=year(x);run;10What 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.

26、MonthOfYear is character.D. DayOfMonth, Year, and MonthOfYear are date values.Q 17Given the following data step:data WORK.GEO;infile datalines;input City $20.;if City=Tulsa thenState=OK;Region=Central;if City=Los Angeles thenState=CA;Region=Western;datalines;TulsaLos AngelesBangor;run;After data ste

27、p 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 WesternBangorQ 18

Copyright © 2018-2021 Wenke99.com All rights reserved

工信部备案号浙ICP备20026746号-2  

公安局备案号:浙公网安备33038302330469号

本站为C2C交文档易平台,即用户上传的文档直接卖给下载用户,本站只是网络服务中间平台,所有原创文档下载所得归上传人所有,若您发现上传作品侵犯了您的权利,请立刻联系网站客服并提供证据,平台将在3个工作日内予以改正。