Question 1

Which program contains an error?

Options :

A :

proc print data=stresstest;

label totaltime='Total Duration of Test';

drop sumsec;

run;

B :

data stresstest;

set cert.tests;

TotalTime=(timemin*60)+timesec;

keep id totaltime tolerance;

run;

C :

proc print data=stresstest(keep=totaltime timemin);

label totaltime='Total Duration of Test';

run;

D :

data stresstest(drop=timemin timesec);

set cert.tests;

TotalTime=(timemin*60)+timesec;

SumSec+totaltime;

run;

Answer: A

Question 2

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 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

Unless otherwise directed, how does the DATA step execute?

Options :

A :

once for each compilation phase

B : once for each record in the input file

C :

once for each DATA step statement

D : once for each variable in the input file

Answer: B

Question 5

Which program below creates the following output?

Options :

A :

proc sort data=cert.credit;

by type descending;

run;

B :

proc print data=cert.credit;

by type;

run;

C :

proc sort data=cert.credit;

by type ascending;

run;

D :

proc sort data=cert.credit;

by type;

run;

Answer: D