Get Full Version of the Exam
http://www.EnsurePass.com/A00-201.html
Question No.121
Which one of the following is true when SAS encounters a data error in a DATA step?
-
The DATA step stops executing at the point of the error, and no SAS data set is created.
-
A note is written to the SAS log explaining the error, and the DATA step continues to execute.
-
A note appears in the SAS log that the incorrect data record was saved to a separate SAS file for further examination.
-
The DATA step stops executing at the point of the error, and the resulting DATA set contains observations up to that point.
Correct Answer: B
Question No.122
The following SAS program is submitted:
What will the data set WORK.TEST contain?
-
Option A
-
Option B
-
Option C
-
Option D
Correct Answer: A
Question No.123
Given the SAS data set WORK.ORDERS:
The variable Order_id is numeric; Customer is character; and Ship_date is a numeric containing a SAS date value.
A programmer would like to create a new variable called Note, that shows a character value with the Order_id and Ship_date shown with a date9. format. For the first observation, Note would look like the following: quot;Order 9341 shipped on 02FEB2009quot;.
Which of the following statement will correctly create the value and assign it to Note?
-
note=catx(#39; #39;,#39;Order#39;,order_id,#39;shipped on#39;,input(ship_date,date9.));
-
note=catx(#39; #39;,#39;Order#39;,order_id,#39;shipped on#39;,char(ship_date,date9.));
-
note=catx(#39; #39;,#39;Order#39;,order_id,#39;shipped on#39;,transwrd(ship_date,date9.));
-
note=catx(#39; #39;,#39;Order#39;,order_id,#39;shipped on#39;,put(ship_date,date9.));
Correct Answer: D
Question No.124
Consider the following data step: data WORK.NEW;
set WORK.OLD;
Count 1; run;
The varaible Count is created using a sum statement. Which statement regarding this variable is true?
-
It is assigned a value 0 when the data step begins execution.
-
It is assigned a value of missing when the data step begins execution.
-
It is assigned a value 0 at compile time.
-
It is assigned a value of missing at compile time.
Correct Answer: C
Question No.125
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 #39;amount#39;; input @1 salary 6.;
if _error_ then description = #39;Problems#39;; else description = #39;No Problems#39;;
run;
Which one of the following is the value of the DESCRIPTION variable?
-
Problems
-
No Problems
-
#39; #39; (missing character value)
-
The value can not be determined as the program fails to execute due to errors.
Correct Answer: A
Question No.126
The SAS data set WORK.ONE contains a numeric variable named Num and a character variable named Char:
The following SAS program is submitted:
What is output?
-
Option A
-
Option B
-
Option C
-
Option D
Correct Answer: D
Question No.127
The following SAS program is submitted: data work.one;
x = 3;
y = 2;
z = x ** y; run;
Which one of the following is the value of the variable Z in the output data set?
-
6
-
9
-
. (missing numeric value)
-
The program fails to execute due to errors.
Correct Answer: B
Question No.128
The following SAS DATA step is submitted: libname temp #39;SAS-data-library#39;;
data temp.report; set sasuser.houses;
newvar = price * 1.04; run;
Which one of the following statements is true regarding the program above?
-
The program is reading from a temporary data set and writing to a temporary data set.
-
The program is reading from a temporary data set and writing to a permanent data set.
-
The program is reading from a permanent data set and writing to a temporary data set.
-
The program is reading from a permanent data set and writing to a permanent data set.
Correct Answer: D
Question No.129
The following SAS program is submitted: data _null_;
set old (keep = prod sales1 sales2); file #39;file-specification#39;;
put sales1 sales2; run;
Which one of the following default delimiters separates the fields in the raw data file created?
-
: (colon)
-
(space)
-
, (comma)
-
; (semicolon)
Correct Answer: B
Question No.130
The SAS data set WORK.AWARDS is listed below: fname points
Amy 2
Amy 1
Gerard 3
Wang 3
Wang 1
Wang 2
The following SAS program is submitted: proc sort data = work.awards;
by descending fname points; run;
Which one of the following represents how the observations are sorted?
-
Wang 3
Gerard 3
Wang 2
Amy 2
Wang 1
Amy 1
-
Wang 3
Wang 2
Wang 1
Gerard 3
Amy 2
Amy 1
-
Wang 3
Wang 1
Wang 2
Gerard 3
Amy 2
Amy 1
-
Wang 1
Wang 2
Wang 3
Gerard 3
Amy 1
Amy 2
Correct Answer: D
Get Full Version of the Exam
A00-201 Dumps
A00-201 VCE and PDF