Get Full Version of the Exam
http://www.EnsurePass.com/A00-201.html
Question No.201
The following SAS program is submitted:
Which statement is true about the output data set?
-
The type of the variable CharEmpid is numeric.
-
The type of the variable CharEmpid is unknown.
-
The type of the variable CharEmpid is character.
-
The program fails to execute due to errors.
Correct Answer: D
Question No.202
Given the SAS data set WORK.PRODUCTS:
How many variables does the WORK.REVENUE data set contain?
|
A. |
2 |
|
B. |
3 |
|
C. |
4 |
|
D. |
6 |
Correct Answer: A
Question No.203
The following SAS program is submitted: data WORK.ACCOUNTING;
set WORK.DEPARTMENT;
length EmpId $6; CharEmpid=EmpId; run;
If data set WORK.DEPARTMENT has a numeric variable EmpId. Which statement is true about the output dataset?
-
The type of the variable CharEmpid is numeric.
-
The type of the variable CharEmpid is unknown.
-
The type of the variable CharEmpid is character.
-
The program fails to execute due to errors.
Correct Answer: D
Question No.204
Which one of the following SAS system options displays the time on a report?
-
TIME
-
DATE
-
TODAY
-
DATETIME
Correct Answer: B
Question No.205
Given the SAS data set WORK.ONE:
And the SAS data set WORK.TWO:
The following program is submitted:
What is the first observation in the SAS data set WORK.BOTH?
-
Option A
-
Option B
-
Option C
-
Option D
Correct Answer: C
Question No.206
Given the SAS data set WORK.ONE:
The following SAS program is submitted:
The data set WORK.TWO is created, where Day would be 1 for Sunday, 2 for Monday, 3 for Tuesday, … :
Which expression successfully completed the program and creates the variable DAY?
-
day(BeginDate)
-
weekday(BeginDate)
-
dayofweek(BeginDate)
-
getday(BeginDate,today())
Correct Answer: B
Question No.207
Consider the following data step:
In filtering the values of the variable X in data set WORK.OLD, what value new value would be assigned to X if its original value was a missing value?
-
X would get a value of 1.
-
X would get a value of 3.
-
X would retain its original value of missing.
-
This step does not run because of syntax errors.
Correct Answer: A
Question No.208
The following SAS DATA step is submitted: data work.accounting;
set work.department; length jobcode $ 12;
run;
The WORK.DEPARTMENT SAS data set contains a character variable named JOBCODE with a length of 5. Which one of the following is the length of the variable JOBCODE in the output data set?
A.
5
B.
8
C.
12
D.
The length can not be determined as the program fails to execute due to errors.
Correct Answer: A
Question No.209
The following SAS program is submitted: data work.test;
Title = #39;A Tale of Two Cities, Charles J.Dickens#39;; Word = scan(title,3,#39; ,#39;);
run;
Which one of the following is the value of the variable WORD in the output data set?
-
T
-
of
-
Dickens
-
#39; #39; (missing character value)
-
Correct Answer: D
Question No.210
Given the following raw data records:
The following output is desired:
Which SAS program correctly reads in the raw data?
-
Option A
-
Option B
-
Option C
-
Option D
Correct Answer: D