sas base 70题新题.doc

《sas base 70题新题.doc》由会员分享，可在线阅读，更多相关《sas base 70题新题.doc（12页珍藏版）》请在得力文库 - 分享文档赚钱的网站上搜索。

1、-作者xxxx-日期xxxxsas base 70题新题【精品文档】71.Which one of the following SAS REPORT procedure options controls how columnheadings are displayed over multiple lines?a. SPACE=b. SPLIT=c. LABEL=d. BREAK=Answer: B72. Which one of the following SAS DATA steps saves the temporary data set namedMYDATA as a permanen

2、t data set?A. libname sasdata SAS-data-library;data ;copy mydata;run;B. libname sasdata SAS-data-library;data ;keep mydata;run;C. libname sasdata SAS-data-library;data ;save mydata;run;D. libname sasdata SAS-data-library;data ;set mydata;run;Answer: D73. The SAS data set named COMPANY.PRICES is list

3、ed below:prodidprice 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 (keep =

4、 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: B74. The following SAS program is submitt

5、ed:data ;set (keep = jansales febsales marsales);array diff_sales3 difsales1 - difsales3;A00-201A - The Power of Knowingarray monthly3 jansales febsales marsales;run;Which one of the following represents the new variables that are created?A. JANSALES, FEBSALES and MARSALESB. MONTHLY1, MONTHLY2 and M

6、ONTHLY3C. DIFSALES1, DIFSALES2 and DIFSALES3D. DIFF_SALES1, DIFF_SALES2 and DIFF_SALES3Answer: C75. The following SAS DATA step is submitted:data ;set ;length jobcode$ 12;run;The WORK.DEPARTMENT SAS data set contains a character variable namedJOBCODE with a length of 5.Which one of the following is

7、the length of the variable JOBCODE in the outputdata set?A. 5B. 8C. 12D. The length can not be determined as the program fails to execute due to errors.Answer: A76. The following SAS program is submitted:proc freq data=sales;run:Exhibit: output from the FREQ procedure.Which one of the following stat

8、ements completes the program and produces theoutput?A. tables region product;B. tables region* product;C. tables product region;D. tables product region*;Answer: B77. The following SAS program is submitted:proc format;value score 1 - 50 = Fail51-100=Pass;run;proc report data=work .courses nowd;colum

9、n exam;define exam / display format=score.;run;The variable EXAM has a value of 50.5.How will the EXAM variable value be displayed in the REPORT procedure output?A. FailB. PassD. . (missing numeric value)Answer: C78. The following SAS program is submitted:proc means data= sasuser .shoes;where produc

10、t in (sandal , Slipper , Boot);run;Which one of the following ODS statements completes the program and sends thereport to an HTML file?A. ods html = sales .html;B. ods file=sales .html;C. ods file html=sales .html;D. ods html file=sales. html;Answer: D79. The following SAS program is submitted:libna

11、mesasdata SAS-data-library;data set;set sasdata .chemists;if jobcode = chem3then description = Senior Chemist;else description = Unknown;run;A value for the variable JOBCODE is listed below:JOBCODECHEM3Which one of the following values does the variable DESCRIPTION contain?A. chem3B. UnknownC. Senio

12、r ChemistD. (missing character value)Answer: B80. The contents of the raw data file EMPLOYEE are listed below:-|-10-|-20-|-30Ruth 39 11Jose 32 22Sue 30 33John 40 44The following SAS program is submitted:data test;in file employee;input employee_ name $ 1-4;if employee_ name = Ruthh then input idnum

13、10-11;else input age 7-8;runWhich one of the following values does the variable IDNUM contain when the nameof the employee is Ruth?A. 11B. 22C. 32D. . (missing numeric value)Answer: B81. The following SAS program is submitted:data ;set (keep=product month num_sold cost);if month=janthen output ;sale

14、s=cost*num_sold;keep=product sales;run;Which variables does the WORK.JANUARY data set contain?A. PRODUCT and SALES onlyB. PRODUCT, MONTH, NUM_SOLD and COST onlyC. PRODUCT, SALES, MONTH, NUM_SOLD and COST onlyD. An incomplete output data set is created due to syntax errors.Answer: D82. The following

15、SAS program is submitted:data ;set (keep=year product sales);retrain montnsales 12;array montnsales 12;doi=1 to 12;monthsalesi=sales;end;ent+1;monthsalesent=sales;run;The data set named WORK.MONTHLYSALES has one observation per month foreach of five years for a total of 60 observations.Which one of

16、the following is the result of the above program?A. The program fails execution due to data errors.B. The program fails execution due to syntax errors.C. The program runs with warnings and creates the WORK.TOTALSALES data set with 60 observations.D. The program runs without errors or warnings and cr

17、eates theWORK.TOTALSALES data set with 60 observations.Answer: B83. The following SAS program is submitted:data (keep=monthsales12);set (keep=year product sales);srray monthsales 12;doi=1 to 12;monthsalesi=sales;end;run;The data set named WORK.MONTHLYSALES has one observation per month foreach of fi

18、ve years for a total of 60 observations.Which one of the following is the result of the above program?A. The program fails execution due to data errors.B. The program fails execution due to syntax errors.C. The program executes with warnings and creates the WORK.TOTALSALES data set.D. The program ex

19、ecutes without errors or warnings and creates theWORK.TOTALSALES data set.Answer: B84. Which one of the following statements is true regarding the SAS automatic_ERROR_ variable?A. The _ERROR_ variable contains the values ON or OFF.B. The _ERROR_ variable contains the values TRUE or FALSE.C. The _ERR

20、OR_ variable is automatically stored in the resulting SAS data set.D. The _ERROR_ variable can be used in expressions or calculations in the DATA step.Answer: DNew Questions:length var1 var2 12 (都是character类型的）set work.two (e.g. var1 length 5)format var1 20问最后one里var1 length是多少，应该是12， 由最开始的length决定8

21、6. 一个排序的问题by var1 desceding var2 var3问三个vars是怎么排序的应该是var1 var3 ascending，var2 descending87. 下面哪几种是有效的data set nameDATA_testtest_2Test好像还有几个不记得了但是最后答案是一共4个有效88. 一个dataset，列出了所有的variables的类型Name TypeN1 numN2 numN3 charN4 char问在程序中array* _numeric_ 建立了几个variable答案是0， 因为这条命令只是refer了dataset里所有num类型的variab

22、les，并没有建立新的变量89.如果今天是Jan 2， 1960问today（）答案应该是190. obs number1 252 103 .4 205 30问total+number的output是神马obs number total1 25 252 10 353 . 354 20 555 30 8591. yearcutoff=1970理解yearcutoff的意义即可。题目中60必须是1970之后，我选2060年92. 这题之前看到其他帖子介绍了，是个新提。于是背答案了。四个选项中有两个是 input()，有两个是put()，显然input( )是错的，于是在 put( ) 里面二选一：

23、A) put(date, date9., worddate20.)B) put(date, worddate20.)B为正确答案。93. 对于libref的命名规则也考了，问你以下4个选项有几个是符合规则的。libref is 1 to 8 characters long, begins with a letter or underscore, and contains only letters, numbers, or underscores.94. ods html file=F:reg1.html; proc one. proc two. run; ods pdf close; 【精品文档】