Question

Which code fragment completes the FROM clause in this PROC SQL step?

proc sql;
select x.Policy,
Claim_Num,
Status
from ___
insurance.accounts x
where x.Policy =
y.Policy;
quit;
a. x
b. x,
c. y
d. y,
e. c

Answer 1

To complete the FROM clause in the PROC SQL step, the correct answer is 'd. y,' which represents joining 'insurance.accounts' (aliased as 'x') with a second table (aliated as 'y') on the 'Policy' column.

Step-by-step explanation:

The question is asking to complete the FROM clause in a PROC SQL step used within SAS programming. The 'x' and 'y' are aliases for tables from which data will be selected. The code fragment should allow us to select records from table 'x' that have a matching 'Policy' in table 'y'.

Given that alias 'x' is already defined in the SELECT statement ('insurance.accounts x'), we need to specify the other table to join with 'x' on the condition 'x.Policy = y.Policy'. Therefore, the correct answer is 'd. y,' This implies that we are joining two tables, 'insurance.accounts' (with alias 'x') and an unspecified table (presumed to be 'y') on the common column 'Policy'.