Labour Day Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Free A00-211 Questions Attempt

Page: 5 / 10
Total 270 questions

SAS Base Programming for SAS (r) 9 Questions and Answers

Question 17

The following SAS program is submitted:

How many observations are written to the WORK.SALES data set?

Options:

A.

0

B.

1

C.

5

D.

60

Question 18

A user-defined format has been created using the FORMAT procedure. Where is it stored?

Options:

A.

in a SAS catalog

B.

in an external binary file

C.

in a SAS dataset in the WORK library

D.

in a SAS dataset in a permanent SAS data library

Question 19

Given the raw data record DEPT:

----|----10---|----20---|----30

Printing 750

The following SAS program is submitted:

data bonus;

infile ‘dept’;

inputdept$ 1-11 number 13- 15;

run;

Which SAS statement completes the program and results in a value of ‘Printing750’ for the DEPARTMENT variable?

Options:

A.

department = dept II number;

B.

department = left(dept) II number;

C.

department = trim(dept) number;

D.

department=trim(dept)||put(number,3.);

Question 20

The following SAS program is submitted:

<_insert_ods_code_>

proc means data=SASUSER.SHOES;

where Product in ('Sandal' , 'Slipper' , 'Boot');

run;

<_insert_ods_code_>

Which ODS statements inserted, respectively, in the two location above creates a report stored in an html file?

Options:

A.

ods html open='sales.html';ods html close;

B.

ods file='sales.html' / html;ods file close;

C.

ods html file='sales.html';ods html close;

D.

ods file html='sales.html';ods file close;

Page: 5 / 10
Total 270 questions