Latest 2014 Pass4sure and Lead2pass SAS A00-201 Practice Tests (A 1-10)

Part: A
1: 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?
A.Add the option MAXDEC = 2  to the MEANS procedure statement.
B.Add the statement MAXDEC = 7.2; in the MEANS procedure step.
C.Add the statement FORMAT STD 7.2; in the MEANS procedure step.
D.Add the option FORMAT = 7.2 option to the MEANS procedure statement.
Answers: A

2: Which one of the following is true when SAS encounters a data error in a DATA step?
A.The DATA step stops executing at the point of the error, and no SAS data set is created.
B.A note is written to the SAS log explaining the error, and the DATA step continues to execute.
C.A note appears in the SAS log that the incorrect data record was saved to a separate SAS file for further examination.
D.The DATA step stops executing at the point of the error, and the resulting DATA set contains observations up to that point.
Answers: B

3: The following SAS program is submitted:

data work.total;
set work.salary(keep = department wagerate);
by department;
if first.department then payroll = 0;
payroll + wagerate;
if last.department;
run;

The SAS data set WORK.SALARY, currently ordered by DEPARTMENT, contains 100 observations for each of 5 departments.
Which one of the following represents how many observations the WORK.TOTAL data set contains?
A.5
B.20
C.100
D.500
Answers: A

4: The following SAS program is submitted:

data work.retail;
cost = ‘20000’;
total = .10 * cost;
run;

Which one of the following is the value of the variable TOTAL in the output data set?
A.2000
B.’2000′
C.. (missing numeric value)
D.’ ‘ (missing character value)
Answers: A

5: The following SAS program is submitted:

libname sasdata ‘SAS-data-library’;
data test;
set sasdata.chemists;
if jobcode = ‘chem3’
then description = ‘Senior Chemist’;
else description = ‘Unknown’;
run;

A value for the variable JOBCODE is listed below:

JOBCODE
CHEM3

Which one of the following values does the variable DESCRIPTION contain?
A.chem3
B.Unknown
C.Senior Chemist
D.’ ‘ (missing character value)
Answers: B

6: The following SAS program is submitted:

data work.month;
date = put(’13mar2000’d,ddmmyy10.);
run;

Which one of the following represents the type and length of the variable DATE in the output data set?
A.numeric, 8 bytes
B.numeric, 10 bytes
C.character, 8 bytes
D.character, 10 bytes
Answers: D

7: The SAS data set QTR1_REVENUE is listed below:

The following SAS program is submitted:

proc sort data = qtr1_revenue;
by destination descending revenue;
run;

Which one of the following represents the first observation in the output data set?

Answers: D

8: The  following SAS program is submitted:

data work.flights;
destination = ‘CPH’;
select(destination);
when(‘LHR’) city = ‘London’;
when(‘CPH’) city = ‘Copenhagen’;
otherwise;
end;
run;

Which one of the following is the value of the CITY variable?
A.London
B.Copenh
C.Copenhagen
D.’ ‘ (missing character value)
Answers: B

9: The following SAS program is submitted and reads 100 records from a raw data file:

data work.total;
infile ‘file-specification’ end = eof;
input name $ salary;
totsal + salary;
<insert IF statement here>
run;

Which one of the following IF statements writes the last observation to the output data set?
A.if end = 0;
B.if eof = 0;
C.if end = 1;
D.if eof = 1;
Answers: D

10: The following SAS program is submitted:

data work.new;
length word $7;
amount = 4;
if amount = 4 then word = ‘FOUR’;
else if amount = 7 then word = ‘SEVEN’;
else word = ‘NONE!!!’;
amount = 7;
run;

Which one of the following represents the values of the AMOUNT and WORD variables?

Answers: A

 

If you want to pass the SAS A00-201 exam sucessfully, recommend to read latest SAS A00-201 Braindumps full version.