Free SASInstitute A00-202 Exam Dumps Questions & Answers
| Exam Code/Number: | A00-202Join the discussion |
| Exam Name: | SAS advanced programming exam |
| Certification: | SASInstitute |
| Free Question Number: | 76 |
| Publish Date: | Jul 25, 2026 |
| # of views: | 4547 |
|
|
|
Given the following SAS data set SASUSER.HIGHWAY:
SASUSER.HIGHWAY
STEERING SEATBELT SPEED STATUS COUNT
absent no 0-29 serious 31 absent no 0-29 not 1419 absent no 30-49 serious 191 absent no 30-49 not 2004 absent no 50+ serious 216
The following SAS program is submitted:
%macro highway;
proc sql noprint;
select count(distinct status)
into :numgrp
from sasuser.highway;
%let numgrp = &numgrp;
select distinct status
into :group1-:group&numgrp
from sasuser.highway;
quit;
%do i = 1 %to &numgrp;
proc print data = sasuser.highway;
where status = "&&group&i" ;
run;
%end; %mend;
%highway How many reports are produced by the above program?
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?
Given the following SAS program:
proc sql;
select product, type, sum(sales) as revenue
from one
group by product, type;
quit;
Which one of the following clauses should be added to the program to sort the output by PRODUCT and decreasing REVENUE?
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?