Examice

Exam A00-212 All QuestionsBrowse all questions from this exam

Go to Exam

Question 2

Given the SAS data sets ONE and TWO:

The following SAS program is submitted:

Data combine;

Merge one two;

By id;

Run;

Which SQL procedure program procedures the same results?

proc sql; Create table combine as Select coalesce (one.id, two.id) as id, Name,salary from one, two where one.id=two.id; Quit;

proc sql; Create table combine as Select one.id, Name, salary from one full join two where one.id=two.id; Quit

proc sql; Create table combine as Select one.id,name,salary from one inner join two on one.id=two.id Quit

proc sql; Create table combine as Select coalesce (one id, two id) as id, Name,salary from one full join two on one.id=two.id;

Correct Answer: C

The provided SAS program merges the data sets ONE and TWO by the common variable ID, effectively performing an inner join. The correct SQL procedure to match this result is an inner join, which combines rows from both tables where the joining condition is met. Therefore, the SQL equivalent to the SAS merge command, ensuring that only matching IDs are included in the result, is the SQL inner join. This matches the description provided in option C.

Discussion

SugarlipsOption: A

answer is A

mhminkovOption: D

given answer is D correct, s. test code below data ONE; infile datalines; input ID NAME $; datalines; 112 Smith 243 Wei 457 Jones ; data TWO; infile datalines; input ID SALARY; datalines; 213 150000 355 45000 523 75000 ; data combine; merge one two; by id; run; /* proc sql; Create table combine as Select coalesce (one.id, two.id) as id, Name,salary from one, two where one.id=two.id; Quit; proc sql; Create table combine as Select one.id, Name, salary from one full join two where one.id=two.id; Quit; proc sql; Create table combine as Select one.id,name,salary from one inner join two on one.id=two.id; Quit; */ proc sql; Create table combinesql as Select coalesce (one.id, two.id) as id, Name,salary from one full join two on one.id=two.id; Quit;