Get Full Version of the Exam
http://www.EnsurePass.com/A00-201.html
Question No.131
The following SAS program is submitted and reads 100 records from a raw data file: data work.total;
infile #39;file-specification#39; end = eof; input name $ salary;
totsal salary; run;
Which one of the following IF statements writes the last observation to the output data set?
-
if end = 0;
-
if eof = 0;
-
if end = 1;
-
if eof = 1;
Correct Answer: D
Question No.132
You#39;re attempting to read a raw data file and you see the following messages displayed in the SAS Log:
What does it mean?
-
A compiler error, triggered by an invalid character for the variable Salary.
-
An execution error, triggered by an invalid character for the variable Salary.
-
The 1st of potentially many errors, this one occurring on the 4th observation.
-
An error on the INPUT statement specification for reading the variable Salary.
Correct Answer: B
Question No.133
The following SAS program is submitted:
proc contents data = sasuser.airplanes; run;
Which one of the following is produced as output?
-
the data portion of every data set in the SASUSER library
-
the data portion of the data set SASUSER.AIRPLANES only
-
the descriptor portion of every data set in the SASUSER library
-
the descriptor portion of the data set SASUSER.AIRPLANES only
Correct Answer: D
Question No.134
The following SAS program is submitted: data WORK.OUTDS;
do until(Prod GT 6); Prod 1;
end; run;
What is the value of the variable Prod in the output data set?
-
. (missing)
-
6
-
7
-
Undetermined, infinite loop.
Correct Answer: C
Question No.135
The following SAS program is submitted: data work.company;
set work.dept1(keep = jobcode) work.dept2(rename = (jcode = jobcode)); run;
Which one of the following is the result?
-
The variable JCODE is written to the output data set.
-
The variable JOBCODE is written to the output data set.
-
Neither variable JCODE nor JOBCODE is written to the output data set.
-
The program fails to execute due to errors.
Correct Answer: B
Question No.136
The following SAS program is submitted:
What is the initial value of the variable Total in the following program?
-
0
-
Missing
-
The value of the first observations Wagerate
-
Cannot be determined from the information given
-
Correct Answer: B
Question No.137
The contents of the raw data file EMPLOYEE are listed below:
-10-20-30
Ruth 39 11
Jose 32 22
Sue 30 33
John 40 44
The following SAS program is submitted: data test;
infile #39;employee#39;;
input employee_name $ 1-4;
if employee_name = #39;Sue#39; then input age 7-8; else input idnum 10-11;
run;
Which one of the following values does the variable AGE contain when the name of the employee is quot;Suequot;?
A. |
30 |
B. |
33 |
C. |
40 |
D. . (missing numeric value)
Correct Answer: C
Question No.138
The data set WORK.REALESTATE has the variable LocalFee with a format of 9. and a variable CountryFee with a format of 7.;
The following SAS program is submitted:
What are the formats of the variables LOCALFEE and COUNTRYFEE in the output dataset?
-
LocalFee has format of 9. and CountryFee has a format of 7.
-
LocalFee has format of 9. and CountryFee has a format of percent7.2
-
Both LocalFee and CountryFee have a format of percent7.2
-
The data step fails execution; there is no format for LocalFee.
Correct Answer: C
Question No.139
Which one of the following is true of the RETAIN statement in a SAS DATA step program?
-
It can be used to assign an initial value to _N_ .
-
It is only valid in conjunction with a SUM function.
-
It has no effect on variables read with the SET, MERGE and UPDATE statements.
-
It adds the value of an expression to an accumulator variable and ignores missing values.
Correct Answer: C
Question No.140
The following SAS program is submitted: data work.new;
mon = 3;
day = 23;
year = 2000;
date = mdy(mon,day,year); run;
Which one of the following is the value of the DATE variable?
-
a character string with the value #39;23mar2000#39;
-
a character string with the value #39;03/23/2000#39;
-
a numeric value of 14692, which represents the SAS date value for March 23, 2000
-
a numeric value of 3232000, which represents the SAS date value for March 23, 2000
Correct Answer: C
Get Full Version of the Exam
A00-201 Dumps
A00-201 VCE and PDF