FILL BLANK
-
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?
Enter your numeric answer in the space below.
Exam A00-211 All QuestionsBrowse all questions from this exam
Question 60
Correct Answer:
After merging the datasets WORK.EMP_NAME and WORK.EMP_DEPT by EmpID, the program evaluates a conditional statement that only includes observations where Emp_N is true and Emp_D is false, or Emp_N is false and Emp_D is true. Emp_N is true for all records in WORK.EMP_NAME, and Emp_D is true for all records in WORK.EMP_DEPT. This means that the conditional statement filters for records that exist in only one dataset but not both. Observations that are unique to WORK.EMP_NAME are for EmpID 1864, and those unique to WORK.EMP_DEPT are for EmpID 3567. Therefore, there are exactly 2 observations in WORK.ALL after submitting the program.
Discussion
DEAWS
Condition Or is their so : 1+1 = 2