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

Scenario:

The following code is submitted: data WORK.FINAL_EMPS; set WORK.EMPLOYEE WORK.NEW_EMPS; run; proc print data=WORK.FINAL_EMPS; title 'The RESULTS Data Set'; run; What is the resulting data set?

Options :

A : The RESULTS Data Set nameDeptage TomEngineering36 SallyHR42 Davidengineering30 Mary27

B :

The RESULTS Data Set nameDeptage TomEngineering36 SallyHR42 Davidengineering30 Maryengineering27

C : The RESULTS Data Set nameDeptage TomEngineering36 SallyHR42 Davidengineering30

D : The RESULTS Data Set nameDeptage Mary27 TomEngineering36 SallyHR42 Davidengineering30

Answer: A

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

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

Question 5

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