Pass with professional A00-202 actual quiz materials

SASInstitute A00-202 Exam Overview:

SASInstitute A00-202 Exam Syllabus Topics:

SASInstitute SAS advanced programming Sample Questions:

1. 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?

A) 5
B) 2
C) 0
D) 1

2. The following SAS program is submitted:
options yearcutoff = 1950;
%macro y2kopt(date);
%if &date >= 14610 %then %do;
options yearcutoff = 2000;
%end;
%else %do;
options yearcutoff = 1900;
%end; %mend;
data _null_ ;
date = "01jan2000"d;
call symput("date",left(date));
run;
%y2kopt(&date)
The SAS date for January 1, 2000 is 14610 and the SAS system option for YEARCUTOFF is set to 1920 prior to submitting the above program.
Which one of the following is the value of YEARCUTOFF when the macro finishes execution?

A) 1920
B) 1900
C) 2000
D) 1950

3. 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);
if totrev > 1000;
totcost = sum(fixed,variable);
profit = sum(totrev,otcost);
run;
B) data two;
set one;
totrev = sum(price * quantity);
totcost = sum(fixed,variable);
profit = sum(totrev,otcost);
if totrev > 1000;
run;
C) data two;
set one;
where totrev > 1000;
totrev = sum(price * quantity);
totcost = sum(fixed,variable);
profit = sum(totrev,otcost);
run;
D) data two;
set one;
totrev = sum(price * quantity);
where totrev > 1000;
totcost = sum(fixed,variable);
profit = sum(totrev,otcost);
run;

4. 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 2,500,000
B) any integer between 1 and 10
C) any real number between 0 and 1
D) any real number between 1 and 2,500,000

5. The variable attributes of SAS data sets ONE and TWO are shown below:
ONE TWO # Variable Type Len Pos # Variable Type Len Pos 2 sales Num 8 8 2 budget Num 8 8 1 year Num 8 0 3 sales Char 8 16
1 year Num 8 0
Data set ONE contains 100 observations. Data set TWO contains 50 observations. Both data sets are sorted by the variable YEAR.
The following SAS program is submitted:
data three; merge one two; by year;
run;
Which one of the following is the result of the program execution?

A) Data set THREE is created with two variables and 50 observations.
B) Data set THREE is created with three variables and 100 observations.
C) No messages are written to the SAS log.
D) ERROR and WARNING messages are written to the SAS log.

Solutions: