Question 1

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 2

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

Question 3

What is the minimum width of the TIMEw. informat?

Options :

A : 7

B : 6

C : 4

D : 5

Answer: D

Question 4

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

Higher Test Marks with Free Online A00-231 Exam Practice

Buying Options: