A00-212 Online Practice Questions and Answers

Given the SAS data sets ONE and TWO:

The following SAS program is submitted:

Proc sql;

Select two.*,budget from one two on one.year=two.year,

Quit;

The following output is desired:

Which JOIN operator completes the program and generates the desired output?

A. FULL JOIN

B. INNER JOIN

C. LEFT JOIN

D. RIGHT JOIN

What is generated as a result of submitting the RANUNI function with a seed of 123?

A. A missing value because 123 is an invalid argument for the RANUNI function

B. A different sequence of random numbers with each program execution

C. A random number between 0 and 123

D. A consistent sequence of random numbers with each program execution

Given the SAS data set SAUSER.HIGWAY: SASUSER.HIGHWAY

The following SAS program is submitted:

%macro highway;

proc sql nonprint;

%let numgrp=6;

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?

A. 2

B. 6

C. 0

D. 5

Given the following SAS data set ONE:

ONE

GROUP SUM

A 765

B 123

C 564

The following SAS program is submitted:

data _null_;

set one;

call symput(group,sum);

run;

Which one of the following is the result when the program finishes execution?

A. Macro variable C has a value of 564.

B. Macro variable C has a value of 1452.

C. Macro variable GROUP has a value of 564.

D. Macro variable GROUP has a value of 1452.

Which one of the following SAS programs displays the descriptor portion of each data set stored in the SASUSER library?

A. proc datasets lib = sasuser.all; quit;

B. proc datasets lib = sasuser._all_; quit;

C. proc datasets lib = sasuser; contents data = all; quit;

D. proc datasets lib = sasuser; contents data = _all_; quit;

The SAS data set WORK.TEMP is indexed on variable Id:

The following SAS program is submitted:

A. Stops because the data is not descending order

B. Generates a report without a problem

C. Stops because the data is not in ascending order

D. Generates a report, but only if the index = USE option is turned on

Given the SAS data sets: The following SAS program is submitted:

What output is produced?

A. Name

Charlie

Omar

B. Name

Omar

Nguyen

C. Name

Charlie

Nguyen

Nguyen

D. Name

Charlie

Omar

Nguyen

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, two;

quit;

Which one of the following reports is generated?

A. YEAR QTR BUDGET SALES 2001 4 400 300 2002 1 700 600

B. YEAR QTR BUDGET SALES 2001 3 500 2001 4 400 300 2002 1 700 600

C. YEAR QTR BUDGET SALES 2001 3 500 300 2001 4 400 300 2002 1 700 600

D. YEAR QTR BUDGET SALES 2001 3 500 300 2001 4 400 300 2002 1 700 300 2001 3 500 600 2001 4 400 600 2002 1 700 600

Consider the following SAS log:

229 data sasuser.ranch sasuser.condo / view = sasuser.ranch;

230 set sasuser.houses;

231 if style = 'RANCH' then output sasuser.ranch;

232 else if style = 'CONDO' then output sasuser.condo;

233 run;

NOTE: DATA STEP view saved on file SASUSER.RANCH.

NOTE: A stored DATA STEP view cannot run under a different operating system.

235 proc print data = sasuser.condo;

ERROR: File SASUSER.CONDO.DATA does not exist.

236 run;

NOTE: The SAS System stopped processing this step because of errors.

Which one of the following explains why the PRINT procedure fails?

A. SASUSER.CONDO is a stored DATA step program.

B. A SAS data file and SAS data view cannot be created in the same DATA step.

C. A second VIEW=SASUSER.CONDO option was omitted on the DATA statement.

D. The view SASUSER.RANCH must be processed before SASUSER.CONDO is created.

The following SAS program is submitted:

data new (bufnp=4);

set old(bufno=4);

run;

Why are the BUFNO options used?

A. To reduce the number I/O operations

B. To reduce network traffic

C. To reduce memory usage

D. To reduce the amount of data read