Question 1

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 2

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 3

Suppose the format JOBFMT was created in a FORMAT procedure. Which FORMAT statement applies it to the variable JobTitle in the program output?

Options :

A : format jobtitle jobfmt.;

B : format jobtitle='jobfmt';

C : format jobtitle=jobfmt;

D : format jobtitle jobfmt;

Answer: A

Question 4

What type of variable is the variable Wear based on the justification of the text in the data set below?

Options :

A : character

B :

cannot tell from the data shown

C : numeric

D : can be either character or numeric

Answer: C

Question 5

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