{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

SAS 70题.pdf - Exam Name Exam Type Exam Code SAS Base...

Info icon This preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Exam Name: SAS Base Programming for SAS (r) 9 Exam Type: SAS Exam Code: A00-211 Total Questions: 70 Question: 1 The SAS data set SASUSER.HOUSES contains a variable PRICE which has been assigned a permanent label of “Asking Price”. Which SAS program temporarily replaces the label “Asking Price” with the label “Sale Price” in the output? A - proc print data = sasuser.houses; label price = “Sale Price”; run; B - proc print data = sasuser.houses label; label price “Sale Price”; run; C - proc print data = sasuser.houses label; label price = “Sale Price”; run; D - proc print data = sasuser.houses; price = “Sale Price”; run; Answer: C Question: 2 The following GAS program is submitted: data work.empsalary; set work.people (in = inemp) work.money (in = insal); if insal and inemp; run; The SAG data set WORKPEOPLE has 5 observations, and the data set WORKMONEY has 7 observations. How many observations will the data set WORK.EMPSALARY contain? A - 0 B - 5 C - 7 D - 12 Answer: A Question: 3 The following SAS program is submitted: data work.accounting; set work.dept1 work.dept2; jobcode = ‘FA1’; length jobcode $ 8; run; A character variable named JOBCODE is contained in both the WORK.DEPT1 and WORK.DEPT2 SAS data sets. The variable JOBCODE has a length of 5 in the WORK.DEPT1 data set and a length of 7 in the WORK.DEPT2 data set. What is the length of the variable JOBCODE in the output data set? A - 3 B - 5 C - 7 D - 8 Answer: B Question: 4 Given the SAS data set SASDATA.TWO: Page 1 of 31
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Exam Name: SAS Base Programming for SAS (r) 9 Exam Type: SAS Exam Code: A00-211 Total Questions: 70 SASDATA.TWO X Y -- __ 5 2 5 4 3 6 The following SAS program is submitted: data sasuser.one one sasdata.three; set sasdata two; if x = 5 then output sasuser.one; else output sasdata three; run; What is the result? A - The data set SASUSER.ONE has 0 observations, the data set ONE has 0 observations, and the data set SASDATA.THREE has 0 observations. B - The data set SASUSER.ONE has 2 observations, the data set ONE has 0 observations, and the data set SASDATA.THREE has 1 observation. C - The data set SASUSER.ONE has 2 observations, the data set ONE has 3 observations, and the data set SASDATA.THREE has 1 observation. D - No data sets are output. The DATA step fails execution due to errors. Answer: B Question: 5 The following SAS program is submitted: footnote 1 ‘Sales Report for Last Month’; footnote2 ‘Selected Products Only’; footnote3 ‘All Regions’; footnote4 ‘All Figures in Thousands of Dollars’; proc print data = sasuser.shoes; footnote2 ‘All Products’; run; Which footnote(s) is/are displayed in the report? A - All Products B - Sales Report for Last Month All Products C - All Products All Regions All Figures in Thousands of Dollars D - Sales Report for Last Month All Products All Regions All Figures in Thousands of Dollars Answer: B Question: 6 Given the raw data record DEPT: ----|----10---|----20---|----30 Printing 750 The following SAS program is submitted: Page 2 of 31
Image of page 2