Easter Sale 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Online A00-212 Questions Video

Page: 4 / 7
Total 184 questions

SAS Advanced Programming Questions and Answers

Question 13

The following SAS program is submitted:

%let test=one;

%let one=two;

%let two=three;

%let three=last;

%put what displays is &&&&&test;

What is the written to the SAS log?

Options:

A.

What displays is three

B.

What displays is two

C.

What displays is one

D.

What displays is last

Question 14

The following SAS program is submitted:

data new(bufsize = 6144 bufno = 4);

set old;

run;

What is the difference between the usage of BUFFSIZE= and BUFNO= options?

Options:

A.

BUFSIZE=specifies the size of the output buffer in kilobytes; BUFNO=specifies the number of output buffers

B.

BUFSIZE= specifies the size of the input buffer in bytes; BUFFNO= specifies the number of input buffers

C.

BUFSIZE= specifies the size of the input buffer in kilobytes; BUFNO=specifies the number of input buffers

D.

BUFSIZE= specifies the size of the output buffer in bytes; BUFNO= specifies the number of output buffers

Question 15

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?

Options:

A.

3

B.

4

C.

5

D.

6

Question 16

Given the SAS data sets:

A SAS program is submitted and the following is written to SAS to:

What would allow the program to successfully execute without errors?

Options:

A.

Qualify the column names with the table names.

B.

Replace the 104 with:

Where EMPLOYEE.Name = Any (Select names separated with ‘,’

From WORK.NEWEMPLOYEE

Where Salary > 40000);

C.

Replace the where clause with:

Where EMPLOYEE.Name = (Select Names delimited with ‘,’

From WORK.NEWEMPLOYEE

Where Salary > 40000);

D.

Replace the equal sign with In operator.

Page: 4 / 7
Total 184 questions