最新SASInstitute A00-211题目分享
Testpassport SAS Institute Systems Certification A00-211题目由资深IT认证讲师和SAS Institute Systems Certification产品专家结合PROMETRIC的真实考试环境最新原题倾心打造，题目覆盖了当前最新的真实考题，并且全部附有正确答案。
认证编号: SAS Base Programming for SAS 9
考题数量: 140 Q&As
更新: Dec-23-2009
1. The following SAS program is submitted:
data work.flights;
destination = 'CPH';
select(destination);
when('LHR') city = 'London';
when('FRA') city = 'Frankfurt';
otherwise;
end;
run;
What are the length and value of the CITY variable?
A.length of 6, value of CPH
B.length of 9, value of CPH
C.length of 6, value of ' ' (missing character value)
D.length of 9, value of ' ' (missing character value)
Answer: C
2. Given the SAS data set SASUSER.HOUSES:
The following SAS program is submitted:
The following output is desired:
style price
CONDO $79,700
TWOSTORY $62,550
Which DEFINE statement completes the program and produces the desired output?
A.define style / width = 9;
B.define style / order width = 9;
C.define style / group width = 9;
D.define style / display width = 9;
The safer , easier way to help you pass any IT exams.
3 / 11
Answer: C
3. The following SAS program is submitted:
libname temp 'SAS data library';
data work.new;
set temp.jobs;
format newdate mmddyy10.;
mdate = month(newdate);
ddate = weekday(newdate);
run;
proc print data = work.new;
run;
The variable NEWDATE contains the SAS date value for April 15, 2005.
What output is produced if April 15, 2005 falls on a Friday?
A.Obs newdate mdate ddate
1 04/15/2005 APR 6
B.Obs newdate mdate ddate
1 04/15/2005 4 6
C.Obs newdate mdate ddate
1 04/15/2005 APR 7
D.Obs newdate mdate ddate
1 04/15/2005 4 7
Answer: B
4. The following SAS program is submitted:
data work.sets;
do until (prod gt 6);
prod + 1;
end;
run;
What is the value of the variable PROD in the output data set?
A.6
B.7
C.8
D.. (missing numeric)
Answer: B
The safer , easier way to help you pass any IT exams.
4 / 11
5. What is the purpose of the END= option on the INFILE statement?
A.It identifies the last record read in a raw data file.
B.It identifies the last DATA step statement to be executed.
C.It identifies the length of the record that is being processed.
D.It moves the end of record marker to the length specified by the logical record length.
Answer: A
6. Given the SAS data set ONE:
ONE
XY Z
1 A 27
1A 33
1 B45
2 A 52
2 B 69
3 B 70
4 A 82
4 C 91
The following SAS program is submitted:
data two;
set one;
by x y;
if first.y;
run;
proc print data = two noobs;
run;
Which report is produced?
A.X Y Z
1 A 27
1 B 45
2 A 52
2 B 69
3 B 70
4 A 82
4 C 91
The safer , easier way to help you pass any IT exams.
5 / 11
B.X Y Z
1 A 33
1 B 45
2 A 52
2 B 69
3 B 70
4 A 82
4 C 91
C.X Y Z
1 B 45
2 A 52
2 B 69
3 B 70
4 A 82
4 C 91
D.The PRINT procedure fails because the data set TWO is not created in the DATA step.
Answer: A
7. Given the raw data file YEARAMT:
----|----10---|----20---|----30
1901 2
1905 1
1910 6
1925 .
1941 1
The following SAS program is submitted:
data coins;
infile 'yearamt';
input year quantity;
totquantity = totquantity + quantity;
run;
What is the value of the variable TOTQUANTITY in the second observation?
A.0
B.1
C.3
The safer , easier way to help you pass any IT exams.
6 / 11
D.. (missing numeric)
Answer: D
8. Given the contents of the raw data file PRODUCT:
----|----10---|----20---|----30
24613 $25.31
The following SAS program is submitted:
data inventory; infile 'product'; input idnum 5. @10 price; run;
What is the value of the PRICE variable?
A.25.31
B.$25.31
C.. (missing numeric value)
D.No value is stored.
Answer: C最新A00-211题目分享 祝大家新年快乐 好资料，非常感谢！
页:
[1]