We provide real A00-211 exam questions and answers braindumps in two formats. Download PDF & Practice Tests. Pass SAS Institute A00-211 Exam quickly & easily. The A00-211 PDF type is available for reading and printing. You can print more and practice many times. With the help of our SAS Institute A00-211 dumps pdf and vce product and material, you can easily pass the A00-211 exam.
Q25. The following SAS program is submitted:
data work.test;
array agents{4} $ 12 sales1 - sales4;
run;
Which one of the following represents the variables that are contained in the output data set?
A. SALES1, SALES2, SALES3, SALES4
B. AGENTS1, AGENTS2, AGENTS3, AGENTS4
C. None, the DATA step fails because the ARRAY statement can reference only numeric data.
D. None, the DATA step fails because the ARRAY statement can reference only pre-existing variables.
Answer: A
Q26. The contents of the raw data file NAMENUM are listed below:
--------10-------20-------30
Joe xx
The following SAS program is submitted:
data test;
infile 'namenum'
input name $ number;
run;
Which one of the following is the value of the NUMBER variable?
A. xx
B. Joe
C. . (missing numeric value)
D. The value can not be determined as the program fails to execute due to errors.
Answer: C
Q27. The following SAS program is submitted:
data work.sets;
do until (prod gt 6);
prod + 1;
end;
run;
What is the value of the variable PROD in the output data set?
A. 6
B. 7
C. 8
D. (missing numeric)
Answer: B
Q28. The value 110700 is stored in a numeric variable named SALARY.
Which FORMAT statement displays the value as $110,700.00 in a report?
A. format salary comma11.2;
B. format salary dollar8.2;
C. format salary dollar11.2;
D. format salary comma8.2 dollar8.2;
Answer: C
Q29. The following SAS program is submitted:
libname company 'SAS-data-library' proc sort data = company.payroll;
by EmployeeIDNumber;
run;
Write access has been granted to the COMPANY library.
Which one of the following represents how the observations are sorted?
A. COMPANY.PAYROLL is recreated in sorted order by EmployeeIDNumber.
B. COMPANY.PAYROLL is stored in original order, and a new data set PAYROLL is created in sorted order by EmployeeIDNumber.
C. COMPANY.PAYROLL is stored in original order, and a new data set COMPANY.PAYROLLSORTED is created in sorted order by EmployeeIDNumber.
D. COMPANY.PAYROLL is recreated in sorted order by EmployeeIDNumber, and a new data set PAYROLL is created in sorted order by EmployeeIDNumber
Answer: A
Q30. The SAS data set PETS is sorted by the variables TYPE and BREED.
The following SAS program is submitted:
proc print data = pets;
var type breed;
sum number;
run;
What is the result?
A. The SUM statement produces only a grand total of NUMBER.
B. The SUM statement produces only subtotals of NUMBER for each value of TYPE.
C. The SUM statement produces both a grand total of NUMBER and subtotals of NUMBER for each value of TYPE.
D. Nothing is produced by the SUM statement; the program fails to execute.
Answer: A
Q31. The following SAS program is submitted, creating the SAS data set ONE:
data one;
infile ‘file specification’;
input num chars$;
run;
ONE
NUMCHAR
123 323 177
The following SAS program is submitted:
proc print data = one; where char = 23; run;
What is output?
A. NUM CHAR 1 77 2
B. NUM CHAR 1 23 3 23
C. NUM CHAR 1 23 3 23 1 77
D. No output is generated.
Answer: D
Q32. The following SAS program is submitted:
data one;
addressl = ‘214 London Way’;
run;
data one;
set one;
address = tranwrd(address1, ‘Way’, ‘Drive’); run;
What are the length and value of the variable ADDRESS?
A. Length is 14; value is ‘214 London Dri’.
B. Length is 14; value is ‘214 London Way’.
C. Length is 16; value is ‘214 London Drive’.
D. Length is 200; value is ‘214 London Drive’.
Answer: D