SAS Adv 模拟 50.docVIP

1. Given the following SAS data set One: One Job Level Salary Bonus acc 2 300 30 SEC 1 100 10 SEC 2 200 20 MGR 3 700 70 ACC 1 300 30 ACC 1 100 10 MGR 3 400 40 The following SAS program is submitted: proc sql; select * from one where job in (ACC,MGR); quit; How many rows are displayed in the resulting report? a. 2 b. 4 c. 5 d. 7 Correct answer: b There are four rows displayed in the resulting report. The asterisk in the SELECT statement specifies that all columns are returned. The WHERE clause specifies that rows should be returned only if the Job column has the value ACC or MGR. The value for Job in the first row is acc. Because the WHERE clause is case sensitive, the first row is not returned. 2. Given the following SAS data set One: One Salary Bonus 200 20 205 20.5 310 31 523 52.3 The following SAS program is submitted: proc sql; select insert SQL procedure clause here from one; quit; The following output is desired: Salary $200 $205 $310 $523 Which of the following SQL procedure clauses correctly completes the program and generates the desired output? a. salary f=dollar9. b. salary format=dollar9. c. format=dollar9. salary d. salary * format=dollar9. Correct answer: b Because only the Salary column appears in the output, the SELECT clause should reference only Salary. To apply a format to a column, you use the FORMAT= option. The FORMAT= option should appear after the column name. The option cannot be abbreviated. 3. Given the following SAS data set Staff: Staff Name Jobcode Salary Smith PLT2 50000 Jones PLT1 40000 Patel PLT3 60000 Chang FLT2 35000 The following SAS program is submitted: proc sql; select * from staff insert WHERE expression here; quit; The following output is desired: Name Jobcode Salary Smith PLT2 50000 Jones PLT1 40000 Patel PLT3 60000 Which of the following WHERE expressio