SAS BASE Q88. merge & in

QUESTION NO: 88

Given the SAS data set WORK.EMP_NAME: Name EmpID

Jill 1864 

Jack 2121 

Joan 4698 

John 5463

Given the SAS data set WORK.EMP_DEPT: EmpID Department

2121 Accounting

3567 Finance

4698 Marketing

5463 Accounting

 

The following program is submitted:

data WORK.ALL;

merge WORK.EMP_NAME(in=Emp_N)

WORK.EMP_DEPT(in=Emp_D);

by Empid;

if (Emp_N and not Emp_D) or (Emp_D and not Emp_N);

run;

 

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

 

A. 1

B. 2

C. 3

D. 5

 

 

Answer: B

 

# 문제 풀이

 - merge문의 결과이다.

 - (Emp_N and not Emp_D) or (Emp_D and not Emp_N) = (Emp_N=1 and Emp_D=0) or (Emp_D=1 and Emp_N=0)

  - 이에 해당하는 변수는 2개이다.