Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
exam questions

Exam A00-211 All Questions

View all questions & answers for the A00-211 exam

Exam A00-211 topic 1 question 88 discussion

Actual exam question from SAS Institute's A00-211
Question #: 88
Topic #: 1
[All A00-211 Questions]

Given the SAS data set WORK.EMP_NAME:

Given the SAS data set WORK.EMP_DEPT:

The following program is submitted:

How many observations are in data set WORK.ALL after submitting the program?

  • A. 1
  • B. 2
  • C. 3
  • D. 5
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
mhminkov
3 years, 5 months ago
yes, B, .. the if statement selects the two observations, which do not contribute fully to the merge (s. code below). data emp_name; infile datalines; input name $ empid; datalines; Jill 1864 Jack 2121 Joan 4698 John 5463 ; data emp_dept; infile datalines; input empid department $; datalines; 2121 Acc 3567 Fin 4698 Mar 5463 Acc ; data all; merge emp_name (in=emp_n) emp_dept (in=emp_d); by empid; if (emp_n and not emp_d) or (emp_d and not emp_n); run;
upvoted 1 times
...
Kleinstone
3 years, 10 months ago
Yes. B is correct since there is 'or' between two conditions.
upvoted 1 times
...
Kleinstone
3 years, 10 months ago
if not A and not B the answer is 2, otherwise, the answer should be 1.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...