• Description: SAS Advanced Programming Exam for SAS 9
• Passing Score: 75%
• Practice Test - Number of questions: 60 questions
• Simulation Test - Number of questions: 60 questions
• Simulation Test Duration: 90 minutes
• Has explanations: No

Given the SAS data sets ONE and TWO: ONE TWO ID NAME ID SALARY --- ------- --- ------------ 112 Smith 243 150000 243 Wei 355 45000 457 Jones 523 75000 The following SAS program is submitted: data combine; merge one two; by id; run; Which SQL procedure program produces the same results?

Answer(s)

1. proc sql;create table combine asselect coalesce(one.id, two.id) as id,name,salaryfrom one full join twoon one.id = two.id;quit;
2. proc sql;create table combine asselect one.id,name,salaryfrom one inner join twoon one.id = two.id;quit;
3. proc sql;create table combine asselect coalesce(one.id, two.id) as id,name,salaryfrom one, twowhere one.id = two.id;quit;
4. proc sql;create table combine asselect one.id,name,salaryfrom one full join twowhere one.id = two.id;quit;

proc sql;create table combine asselect coalesce(one.id, two.id) as id,name,salaryfrom one full join twoon one.id = two.id;quit;