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:  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20   
Previous Question             Question   5  /  76            Next Question   

The following SAS program is submitted:
data new (bufsize = 6144 bufno = 4);
set old;
run;
Which one of the following describes the difference between the usage of BUFSIZE= and
BUFNO= options?
A. BUFSIZE= specifies the size of the input buffer in bytes; BUFNO= specifies the number of input
buffers.
B. BUFSIZE= specifies the size of the output buffer in bytes; BUFNO= specifies the number of
output buffers.
C. BUFSIZE= specifies the size of the output buffer in kilobytes; BUFNO= specifies the number of
output buffers.
D. BUFSIZE= specifies the size of the output buffer in kilobytes; BUFNO= specifies the number of
input buffers.
 


View Answer  |  Hide Answer  |  Download Exam PDF  |  Take Another Exam
Previous Question         Question   6  /  76        Next Question

Text is sent to the SAS compiler as a result of macro execution. Which one of the following SAS
system options writes that text to the log?
A. MSOURCE
B. MLOGIC
C. SOURCE2
D. MPRINT
 
 


View Answer  |  Hide Answer  |  Download Exam PDF  |  Take Another Exam
Previous Question         Question   7  /  76        Next Question   

Given the following SAS data set ONE:
ONE
COUNTRY CITY VISIT
-----------------------------------------------
USA BOSTON 10
UK LONDON 5
USA DALLAS 10
UK MARLOW 10
USA BOSTON 20
UK LONDON 15
USA DALLAS 10
The following SAS program is submitted:
proc sql;
select country, city, sum(visit) as TOTAL
from one
group by country, city
order by country, total desc;
quit;
Which one of the following reports is generated?
A.
COUNTRY CITY TOTAL
--------------------------------------------
UK MARLOW 10
UK LONDON 20
USA DALLAS 20
USA BOSTON 50
B.
COUNTRY CITY TOTAL
------------------------------------------
USA BOSTON 50
USA DALLAS 20
UK LONDON 20
UK MARLOW 10
C.
COUNTRY CITY TOTAL
---------------------------------------
UK MARLOW 10
UK LONDON 20
USA BOSTON 50
USA DALLAS 20
D.
COUNTRY CITY TOTAL
--------------------------------------------
UK LONDON 20
UK MARLOW 10
USA BOSTON 50
USA DALLAS 20
 


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)