You will have instantaneous access to be able to our SAS Institute A00-211 exam merchandise after confirming the actual payment at Examcollection. The SAS Institute A00-211 practice questions with verified answers are compiled and also revised by our subject matter specialists. Our experts possess make wonderful contributions to our SAS Institute SAS Institute exam products. We have many consumers who have obtained the actual SAS Institute A00-211 certification. We are proud of the large passing ratio since all of us start.
2021 Oct A00-211 braindumps
Q101. The following SAS program is submitted:
data combine; prefix=’505’; middle=’6465 ‘; end=’09090’; <insert statement here>; run;
Which statement successfully completes the program so that TOTAL has a value of 505-6465-09090?
A. total = cat(’-’, prefix, middle, end);
B. total = catx(’-’, prefix, middle, end);
C. total = prefix !!’-’!! middle ‘‘!!’-’!! end;
D. total = prefix!!’-’!! left(middle)!!’-’!! end;
Answer: B
Q102. The following SAS program is submitted and reads 100 records from a raw data file:
data work.total;
infile 'file-specification' end = eof;
input name $ salary;
totsal + salary;
run;
Which one of the following IF statements writes the last observation to the output data set?
A. if end = 0;
B. if eof = 0;
C. if end = 1;
D. if eof = 1;
Answer: D
Q103. Given the following code:
proc print data=SASHELP.CLASS(firstobs=5 obs=15);
where Sex='M'
run;
How many observations will be displayed?
A. 11
B. 15
C. 10 or fewer
D. 11 or fewer
Answer: D
Q104. The following SAS program is submitted:
data test;
set sasuser.employees;
if 2 le years_service le 10 then
amount = 1000;
else amount = 0;
amount_per_year = years_service / amount
run;
What is the value of the variable AMOUNT_PER_YEAR if an employee has been with the company for one year?
A. 0
B. 0.001
C. 1
D. (missing numeric value)
Answer: D
Q105. The following SAS SORT procedure step generates an output data set:
proc sort data = sasuser.houses out = report;
by style;
run;
In which library is the output data set stored?
A. WORK
B. REPORT.
C. HOUSES
D. SASUSER
Answer: A
Abreast of the times A00-211 exam guide:
Q106. The data set WORK.REALESTATE has the variable LocalFee with a format of 9. and a variable CountryFee with a format of 7.;
The following SAS program is submitted: What are the formats of the variables LOCALFEE and COUNTRYFEE in the output dataset?
A. LocalFee has format of 9. and CountryFee has a format of 7.
B. LocalFee has format of 9. and CountryFee has a format of percent7.2
C. Both LocalFee and CountryFee have a format of percent7.2
D. The data step fails execution; there is no format for LocalFee.
Answer: C
Q107. The following SAS program is submitted:
data test;
set chemists;
itjobcode = ‘Chem2’
then description = ‘Senior Chemist’;
else description = ‘Unknown’;
run;
The value for the variable JOBCODE is:
JOBCODE
chem2
What is the value of the variable DESCRIPTION?
A. chem2
B. Unknown
C. Senior Chemist
D. ‘ ‘ (missing character value)
Answer: B
Q108. The contents of the raw data file AMOUNT are listed below:
--------10-------20-------30
$1,234
The following SAS program is submitted:
data test;
infile 'amount'
input @1 salary 6.;
if _error_ then description = 'Problems'
else description = 'No Problems'
run;
Which one of the following is the value of the DESCRIPTION variable?
A. Problems
B. No Problems
C. ' ' (missing character value)
D. The value can not be determined as the program fails to execute due to errors.
Answer: A
Q109. The contents of the raw data file PRODUCT are listed below:
--------10-------20-------30
24613 $25.31
The following SAS program is submitted:
data inventory;
infile 'product'
input idnum 5. @10 price;
run;
Which one of the following is the value of the PRICE variable?
A. 25.31
B. $25.31
C. . (missing numeric value)
D. No value is stored as the program fails to execute due to errors.
Answer: A
Q110. The following SAS program is submitted:
data work.retail; cost = '20000' total = .10 * cost; run;
Which one of the following is the value of the variable TOTAL in the output data set?
A. 2000
B. '2000'
C. . (missing numeric value)
D. ' ' (missing character value)
Answer: A