sas base 70題新題.doc

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 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: D73. The 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: B74. The following SAS program is submitted:data work.test;set work.staff (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 MONTHLY3C. DIFSALES1, DIFSALES2 and DIFSALES3D. DIFF_SALES1, DIFF_SALES2 and DIFF_SALES3Answer: C75. The following SAS DATA step is submitted:data work.accountting;set work.department;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 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 statements 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;column 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. PassC. 50.5D. . (missing numeric value)Answer: C78. The following SAS program is submitted:proc means data= sasuser .shoes;where product 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:libnamesasdata 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. Senior 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 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 work.january;set work.allmonths (keep=product month num_sold cost);if month=janthen output work.january;sales=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 SAS program is submitted:data work.totalsales;set work.monthlysales(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 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 creates theWORK.TOTALSALES data set with 60 observations.Answer: B83. The following SAS program is submitted:data work.totalsales (keep=monthsales12);set work.monthlysales (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 five 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 executes 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 _ERROR_ 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:85. data work.onelength var1 var2 12 (都是character類型的）set work.two (e.g. var1 length 5)format var1 20問最后one里var1 length是多少，應該是12， 由最開始的length決定86. 一個排序的問題by var1 desceding var2 var3問三個vars是怎么排序的應該是var1 var3 ascending，var2 descending87. 下面哪幾種是有效的data set nameDATAWORK.one_testtest_2Test好像還有幾個不記得了但是最后答案是一共4個有效88. 一個dataset，列出了所有的variab