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 ODS HTML option was used in creating the following table? (pic)

Options :

A : format=MeadowPrinter

B : format='MedowPrinter'

C : style='MeadowPrinter'

D : style=MeadowPrinter

Answer: D

Question 3

Select the DO WHILE statement that would generate the same result as the program below.

data work.invest;

capital=100000;

do until(Capital gt 500000);

Year+1;

capital+(capital*.10);

end;

run;

Options :

A : do while(Capital>500000);

B : do while(Capital ge 500000);

C : do while(Capital le 500000);

D : do while(Capital=500000);

Answer: C

Question 4

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

Question 5

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