Question 1

Which of the following statements can you use in a PROC PRINT step to create this output?

Options :

A :

var month instructors;

sum instructors aerclass walkjogrun swim;

B :

var month;

sum instructors aerclass walkjogrun swim;

C : all of the above

D :

var month instructors aerclass;

sum instructors aerclass walkjogrun swim;

Answer: B

Question 2

When you create a format with the VALUE statement, the new format's name cannot end with a number, cannot end with a period, and cannot be the name of a SAS format. Which of the following is also true?

Options :

A : The name must begin with a dollar sign ($) if used with a character variable.

B : The name must be at least two characters long.

C : The name cannot be the name of a data set variable.

D : The name must be at least eight characters long.

Answer: A

Question 3

Assume that Sasuser.One does not exist and that the following SAS program is submitted at the beginning of a new SAS session: data sasuser.one; x=1; y=27; output one; run; Select one:

Options :

A : The data set Sasuser.One is created with 2 variables and 3 observations.

B : The data set Sasuser.One is created with 2 variables and 0 observations.

C : The data set Work.One is created with 2 variables and 1 observation.

D : The data set Sasuser.One is created with 2 variables and 1 observation.

Answer: B

Question 4

Because of the growth within the 919 area code, the telephone exchange 555 is being reassigned to the 920 area code. The data set Clients.Piedmont includes the variable Phone, which contains telephone numbers in the form 919-555-1234. Which of the following programs correctly changes the values of Phone?

Options :

A :

data work.piedmont(drop=areacode exchange);

set cert.piedmont;

Areacode=substr(phone,1,3);

Exchange=substr(phone,5,3);

if areacode='919' and exchange='555' then phone=scan('920',1,3);

run;

B :

data work.piedmont(drop=areacode exchange);

set cert.piedmont;

Areacode=substr(phone,1,3);

Exchange=substr(phone,5,3);

if areacode='919' and exchange='555' then scan(phone,1,3)='920';

run;

C :

data work.piedmont(drop=areacode exchange);

set cert.piedmont;

Areacode=substr(phone,1,3);

Exchange=substr(phone,5,3);

if areacode='919' and exchange='555' then phone=substr('920',1,3);

run;

D :

data work.piedmont(drop=areacode exchange);

set cert.piedmont;

Areacode=substr(phone,1,3);

Exchange=substr(phone,5,3);

if areacode='919' and exchange='555' then substr(phone,1,3)='920';

run;

Answer: D

Question 5

If you submit the following program, which output does it create?

proc sort data=cert.loans out=work.loans;

by months amount;

run;

proc print data=work.loans noobs;

var months amount payment;

sum amount payment;

where months<360;

run;

Options :

A :

B :

C :

D :

Answer: D

Confidently Practice Online with Free A00-231 Exam Cram

Buying Options: