A00-202 Online Practice Questions and Answers

The following SAS program is submitted:

;

%let development = ontime;

proc print data = sasuser.highway;

title "For anddept";

title2 "This project was completed anddevelopment"; run;

Which one of the following statements completes the above and resolves title1 to "For researchanddevelopment"?

A. %let dept = %str(researchanddevelopment);

B. %let dept = %str(research%anddevelopment);

C. %let dept = %nrstr(researchanddevelopment);

D. %let dept = %nrstr(research%anddevelopment);

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;

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.

Which one of the following is the purpose of the IDXNAME= data set option?

A. It instructs SAS to name and store a specific index.

B. It instructs SAS to store an index in a particular location.

C. It instructs SAS to use a specific index for WHERE processing.

D. It instructs SAS to use any available index for WHERE processing.

The following SAS program is submitted:

data two;

y = '2';

run;

%let x = 10;

%let var = y;

data one;

set two (keep = andvar);

z = andvar * andx;

run;

Which one of the following is the value of the variable Z when the program finishes execution?

A. _ERROR_

B. 20 (as a numeric)

C. 20 (as a character)

D. . (missing numeric)

Given the following SAS data sets ONE and TWO:

ONE TWO

YEAR QTR BUDGET YEAR QTR SALES

----------------------------- ------------------------------ 2001 3 500 2001 4 300

2001 4 400 2002 1 600

2002 1 700

The following SAS program is submitted:

proc sql;

select one.*, sales

from one left join two

on one.year = two.year;

quit;

Which one of the following reports is generated?

A. YEAR QTR BUDGET SALES

2001 3 500 .

B. YEAR QTR BUDGET SALES

2001 4 400 300

2002 1 700 600

C. YEAR QTR BUDGET SALES

2001 3 50 .

2001 4 400 300

2002 1 700 600

D. YEAR QTR BUDGET SALES

2001 3 500 300

2001 4 400 300

2002 1 700 600

Given the following SAS data set ONE:

ONE JOB LEVEL SALARY ACC 2 300 SEC 1 100 SEC 2 200 MGR 3 700 ACC 1 . ACC 3 . MGR 2 400

The following SAS data set TWO is created:

TWO JOB LEVEL BONUS

ACC 2 30 MGR 3 70 MGR 2 40

Which one of the following SAS programs creates data set TWO?

A. proc sql; create table two as select job, level, salary * 0.1 as bonus from one where bonus > 20; quit;

B. proc sql; create table two as select job, level, salary * 0.1 as bonus from one where salary > 20; quit;

C. proc sql; create table two as select job, level, salary * 0.1 as bonus from one where calculated salary * 0.1 > 20; quit;

D. proc sql;D.proc sql; create table two as select job, level, salary * 0.1 as bonus from one where calculated bonus > 20; quit;

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;

Given the following SAS data sets ONE and TWO:

ONE TWO NUM CHAR1 NUM CHAR2

1 A1 2 X1

1 A2 2 X2

2 B1 3 Y

2 B2 5 V

4 D

The following SAS program is submitted creating the output table THREE:

proc sql;

create table three as

select one.num, char1, char2

from one, two

where one.num = two.num;

quit;

THREE

NUM CHAR1 CHAR2

2 B1 X1 2 B1 X2 2 B2 X1 2 B2 X2

Which one of the following DATA step programs creates an equivalent SAS data set THREE?

A. data three; merge one two; by num; run;

B. data three; set one; set two; by num; run;

C. data three;C.data three; merge one (in = in1) two (in = in2); by num;

if in1 and in2;

run;

D. data three;D.data three; set one; do i = 1 to numobs; set two(rename = (num = num2)) point = i nobs = numobs; if num2 = num then output; end; drop num2; run;

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 = andnumgrp;

select distinct status

into :group1-:groupandnumgrp

from sasuser.highway;

quit;

%do i = 1 %to andnumgrp;

proc print data = sasuser.highway;

where status = "andandgroupandi" ;

run;

%end;

%mend;

%highway

How many reports are produced by the above program?

A. 0

B. 1

C. 2

D. 5D.5