A00-212 Online Practice Questions and Answers

When is it appropriate to create indexes on a SAS data set for efficient processing?

A. if small subsets of data are often retrieved

B. if the key variable has very few unique values

C. if the data are often used for BY group processing

D. if the SAS data set file page count is less than three pages

The following SAS program is submitted:

%let value = 9;

%let value2 = 5;

%let newval = %eval(andvalue / andvalue2);

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

A. 1

B. 2

C. 1.8

D. null

Given the following SAS program:

What will be the output from the PRINT Procedure?

A. Option A

B. Option B

C. Option C

D. Option D

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.

The following SAS program is submitted: % let product = merchandise;

And the following message is written to the SAS log: The value is "merchandise"

Which macro statement wrote this message?

A. % put the value is "andproduct.";

B. % put the value is ""andproduct."";

C. % put the value is "%quote(andproduct).";

D. % put the value is ` " `andproduct. ` " ` ;

Given the following SAS data set ONE:

ONE

CATEGORY AGE SALARY BONUS

M 28 200 20

M 25 100 10

M 28 300 10

M 33 300 30

F 18 100 50

F 25 200 10

F 35 400 50

The following SQL program is submitted:

proc sql;

create table two as

select distinct age

from one

where age < 33;

quit;

How many rows are written to the SAS data set TWO?

A. 3

B. 4

C. 5

D. 6

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

The following SAS program is submitted: %micro cols1;

name age;

%mend;

%macro cols2;

height weight

%mend

proc print data=sashelp.class;

Run

Which VAR statement successfully completes the program and produces a report?

A. var heigh %cols1;

B. var %cols1 %cols2 height;

C. var %cols1 height;

D. var %cols2 %cols1;

What is an advantage of using a hash object in a SAS DATA step?

A. The hash object persists after the DATA step has executed

B. The hash object key values can be multiple numeric and character data values

C. The hash object automatically sorts the data

D. The hash object does not require unique keys

The following SAS program is submitted:

proc contents data = testdata.one;

run;

Which SQL procedure program produces similar information about the column attributes of the dataset TESTDATA.ONE?

A. proc sql; Contents table testdata.one; Quit;

B. proc sql; Describe table testdata.one; Quit;

C. proc sql; describe testdata.one; Quit;

D. proc sql; Contents testdata.one; Quit;