SAS Exam A00-231 Topic 3 Question 7 Discussion

Actual exam question for SAS's A00-231 exam

Question #: 7
Topic #: 3

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?

AThe RESULTS Data Set nameDeptage TomEngineering36 SallyHR42 Davidengineering30 Mary27

BThe RESULTS Data Set nameDeptage TomEngineering36 SallyHR42 Davidengineering30 Maryengineering27

CThe RESULTS Data Set nameDeptage TomEngineering36 SallyHR42 Davidengineering30

DThe RESULTS Data Set nameDeptage Mary27 TomEngineering36 SallyHR42 Davidengineering30

Show Suggested Answer

Suggested Answer: A

by Santos at May 05, 2025, 10:10 AM

Limited Time Offer

25%

Off

Get Premium A00-231 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Stephaine

5 days ago

I agree with Bonita, A seems to be the most logical choice.

upvoted 0 times

...

Ivette

8 days ago

I'm not sure, but I think C makes more sense.

upvoted 0 times

...

Inocencia

9 days ago

Option B is the clear winner here. The SAS code is straightforward, and the output should include all the records from both the EMPLOYEE and NEW_EMPS data sets.

upvoted 0 times

...

Christa

11 days ago

Haha, I bet the exam writer had a good laugh coming up with these answer choices. B is definitely the way to go, though. Gotta love that data set merging!

upvoted 0 times

Henriette

2 days ago

Haha, yeah those answer choices are tricky. I think B is the correct one too!

upvoted 0 times

...

Marvel

17 days ago

I think the answer is B. The PROC PRINT statement will output the entire data set, including all the variables and observations.

upvoted 0 times

Jeff

8 days ago

User 1

upvoted 0 times

...

Cruz

1 months ago

I disagree, I believe the correct answer is B.

upvoted 0 times

...

Bonita

1 months ago

I think the answer is A.

upvoted 0 times

...

Darnell

1 months ago

The correct answer is B. The DATA step merges the WORK.EMPLOYEE and WORK.NEW_EMPS data sets, so the resulting data set should include all the records from both data sets.

upvoted 0 times

Dyan

13 days ago

That makes sense, thanks for clarifying.

upvoted 0 times

...

Hoa

17 days ago

Yes, because the code merges the two data sets.

upvoted 0 times

...

Janna

30 days ago

I think the correct answer is B.

upvoted 0 times

...