Testinside SAS Institute A00-202
Posted September 26th, 2008 by PassGuide.com-Free Braindumps Bootcampas advanced programming exam : A00-202 Exam
Exam Number/Code: A00-202
Exam Name: sas advanced programming exam
Questions and Answers: 130 Q&As
Price: $125.00
Update Time: 2008-6-19
“sas advanced programming exam”, also known as A00-202 exam, is a SAS Institute certification.
Preparing for the A00-202 exam? Searching A00-202 Test Questions, A00-202 Practice Exam, A00-202 Dumps?
Free A00-202 Demo Download
QUESTION 1
Which of the following statement(s) in the DATASETS procedure alters the name of a
SAS data set stored in a SAS data library?
A. RENAME statement only
B. CHANGE statement only
C. MODIFY and RENAME statements
D. MODIFY and CHANGE statements
Answer: B
QUESTION 2
The following SAS program is submitted:
%let development = ontime;
proc print data = sasuser.highway;
title “For &dept”;
title2 “This project was completed &development”;
run;
Which one of the following statements completes the above and resolves title1 to “For
research&development”?
A. %let dept = %str(research&development);
B. %let dept = %str(research%&development);
C. %let dept = %nrstr(research&development);
D. %let dept = %nrstr(research%&development);
Answer: C
QUESTION 3
Which one of the following options controls the pagesize of a SAS data set?
A. SIZE=
B. BUFNO=
C. BUFSIZE=
D. PAGESIZE=
Answer: C
QUESTION 4
Given the following SAS data set ONE:
ONE
REP COST
____________
SMITH 200
SMITH 400
JONES 100
SMITH 600
JONES 100
JONES 200
JONES 400
SMITH 800
JONES 100
JONES 300
The following SAS program is submitted:
proc sql;
select rep, avg(cost) as AVERAGE
from one
group by rep
having avg(cost) > (select avg(cost) from one);
quit;
Which one of the following reports is generated?
A. REP AVERAGE
_______________
JONES 200
B. REP AVERAGE
_________________
JONES 320
C. REP AVERAGE
________________
SMITH 320
D. REP AVERAGE
________________
SMITH 500
Answer: D
QUESTION 5
The following SAS program is submitted:
proc sort data = sales tagsort;
by month year;
run;
Which of the following resource(s) is the TAGSORT option reducing?
A. I/O usage only
B. CPU usage only
C. I/O and CPU usage
D. temporary disk usage
Answer: D
QUESTION 6
The following SAS program is submitted:
data one;
do i = 1 to 10;
ptobs =ceil(ranuni(0) * totobs);
set temp point = ptobs
nobs = totobs;
output;
end;
stop;
run;
The SAS data set TEMP contains 2,500,000 observations. Which one of the following
represents the possible values for PTOBS?
A. any integer between 1 and 10
B. any real number between 0 and 1
C. any integer between 1 and 2,500,000
D. any real number between 1 and 2,500,000
Answer: C
QUESTION 7
Which one of the following programs contains a syntax error?
A. proc sql;
select product.*, cost.unitcost, sales.quantity
from product p, cost c, sales s
where p.item = c.item and
p.item = s.item;
quit;
B. proc sql;
select product.*, cost.unitcost, sales.quantity
from product, cost, sales
where product.item = cost.item and
product.item = sales.item;
quit;
C. proc sql;
select p.*, c.unitcost, s.quantity
from product as p, cost as c, sales as s
where p.item = c.item and
p.item = s.item;
quit;
D. proc sql;
select p.*, c.unitcost, s.quantity
from product, cost, sales
where product.item = cost.item and
product.item = sales.item;
quit;
Answer: D
QUESTION 8
The following SAS code is submitted:
%macro houses(dsn = houses, sub = RANCH);
data &dsn;
set sasuser.houses;
if style = “&sub”;
run;
%mend;
%houses(sub = SPLIT)
%houses(dsn = ranch)
%houses(sub = TWOSTORY)
Which one of the following is the value of the automatic macro variable SYSLAST?
A. work.ranch
B. work.houses
C. WORK.RANCH
D. WORK.HOUSES
Answer: D
QUESTION 9
Given the following SAS data sets ONE and TWO:
ONE TWO
NUM COUNTRY NUM CITY
______________ ______________
1 CANADA 3 BERLIN
2 FRANCE 5 TOKYO
3 GERMANY 4 BELGIUM
5 JAPAN
The following SAS program is submitted:
proc sql;
select country
from one
where not exists
(select *
from two
where one.num = two.num);
quit;
Which one of the following reports is generated?
A. COUNTRY
—————
GERMANY
JAPAN
B. COUNTRY
—————-
FRANCE
BELGIUM
C. COUNTRY
————–
CANADA
FRANCE
BELGIUM
D. COUNTRY
————–
CANADA
FRANCE
GERMANY
Answer: C
TestInside offers free demo for A00-202 exam ( sas advanced programming exam). You can check out the interface, question quality and usability of our practice exams before you decide to buy it. We are the only one site can offer demo for almost all products.
Free down:Pass4sure sas a00-202
Free down:Testking a00-202
Related Posts
Related Posts
Tags: a00-202
Leave a Reply