Exit demo A00-202 SAS Advanced Programming PDF format · free preview

SAS Institute A00-202 - Questions & Answers

Free preview · every answer includes a full explanation

Product page: https://prepkeys.com/a00-202.html

Question 1
Single choice

Which of the following statement(s) in the DATASETS procedure alters the name of a SAS data set stored in a SAS data library?

A.

RENAME statement only

B.

CHANGE statement only

C.

MODIFY and RENAME statements

D.

MODIFY and CHANGE statements

Question 2
Single choice

The following SAS program is submitted:

<insert statement here>;
%let development = ontime;
proc print data = sasuser.highway;
title "For &dept";
title2 "This project was completed &development"; run;

Which one of the following statements completes the above and resolves title1 to "For research&development"?

A.

%let dept = %str(research&development);

B.

%let dept = %str(research%&development);

C.

%let dept = %nrstr(research&development);

D.

%let dept = %nrstr(research%&development);

Question 3
Single choice

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

A.

SIZE=

B.

BUFNO=

C.

BUFSIZE=

D.

PAGESIZE=

Question 4
Single choice

Given the following SAS data set ONE:

ONE
REP COST
________________________
SMITH 200
SMITH 400
JONES 100
SMITH 600
JONES 100
JONES 200
JONES 400
SMITH 800
JONES 100
JONES 300

The following SAS program is submitted:
proc sql;
select rep, avg(cost) as AVERAGE from one group by rep
having avg(cost) > (select avg(cost) from one);
quit;

Which one of the following reports is generated?

A.

REP AVERAGE

_______________
JONES 200

B.

REP AVERAGE

_________________
JONES 320

C.

REP AVERAGE

________________
SMITH 320

D.

REP AVERAGE

________________
SMITH 500

Question 5
Single choice

The following SAS program is submitted:

proc sort data = sales tagsort;
by month year;
run;

Which of the following resource(s) is the TAGSORT option reducing?

A.

I/O usage only

B.

CPU usage only

C.

I/O and CPU usage

D.

temporary disk usage

Question 6
Single choice

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 10

B.

any real number between 0 and 1

C.

any integer between 1 and 2,500,000

D.

any real number between 1 and 2,500,000

Question 7
Single choice

Which one of the following programs contains a syntax error?

A.

proc sql;
select product.*, cost.unitcost, sales.quantity
from product p, cost c, sales s where p.item = c.item and

B.

item = s.item;
quit;

C.

proc sql;
select product.*, cost.unitcost, sales.quantity
from product, cost, sales where product.item = cost.item and
product.item = sales.item;
quit;

D.

proc sql;
select p.*, c.unitcost, s.quantity
from product as p, cost as c, sales as s where p.item = c.item and

E.

item = s.item;
quit;

F.

proc sql;
select p.*, c.unitcost, s.quantity
from product, cost, sales where product.item = cost.item and
product.item = sales.item;
quit;

Question 8
Single choice

The following SAS code is submitted:

%macro houses(dsn = houses,sub = RANCH);
data &dsn;
set sasuser.houses;
if style = "&sub";
run;
%mend;
%houses(sub = SPLIT)
%houses(dsn = ranch)
%houses(sub = TWOSTORY)

Which one of the following is the value of the automatic macro variable SYSLAST?

A.

work.ranch

B.

work.houses

C.

WORK.RANCH

D.

WORK.HOUSES

Question 9
Single choice

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
---------------GERMANY
JAPAN

B.

COUNTRY
----------------FRANCE
BELGIUM

C.

COUNTRY
--------------CANADA
FRANCE
BELGIUM

D.

COUNTRY
--------------CANADA
FRANCE
GERMANY

Question 10
Single choice

Which one of the following statements is true?

A.

The WHERE statement can be executed conditionally as part of an IF statement.

B.

The WHERE statement selects observations before they are brought into the PDV.

C.

The subsetting IF statement works on observations before they are read into the PDV.

D.

The WHERE and subsetting IF statements can be used interchangeably in all SAS programs.

Showing 10 of 130 questions · Unlock the full set