a00-201 braindumps 1
Posted August 24th, 2009 by PassGuide.com-Free Braindumps BootcampExam Name: SAS base programming exam
Exam Type: SAS Institute
Exam Code: A00-201 Total Questions: 140
Question: 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.
Answer: A
Question: 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.
Answer: B
Question: 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
Answer: A
Question: 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)
Answer: B
Question: 138
The SASDATA.BANKS data set has five observations when the following SAS program is
submitted; libname sasdata ‘SAS-data-library’;
data allobs;
set sasdata.banks;
capitaI=0;
do year = 2000 to 2020 by 5;
capital + ((capital+2000) * rate);
output;
end;
run;
How many observations will the ALLOBS data set contain?
A. 5
B. 15
C. 20
D. 25
Answer: D
The following SAS program is submitted: I
ibname company ‘SAS-data-library’;
proc sort data = company.payroll;
by EmployeelDNumber;
run;
Write access has been granted to the COMPANY library.
Which one of the following represents how the observations are sorted?
A. COMPANY.PAYROLL is recreated in sorted order by EmployeelDNumber.
B. COMPANY.PAYROLL is stored in original order, and a new data set PAYROLL is created in
sorted order by EmployeelDNumber.
C. COMPANYPAYROLL is stored in original order, and a new data set
COMPANY.PAYROLLSORTED is created in sorted order by EmployeelDNumber.
D. COMPANY.PAYROLL is recreated in sorted order by EmployeelDNumber, and a new data
set PAYROLL is created in sorted order by Emp loyeelDNumber.
Answer: A
Question: 91
Which one of the following SAS system options prevents the page number from appearing on a
report?
A. NONUM
B. NOPAGE
C. NONUMBER
D. NOPAGENUM
Answer: C
Question: 87
The following SAS program is submitted:
data work.month; d
ate = input(’13mar2000’,date9.);
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, 9 bytes
C. character, 8 bytes
D. character, 9 bytes
Answer: A
Leave a Reply