Get Full Version of the Exam
http://www.EnsurePass.com/A00-201.html
Question No.111
Given the SAS data set WORK.ORDERS:
The variable order_id is numeric; customer is character; and shipped is numeric, contains a SAS date value, and is shown with the DATE9. format. A programmer would like to create a new variable, ship_note, that shows a character value with the order_id, shipped date, and customer name. For example, given the first observation ship_note would have the value quot;Order 9341 shipped on 02FEB2009 to Josh Martinquot;.
Which of the following statement will correctly create the value and assign it to ship_note?
-
ship_note=catx(#39; #39;,#39;Order#39;,order_id,#39;shipped on#39;,input(shipped,date9.),#39;to#39;,customer);
-
ship_note=catx(#39; #39;,#39;Order#39;,order_id,#39;shipped on#39;,char(shipped,date9.),#39;to#39;,customer);
-
ship_note=catx(#39; #39;,#39;Order#39;,order_id,#39;shipped on#39;,transwrd(shipped,date9.),#39;to#39;,customer);
-
ship_note=catx(#39; #39;,#39;Order#39;,order_id,#39;shipped on#39;,put(shipped,date9.),#39;to#39;,customer);
Correct Answer: D
Question No.112
The following SAS program is submitted: data work.pieces;
do while (n lt 6); n 1;
end; run;
Which one of the following is the value of the variable N in the output data set?
A. |
4 |
B. |
5 |
C. |
6 |
D. |
7 |
Correct Answer: C
Question No.113
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?
-
SALES1, SALES2, SALES3, SALES4
-
AGENTS1, AGENTS2, AGENTS3, AGENTS4
-
None, the DATA step fails because the ARRAY statement can reference only numeric data.
-
None, the DATA step fails because the ARRAY statement can reference only pre- existing variables.
Correct Answer: A
Question No.114
Which one of the following is true of the SUM statement in a SAS DATA step program?
-
It is only valid in conjunction with a SUM function.
-
It is not valid with the SET, MERGE and UPDATE statements.
-
It adds the value of an expression to an accumulator variable and ignores missing values.
-
It does not retain the accumulator variable value from one iteration of the SAS DATA step to the next.
Correct Answer: C
Question No.115
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?
-
do i = 1 to 5;
-
do weekly{i} = 1 to 5;
-
do i = mon tue wed thu fri;
-
A DO loop cannot be used because the variables referenced do not end in a digit.
Correct Answer: A
Question No.116
The following SAS program is submitted:
proc means data = sasuser.houses std mean max; var sqfeet;
run;
Which one of the following is needed to display the standard deviation with only two decimal places?
-
Add the option MAXDEC = 2 to the MEANS procedure statement.
-
Add the statement MAXDEC = 7.2; in the MEANS procedure step.
-
Add the statement FORMAT STD 7.2; in the MEANS procedure step.
-
Add the option FORMAT = 7.2 option to the MEANS procedure statement.
Correct Answer: A
Question No.117
The following SAS program is submitted: data WORK.DATE_INFO;
Day=quot;01quot; ;
Yr=1960 ;
X=mdy(Day,01,Yr) ; run;
What is the value of the variable X?
-
the numeric value 0
-
the character value quot;01011960quot;
-
a missing value due to syntax errors
-
the step will not compile because of the character argument in the mdy function.
Correct Answer: A
Question No.118
When the following SAS program is submitted, the data set SASDATA.PRDSALES contains 5000 observations:
libname sasdata #39;SAS-data-library#39;; options obs = 500;
proc print data = sasdata.prdsales (firstobs = 100); run;
options obs = max;
proc means data = sasdata.prdsales (firstobs = 500); run;
How many observations are processed by each procedure?
-
400 for PROC PRINT 4500 for PROC MEANS
-
401 for PROC PRINT 4501 for PROC MEANS
-
401 for PROC PRINT 4500 for PROC MEANS
-
500 for PROC PRINT 5000 for PROC MEANS
Correct Answer: B
Question No.119
A SAS PRINT procedure output of the WORK.LEVELS data set is listed below: Obs name level
-
Frank 1
-
Joan 2
-
Sui 2
-
Jose 3
-
Burt 4
-
Kelly .
-
Juan 1
The following SAS program is submitted: data work.expertise;
set work.levels; if level = . then
expertise = #39;Unknown#39;; else if level = 1 then expertise = #39;Low#39;;
else if level = 2 or 3 then expertise = #39;Medium#39;; else
expertise = #39;High#39;; run;
Which of the following values does the variable EXPERTISE contain?
-
Low, Medium, and High only
-
Low, Medium, and Unknown only
-
Low, Medium, High, and Unknown only
-
Low, Medium, High, Unknown, and #39; #39; (missing character value)
Correct Answer: B
Question No.120
The following SAS program is submitted:
If the value for the variable Jobcode is: PILOT2, what is the value of the variable Description?
-
#39; #39; (missing character value)
-
Unknown
-
Senior Pilot
-
SENIOR PILOT
Correct Answer: B
Get Full Version of the Exam
A00-201 Dumps
A00-201 VCE and PDF