Our pass rate is high to 98.9% and the similarity percentage between our A00-211 study guide and real exam is 90% based on our seven-year educating experience. Do you want achievements in the SAS Institute A00-211 exam in just one try? I am currently studying for the SAS Institute A00-211 exam. Latest SAS Institute A00-211 Test exam practice questions and answers, Try SAS Institute A00-211 Brain Dumps First.
Q81. A raw data file is listed below:
--------10-------20-------30
John McCloskey 35 71
June Rosesette 10 43
Tineke Jones 9 37
The following SAS program is submitted using the raw data file as input:
data work.homework;
infile 'file-specification'
input name $ age height;
if age LE 10;
run;
How many observations will the WORK.HOMEWORK data set contain?
A. 0
B. 2
C. 3
D. No data set is created as the program fails to execute due to errors.
Answer: C
Q82. The following SAS program is submitted:
If the value for the variable Jobcode is: PILOT2, what is the value of the variable Description?
A. ' ' (missing character value)
B. Unknown
C. Senior Pilot
D. SENIOR PILOT
Answer: B
Q83. Which statement is true concerning the SAS automatic variable _ERROR_?
A. It cannot be used in an if/then condition.
B. It cannot be used in an assignment statement.
C. It can be put into a keep statement or keep= option.
D. It is automatically dropped.
Answer: D
Q84. A raw data file is listed below:
--------10-------20-------30 squash 1.10 apples 2.25 juice 1.69
The following SAS program is submitted using the raw data file above:
data groceries;
infile 'file-specification'
input item $ cost;
run;
Which one of the following completes the program and produces a grand total for all COST values?
A. grandtot = sum cost;
B. grandtot = sum(grandtot,cost);
C. retain grandtot 0;
grandtot = sum(grandtot,cost);
D. grandtot = sum(grandtot,cost);
output grandtot
Answer: C
Q85. The following SAS program is submitted:
libname temp 'SAS-data-library'
data work.new;
set temp.jobs;
format newdate mmddyy10.;
qdate = qtr(newdate);
ddate = weekday(newdate);
run;
proc print data = work.new;
run;
The variable NEWDATE contains the SAS date value for April 15, 2000.
What output is produced if April 15, 2000 falls on a Saturday?
A. Obs newdate qdate ddate 1 APR152000 2 6
B. Obs newdate qdate ddate 1 04/15/2000 2 6
C. Obs newdate qdate ddate 1 APR152000 2 7
D. Obs newdate qdate ddate 1 04/15/2000 2 7
Answer: D
Q86. The following SAS program is submitted:
How many raw data records are read during each iteration of the DATA step?
A. 1
B. 2
C. 3
D. 4
Answer: B
Q87. The following SAS program is submitted:
<insert ODS statement here>
proc means data = sasuser.shoes;
where product in (‘Sandal’ , ‘Slipper’ , ‘Boot’);
run;
<insert ODS statement here>
Which ODS statements complete the program and send the report to an HTML file?
A. ods html = ‘sales.html’; ods html close;
B. ods file = ‘sales.html’; ods file close;
C. ods file html = ‘sales.html’; ods file close;
D. ods html file = ‘sales.html’; ods html close;
Answer: D
Q88. Given the SAS data set WORKAWARDS:
WORK.AWARDS FNAMEPOINTSMONTH Amy24
Amy17
Gerard33
Wang33
Wang112
Wang18
The following SAS program is submitted:
proc sort data = work.awards;
by descending fname points;
run;
How are the observations sorted?
A. ENAME POINTS MONTH Wang33 Wang112 Wang18 Gerard33 Amy24 Amy17
B. ENAME POINTS MONTH Amy24 Amy17 Gerard33 Wang33 Wang18 Wang112
C. ENAME POINTS MONTH Wang33 Wang18 Wang112 Gerard33 Amy24 Amy17
D. ENAME POINTS MONTH Wang112 Wang18 Wang33 Gerard33 Amy17 Amy24
Answer: D