SAS advanced programming exam (A00-202) Free Practice Test

Question 1

In which one of the following SAS programs is the SAS data set index named CHAR1 always used?

A. data three;
set one;
where char1 in ('new york' 'los angeles');
run;

B. data three;
set one;
if char1 in ('new york' 'los angeles');
run;

C. data three;
set one;
set two key = char1;
run;

D. proc sql;
create table three as
select *
from one, two
where one.char1 > two.char1;
quit;

Correct Answer: C

Question 2

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?

A. COUNTRY
CANADA FRANCE BELGIUM

B. COUNTRY
CANADA FRANCE GERMANY

C. COUNTRY
GERMANY JAPAN

D. COUNTRY
FRANCE BELGIUM

Correct Answer: A

Question 3

Given the following SAS data sets ONE and TWO:
ONE TWO
OBS COMMON X OBS COMMON Y
1 A 10 1 A 1
2 A 13 2 A 3
3 A 14 3 B 4
4 B 9 4 B 2
5 C 8 5 C 5
6 C 14
The following SAS DATA step is submitted: data combine; set one; set two; run; Which one of the following represents the data values stored in data set COMBINE?

A. OBS COMMON X Y
1 A 10 1 2 A 13 3 3 B 14 4 4 B 9 2 5 C 8 5

B. OBS COMMON X Y
1 A 10 1 2 A 13 3 3 B 9 4 4 C 8 5

C. OBS COMMON X Y
1 A 10 1 2 A 13 1 3 A 14 1 4 A 10 3 5 A 13 3 6 A 14 3 7 B 9 4 8 B 9 2 9 C 8 5 10 C 14 5

D. OBS COMMON X Y
1 A 10 1 2 A 13 3 3 A 14 3 4 B 9 4 5 B 9 2 6 C 8 5 7 C 14 5

Correct Answer: A

Question 4

Which one of the following SAS procedures changes a permanent format of a variable stored in a SAS data set?

A. CONTENTS

B. MODIFY

C. FORMAT

D. DATASETS

Correct Answer: D

Question 5

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 in (1, 2) then
b = 'Medium';
else if a = 8 then
b = 'Small';
else if a = 6 then
b = 'Large';
run;

D. 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';

Correct Answer: D

Question 6

The SAS data set ONE contains the variables X, Y, Z, and W.
The following SAS program is submitted:
proc transpose data = one
out = trans
name = new;
by x;
var y;
run;
Which one of the following contains all the names of the columns created by the TRANSPOSE procedure?

A. new, X, Y, and _COL1_

B. X, Y, Z, and W

C. _NAME_, X, and Y

D. new, X, and COL1

Correct Answer: D

Question 7

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);
where 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);
if totrev > 1000;
totcost = sum(fixed,variable);
profit = sum(totrev,otcost);
run;

Correct Answer: D

Question 8

Which one of the following options controls the pagesize of a SAS data set?

A. PAGESIZE=

B. SIZE=

C. BUFNO=

D. BUFSIZE=

Correct Answer: D

Welcome to TestSimulate

SASInstitute SAS advanced programming (A00-202) Free Practice Test