Question 1

Which SAS statement associates the fileref Crime with the raw data file C:\States \Data\crime.dat?

Options :

A :

filename 'c:\states\data\crime' crime.dat;

B : fileref crime 'c:\states\data\crime.dat';

C : filename crime c:\states\data\crime.dat;

D : filename crime 'c:\states\data\crime.dat';

Answer: D

Question 2

At the beginning of the execution phase, the value of _N_ is 1, the value of _ERROR_ is 0, and the values of the remaining variables are set to the following:

Options :

A :

1

B : 0

C : undefined

D : missing

Answer: D

Question 3

What happens if you merge the following data sets by the variable SSN?

Options :

A : The values of Age in the data set 2nd are set to missing.

B :

The values of Age in the data set 1st overwrite the values of Age in the data set 2nd.

C : The DATA step fails because the two data sets contain same-named variables that have different values.

D :

The values of Age in the data set 2nd overwrite the values of Age in the data set 1st.

Answer: D

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

What is the minimum width of the TIMEw. informat?

Options :

A : 7

B : 6

C : 4

D : 5

Answer: D

Higher Test Marks with Free Online A00-231 Exam Practice

Buying Options: