Question

Which code fragment correctly completes the WHERE clause in this PROC SQL step joining the two tables by Policy?

proc sql;
select claims.Policy,
Claim_Num,
Dependents
from
insurance.accounts
where _______________=
_______________;
quit;
a. Policy=Policy
b. claims.Policy=accounts.Policy
c. claims.Policy=insurance.Policy
d. insurance.Policy=insurance.Policy

Answer 1

The correct code fragment to join two tables by the Policy column in a PROC SQL step is 'claims.Policy=accounts.Policy', thereby creating a relationship between Policy fields of the claims and accounts tables within the insurance database context.

Step-by-step explanation:

The student is asking about constructing a correct SQL query to join two tables based on a common column, Policy, in a SAS PROC SQL step. The correct code fragment to complete the WHERE clause in the given PROC SQL step is claims.Policy=accounts.Policy. This is because it specifies the relationship between the Policy field of the claims table and the Policy field of the accounts table within the insurance database context. Therefore, the full SQL command would be:

proc sql;
select claims.Policy, Claim_Num, Dependents
from insurance.claims, insurance.accounts
where claims.Policy=accounts.Policy;
quit;