Get Full Version of the Exam
http://www.EnsurePass.com/A00-201.html
Question No.51
Which of the following choices is an unacceptable ODS destination for producing output that can be viewed in Microsoft Excel?
-
MSOFFICE2K
-
EXCELXP
-
CSVALL
-
WINXP
Correct Answer: D
Question No.52
The following SAS program is submitted:
The program fails execution due to syntax errors. What is the cause of the syntax error?
-
The variable MONTHSALES does not exist.
-
An array cannot be referenced on a KEEP data set option.
-
The KEEP= data set option should be (KEEP = MONTHSALES).
-
The KEEP= data set option should be the statement KEEP MONTHSALES{12}.
Correct Answer: B
Question No.53
The following SAS program is submitted;
data combine;
country = `Italy, Russia, ireland#39;; found = find(country, `i#39;);
run;
What is the value of the variable FOUND in the output data set?
-
1
-
12
-
Italy
-
Russia
Correct Answer: B
Question No.54
Which statement describes a characteristic of the SAS automatic variable _ERROR_?
-
The _ERROR_ variable maintains a count of the number of data errors in a DATA step.
-
The _ERROR_ variable is added to the program data vector and becomes part of the data set being created.
-
The _ERROR_ variable can be used in expressions in the DATA step.
-
The _ERROR_ variable contains the number of the observation that caused the data error.
Correct Answer: C
Question No.55
The following code was modified to generate the results further below: proc format;
value agegrp
low-12 =#39;Pre-Teen#39; 13-high = #39;Teen#39;; run;
proc means data=SASHELP.CLASS; var Height;
class Sex Age; format Age agegrp.; run;
The following results were generated to display only specific statistics and limit the decimals with the modification: Which statement below was modified or added to generate the results above:
-
var Height / nobs min max mean maxdec=1;
-
proc means data=SASHELP.CLASS maxdec=1 ;
-
proc means data=SASHELP.CLASS min max mean maxdec=1;
-
output nobs min max mean maxdec=1;
Correct Answer: C
Question No.56
The SAS data set SASUSER.HOUSES contains a variable PRICE which has been assigned a permanent label of quot;Asking Pricequot;. Which SAS program temporarily replaces the label quot;Asking Pricequot; with the label quot;Sale Pricequot; in the output?
-
proc print data = sasuser.houses; label price = quot;Sale Pricequot;; run;
-
proc print data = sasuser.houses label; label price quot;Sale Pricequot;; run;
-
proc print data = sasuser.houses label; label price = quot;Sale Pricequot;; run;
-
proc print data = sasuser.houses; price = quot;Sale Pricequot;; run;
Correct Answer: C
Question No.57
Given the SAS data set WORK.TEMPS:
The following program is submitted:
Which output is correct?
-
Option A
-
Option B
-
Option C
-
Option D
Correct Answer: C
Question No.58
Given the data set WORK.EMPDATA:
Which one of the following where statements would display observations with job titles containing the word #39;Manager#39;?
-
where substr(Job_Title,(length(Job_Title)-6))=#39;Manager#39;;
-
where upcase(scan(Job_Title,-1,#39; #39;))=#39;MANAGER#39;;
-
where Job_Title=#39;% Manager #39;;
-
where Job_Title like #39;%Manager%#39;;
-
Correct Answer: D
Question No.59
Given the raw data file EMPLOYEE:
-I1 0-I20-I 30
Ruth 39 11
Jose 32 22
Sue 30 33
John 40 44
The following SAS program is submitted: data test;
infile `employee#39;;
input employee_name $ 1-4;
if employee_name = `Ruth#39; then input idnum 10-11; else input age 7-8;
run;
What value does the variable IDNUM contain when the name of the employee is quot;Ruthquot;?
A. |
11 |
B. |
22 |
C. |
33 |
D. |
(missing numeric value) |
Correct Answer: B
Question No.60
The following SAS program is submitted:
data WORK.ONE; Text=#39;Australia, US, Denmark#39;; Pos=find(Text,#39;US#39;,#39;i#39;,5);
run;
What value will SAS assign to Pos?
A. |
0 |
B. |
1 |
C. |
2 |
D. |
12 |
Correct Answer: D
Get Full Version of the Exam
A00-201 Dumps
A00-201 VCE and PDF