Question 1

Suppose you do not specify the LIBRARY= option and your formats are stored in Work.Formats. How long do they exist?

Options :

A : only for the current procedure

B : only for the current SAS session

C : permanently

D : only for the current DATA step

Answer: B

Question 2

What types of errors can the PUTLOG statement help you resolve?

Options :

A : syntax errors

B : all of the above

C : logic errors

D :

semantic errors

Answer: C

Question 3

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 4

In the data set Work.Invest, what would be the stored value for Year?

data work.invest;

do year=1990 to 2004;

Capital+5000;

capital+(capital*.10);

end;

run;

Options :

A : missing

B : 1990

C : 2005

D : 2004

Answer: C

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