Cause all that matters here is passing the SAS Institute A00-211 exam. Cause all that you need is a high score of A00-211 SAS Base Programming for SAS ® 9 exam. The only one thing you need to do is downloading Ucertify A00-211 exam study guides now. We will not let you down with our money-back guarantee.
Q65. The following SAS program is submitted:
data work.total;
set work.salary(keep = department wagerate);
by department;
if first.department
then payroll = 0;
payroll + wagerate;
if last.department;
run;
The SAS data set named WORKSALARY contains 10 observations for each department, and is currently ordered by DEPARTMENT.
Which statement is true?
A. The BY statement in the DATA step causes a syntax error.
B. The statement payroll + wagerate; in the DATA step causes a syntax error.
C. The values of the variable PAYROLL represent the total for each department in the WORK.SALARY data set.
D. The values of the variable PAYROLL represent a total for all values of WAGERATE in the WORKSALARY data set.
Answer: C
Q66. Which one of the following SAS system options displays the time on a report?
A. TIME
B. DATE
C. TODAY
D. DATETIME
Answer: B
Q67. Consider the data step:
Which of the following assignment statements for variable group are functionally equivalent to the original statement used in the above data step?
A. if Age not in(15,16) then Group=1; else Group=2;
B. if (Age NE 16) or (Age NE 15) then Group=1; else Group=2;
C. where Age not between 15 and 16 then Group=1; else Group=2;
D. both A or C will work.
Answer: A
Q68. The Excel workbook QTR1.XLS contains the following three worksheets:
JAN FEB
MAR
Which statement correctly assigns a library reference to the Excel workbook?
A. libname qtrdata 'qtr1.xls'
B. libname 'qtr1.xls' sheets=3;
C. libname jan feb mar 'qtr1.xls'
D. libname mydata 'qtr1.xls' WORK.heets=(jan,feb,mar);
Answer: A
Q69. The following SAS program is submitted:
libname temp ‘SAS data library’;
data temp.sales;
merge temp sales
work.receipt;
by names;
run;
The input data files are sorted by the NAMES variable:
What is the result?
A. The program executes successfully and a temporary SAS data set is created.
B. The program executes successfully and a permanent SAS data set is created.
C. The program fails execution because the same SAS data set is referenced for both read and write operations.
D. The program fails execution because the SAS data sets on the MERGE statement are in two different libraries.
Answer: B
Q70. On which portion(s) of a SAS data set does the PRINT procedure report?
A. the data portion only
B. the descriptor portion only
C. the descriptor portion and the data portion
D. neither the data portion nor the descriptor portion
Answer: A
Q71. The following program is submitted:
proc contents data=_all_;
run;
Which statement best describes the output from the submitted program?
A. The output contains only a list of the SAS data sets that are contained in the WORK library.
B. The output displays only the contents of the SAS data sets that are contained in the WORK library.
C. The output displays only the variables in the SAS data sets that are contained in the WORK library.
D. The output contains a list of the SAS data sets that are contained in the WORK library and displays the contents of those data sets.
Answer: D
Q72. The following SAS program is submitted:
data WORK.ACCOUNTING;
set WORK.DEPARTMENT;
label Jobcode='Job Description'
run;
Which statement is true about the output dataset?
A. The label of the variable Jobcode is Job (only the first word).
B. The label of the variable Jobcode is Job Desc (only the first 8 characters).
C. The label of the variable Jobcode is Job Description.
D. The program fails to execute due to errors. Labels must be defined in a PROC step.
Answer: C