Confidently Practice Online with Free A00-231 Exam Cram

Practice your SAS 9.4 Base Programming -- Performance-based certification test with free A00-231 exam cram and take control of your certification preparation. At FreeExamCram, you can practice online for free using real A00-231 exam dumps, verified questions, and expert-designed free online practice tests. Moreover our SAS Institute A00-231 exam cram backed by our confidence-boosting refund guarantee.

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

Which of the following statements store your formats in a permanent catalog?

Options :

A :

formtlib='C:\\Users\\Student1\\sas\\formats\\lib';

proc format formtlib ...;

B :

formtlib='C:\\Users\\Student1\\sas\\formats\\lib';

proc formtlib ...;

C :

libname formtlib 'C:\Users\Student1\sas\formats\lib';

proc format lib=formtlib ...;

D :

libname formtlib 'C:\Users\Student1\sas\formats\lib';

format lib=formtlib ...;

Answer: C

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