HOME    CONTACT US    FAQ          MY ACCOUNT   LOGIN   REGISTER  
You are here : ››› ››› ›››
Exam Rate (A00-202) 22 users reviews.
SAS Advanced Programming Exam ( A00-202 )
Exam : A00-202
To download the latest most up-to-date Q & A of this exam please click on the download button or contact us for further details
Pages:  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30   
Previous Question             Question   15  /  76            Next Question   

Given the following SAS data sets ONE and TWO:
ONE TWO
NUM CHAR1 NUM CHAR2
------------------ --------------------
1 A1 2 X1
1 A2 2 X2
2 B1 3 Y
2 B2 5 V
4 D
The following SAS program is submitted creating the output table THREE:
proc sql;
create table three as
select one.num, char1, char2
from one, two
where one.num = two.num;
quit;
THREE
NUM CHAR1 CHAR2
----------------------------------
2 B1 X1
2 B1 X2
2 B2 X1
2 B2 X2
Which one of the following DATA step programs creates an equivalent SAS data set THREE?
A. data three;C.data three;
merge one (in = in1) two (in = in2);
by num;
if in1 and in2;
run;
B. data three;D.data three;
set one;
do i = 1 to numobs;
set two(rename = (num = num2)) point = i
nobs = numobs;
if num2 = num then output;
end;
drop num2;
run;
C. data three;
merge one two;
by num;
run;
D. data three;
set one;
set two;
by num;
run;
 


View Answer  |  Hide Answer  |  Download Exam PDF  |  Take Another Exam
Previous Question         Question   16  /  76        Next Question
Question Is not available in this preview
Available for regestered users only

Which one of the following SAS programs displays the descriptor portion of each data set stored in
the SASUSER library?
A. proc datasets lib = sasuser.all;
quit;
B. proc datasets lib = sasuser;
contents data = _all_;
quit;
C. proc datasets lib = sasuser._all_;
quit;
D. proc datasets lib = sasuser;
contents data = all;
quit;
 
 


View Answer  |  Hide Answer  |  Download Exam PDF  |  Take Another Exam
Previous Question         Question   17  /  76        Next Question   
Question Is not available in this preview
Available for regestered users only

The SAS data set TEMP has the following distribution of values for variable A:
A Frequency
1 500,000
2 500,000
6 7,000,000
8 3,000
Which one of the following SAS programs requires the least CPU time to be processed?
A. data new;
set temp;
if a = 8 then
b = 'Small ';
else if a in(1, 2) then
b = 'Medium';
else if a = 6 then
b = 'Large';
run;
B. data new;
set temp;
if a = 6 then
b = 'Large ';
if a in (1, 2) then
b = 'Small';
run;
C. data new;
set temp;
if a = 6 then
b = 'Large ';
else if a in (1, 2) then
b = 'Medium';
else if a = 8 then
b = 'Small';
D. data new;
set temp;
if a in (1, 2) then
b = 'Medium';
else if a = 8 then
b = 'Small';
else if a = 6 then
b = 'Large';
run;
 


View Answer  |  Hide Answer  |  Download Exam PDF  |  Take Another Exam
Exam Features
Success Guaranteed
Instant Download
24/7 Customer Support
Lowest price guaranteed


  
Facebook
See also
Most Popular Exams
(A00-211) SAS Base Programming for SAS (r) 9
(A00-212) SAS Advanced Programming for SAS 9
(A00-260) SAS Data Integration Development
(A00-250) SAS Platform Administration for SAS9
(A00-281) Clinical Trials Programming Using SAS 9 Accelerated Version
(A00-270) SAS BI Content Development
(A00-201) sas base programming exam
(A00-280) SAS Certified Clinical Trials Programmer Using SAS 9
(A00-211_V2) SAS Base Programming for SAS (r) 9
(A00-202) Advanced programming
(A01-250) SAS Platform Administration
(A00-260_V2) SAS Data Integration Development
(A00-204) SAS Warehouse Architect Concepts
(A00-206) SAS Warehouse Technology Exam
(A00-205) SAS Webaf Server-Side Application Development
(A00-203) Sas Warehouse Development Specialist Concepts
All Related Exams
Exam NameCode
sas base programming exam (A00-201)
Advanced programming (A00-202)
Sas Warehouse Development Specialist Concepts (A00-203)
SAS Warehouse Architect Concepts (A00-204)
SAS Webaf Server-Side Application Development (A00-205)
SAS Warehouse Technology Exam (A00-206)
SAS Base Programming for SAS (r) 9 (A00-211)
SAS Advanced Programming for SAS 9 (A00-212)
SAS Platform Administration for SAS9 (A00-250)
SAS Data Integration Development (A00-260)
SAS BI Content Development (A00-270)
SAS Certified Clinical Trials Programmer Using SAS 9 (A00-280)
Clinical Trials Programming Using SAS 9 Accelerated Version (A00-281)
SAS Platform Administration (A01-250)
SAS Base Programming for SAS (r) 9 (A00-211_V2)
SAS Data Integration Development (A00-260_V2)
SAS Advanced Programming (A00-212_V2)
SAS Advanced Programming Exam (A00-202_V2)
SAS Statistical Business Analysis SAS9: Regression and Model (A00-240)
Clinical Trials Programming Using SAS 9 (A00-280_v2)