Câu 14: A00-212: SAS Advanced Programming for SAS 9

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?

1. A. 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;
2. B. proc sql; Create table combine as Select one.id, Name, salary from one full join two where one.id=two.id; Quit
3. C. proc sql; Create table combine as Select one.id,name,salary from one inner join two on one.id=two.id Quit
4. D. 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; — đáp án hiện tại