It is impossible to pass SAS Institute A00-211 exam without any help in the short term. Come to Actualtests soon and find the most advanced, correct and guaranteed SAS Institute A00-211 practice questions. You will get a surprising result by our Far out SAS Base Programming for SAS ® 9 practice guides.
Q41. The following SAS program is submitted:
<_insert_ods_code_>
proc means data=SASUSER.SHOES;
where Product in ('Sandal' , 'Slipper' , 'Boot');
run;
<_insert_ods_code_>
Which ODS statements inserted, respectively, in the two location above creates a report stored in an html file?
A. ods html open='sales.html' ods html close;
B. ods file='sales.html' / html; ods file close;
C. ods html file='sales.html' ods html close;
D. ods file html='sales.html' ods file close;
Answer: C
Q42. Given the SAS data set SASDATA.TWO:
SASDATA.TWO XY
52 31 56 The following SAS program is submitted:
data sasuser.one two sasdata.three;
set sasdata two;
if x = 5 then output sasuser.one;
else output sasdata two;
run;
What is the result?
A. data set SASUSER.ONE has 5 observations
data set SASUSER.TWO has 5 observations
data set WORK.OTHER has 3 observations
B. data set SASUSER.ONE has 2 observations
data set SASUSER.TWO has 2 observations
data set WORK.OTHER has 1 observations
C. data set SASUSER.ONE has 2 observations
data set SASUSER.TWO has 2 observations
data set WORK.OTHER has 5 observations
D. No data sets are output.
The DATA step fails execution due to syntax errors.
Answer: A
Q43. The following SAS DATA step is submitted:
libname temp 'SAS-data-library'
data temp.report;
set sasuser.houses;
newvar = price * 1.04;
run;
Which one of the following statements is true regarding the program above?
A. The program is reading from a temporary data set and writing to a temporary data set.
B. The program is reading from a temporary data set and writing to a permanent data set.
C. The program is reading from a permanent data set and writing to a temporary data set.
D. The program is reading from a permanent data set and writing to a permanent data set.
Answer: D
Q44. The following SAS program is submitted:
data stats;
set revenue;
array weekly{5} mon tue wed thu fri;
total = weekly{i} * .25;
output;
end;
run;
Which one of the following DO statements completes the program and processes the elements of the WEEKLY array?
A. do i = 1 to 5;
B. do weekly{i} = 1 to 5;
C. do i = mon tue wed thu fri;
D. A DO loop cannot be used because the variables referenced do not end in a digit.
Answer: A
Q45. The contents of the raw data file CALENDAR are listed below:
--------10-------20-------30
01012000
The following SAS program is submitted:
data test;
infile 'calendar'
input @1 date mmddyy10.;
if date = '01012000'd then event = 'January 1st'
run;
Which one of the following is the value of the EVENT variable?
A. 01012000
B. January 1st
C. . (missing numeric value)
D. The value can not be determined as the program fails to execute due to errors
Answer: D
Q46. Given the raw data file YEARAMT:
----|---10---|---20---|----30
1901 2
1905 1
1910 6
1925 .
1941 1
The following SAS program is submitted:
data coins;
infile ‘yearamt’;
input year quantity;
<insert statement(s) here>
run;
Which statement(s) completed the program and produced a non-missing value for the variable
TOTQUANTITY in the final observation of the output data set?
A. totquantity + quantity;
B. totquantity = sum(totquantity + quantity);
C. retain totquantity; totquantity = totquantity + quantity;
D. retain totquantity0; totquantity = totquantity + quantity;
Answer: A
Q47. Given the SAS data set WORK.EMP_NAME:
Given the SAS data set WORK.EMP_DEPT: The following program is submitted:
How many observations are in data set WORK.ALL after submitting the program?
A. 1
B. 2
C. 3
D. 5
Answer: B
Q48. Given the SAS data set WORK.P2000:
And the SAS data set WORK.P2008: The following output is desired:
Which SAS program correctly combines the data?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: C