A00-202 Online Practice Questions and Answers

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

A. SIZE=

B. BUFNO=

C. BUFSIZE=

D. PAGESIZE=

The SAS data set ONE has a variable X on which an index has been created. The data sets ONE and THREE are sorted by X. Which one of the following SAS programs uses the index to select observations from the data set ONE?

A. data two; set three; set one key = X; run;

B. data two; set three key = X; set one; run;

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

D. data two; set three; set one (key = X); run;

The following SAS program is submitted:

%macro test(var);

%let jobs = BLACKSMITH WORDSMITH SWORDSMITH;

%let type = %index(andjobs,andvar);

%mend;

%test(SMITH)

Which one of the following is the resulting value of the macro variable TYPE?

A. 0

B. 3

C. 6

D. null

The following SAS program is submitted:

options yearcutoff = 1950;

%macro y2kopt(date);

%if anddate >= 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(anddate)

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. 1900

B. 1920

C. 1950

D. 2000

Which one of the following displays the definition of a stored SQL procedure view in the SAS log?

A. ECHOVIEW option

B. EXPANDVIEW option

C. VALIDATE VIEW statement

D. DESCRIBE VIEW statement

The following are values of the variable STYLE from the SAS data set SASUSER.HOUSES: SASUSERS.HOUSES

OBS STYLE

1 RANCH

2 SPLIT

3 CONDO

4 TWOSTORY

5 RANCH

6 SPLIT

7 SPLIT

The following SAS program is submitted:

proc sql noprint;

select distinct style

into :styles separated by ' '

from sasuser.houses

order by style;

quit;

Which one of the following is the value of the resulting macro variable?

A. CONDO RANCH SPLIT TWOSTORY

B. RANCH SPLIT CONDO TWOSTORY

C. CONDO RANCH RANCH SPLIT SPLIT SPLIT TWOSTORY

D. RANCH SPLIT CONDO TWOSTORY RANCH SPLIT SPLIT

The following SAS program is submitted:

proc sql;

select *

from dictionary.tables;

quit;

Which one of the following is reported?

A. metadata on all tables in all libraries

B. metadata on all tables in the WORK library only

C. metadata on all tables in the SASUSER library only

D. metadata on all tables in the DICTIONARY library only

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 500 .

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

Which one of the following is the purpose of the REUSE= YES option in a compressed SAS data set?

A. It temporarily compresses observations in a SAS data set.

B. It allows users to update the same SAS data set concurrently.

C. It allows new observations to be inserted wherever enough free space exists.

D. It specifies that a new empty data set with a given name replaces an existing data set with the same name.