Testking Sas a00-202 exam
Posted September 26th, 2008 by PassGuide.com-Free Braindumps Bootcampsas advanced programming exam : a00-202 Examtk a00-202 Interactive Testing Engine Included!
82 Questions
Updated : 09/18/2008
Price : $87.99 $79.99
QUESTION 21
The following SAS program is submitted:
%let lib = %upcase(sasuser);
proc sql;
select nvar
from dictionary.tables
where libname = “&lib”;
quit;
Given that several SAS data sets exist in the SASUSER library, which one of the
following is generated as output?
A. no result set
B. a syntax error in the log
C. a report showing the names of each table in SASUSER
D. a report showing the number of columns in each table in SASUSER
Answer: D
QUESTION 22
Given the following SAS data set ONE:
ONE
GROUP SUM
————————-
A 765
B 123
C 564
The following SAS program is submitted:
data_null_;
set one;
call symput(group,sum);
run;
Which one of the following is the result when the program finishes execution?
A. Macro variable C has a value of 564.
B. Macro variable C has a value of 1452.
C. Macro variable GROUP has a value of 564.
D. Macro variable GROUP has a value of 1452.
Answer: A
QUESTION 23
The SAS data set ONE consists of five million observations and has 25 variables.
Which one of the following SAS programs successfully creates three new variables
TOTREV, TOTCOST, and PROFIT and requires the least CPU time to be processed?
A. data two;
set one;
totrev = sum(price * quantity);
totcost = sum(fixed, variable);
profit = sum(totrev,otcost);
if totrev > 1000;
run;
B. data two;
set one;
totrev = sum(price * quantity);
if totrev > 1000;
totcost = sum(fixed, variable);
profit = sum(totrev,otcost);
run;
C. data two;
set one;
totrev = sum(price * quantity);
where totrev > 1000;
totcost = sum(fixed, variable);
profit = sum(totrev,otcost);
run;
D. data two;
set one;
where totrev > 1000;
totrev = sum(price * quantity);
totcost = sum(fixed, variable);
profit = sum(totrev,otcost);
run;
Answer: B
QUESTION 27
The SAS data set ONE has a variable X on which an index has been created. The data
sets ONE and THREE are sorted by X.
Which one of the following SAS programs uses the index to select observations from the
data set ONE?
A. data two;
set three;
set one key = X;
run;
B. data two;
set three key = X;
set one;
run;
C. data two;
set one;
set three key = X;
run;
D. data two;
set three;
set one (key = X);
run;
Answer: A
QUESTION 32
Given the following SAS data set ONE:
ONE
CATEGORY AGE SALARY BONUS
—-
M 28 200 .
M 25 100 10
F 18 100 50
F 25 200 10
The following SAS program is submitted:
proc sql;
create table two as
select category, salary + bonus as EARNINGS
from one; quit;
Which one of the following represents the data values stored in the data set TWO?
A. CATEGORY EARNINGS
————————————-
M 200
M 110
F 150
F 210
B. CATEGORY EARNINGS
————————————
M .
M 110
F 150
F 210
C. CATEGORY SALARY BONUS EARNINGS
—————-
M 200 . 200
M 100 10 110
F 100 50 150
F 200 10 210
D. CATEGORY SALARY BONUS EARNINGS
—————-
M 200 . .
M 100 10 110
M 200 . 200
M 100 10 110
F 100 50 150
F 200 10 210
Answer: B
33
QUESTION 82
The following SAS program is submitted:
% let var = chicago, 1;
data a;
var = ‘new york, 2′;
newvar = %scan(&var,2,%str());
run;
Which one of the following explains why the program fails to execute?
A. The %STR() is invalid syntax.
B. The %SCAN function does not exist.
C. The %SCAN function has too many arguments.
D. The macro variable VAR does not get created properly.
Answer: C
Free down:Pass4sure sas a00-202
Free down:Testking a00-202
Related Posts
Related Posts
Tags: a00-202
One Response to “Testking Sas a00-202 exam”
September 26th, 2008 at 4:30 pm
[...] a00-201 sas base programming exam Testking a00-202 sas advanced programming exam Testking a00-203 sas warehouse development specialist concepts exam [...]
Leave a Reply