• Description: A00-202 SAS Advanced Programming
• Passing Score: 75%
• Practice Test - Number of questions: 73 questions
• Simulation Test - Number of questions: 73 questions
• Simulation Test Duration: 41 minutes
• Has explanations: No

Given the following SAS data sets ONE and TWO: ONE TWO NUM CHAR1 NUM CHAR2 ------------------ ------------------------ 1 A1 2 X1 1 A2 2 X2 2 B1 3 Y 2 B2 5 V 4 D The following SAS program is submitted creating the output table THREE: proc sql; create table three as select one.num, char1, char2 from one, two where one.num = two.num; quit; THREE NUM CHAR1 CHAR2 ------------------------------------- 2 B1 X1 2 B1 X2 2 B2 X1 2 B2 X2 Which one of the following DATA step programs creates an equivalent SAS data set THREE?

Answer(s)

1. data three; merge one two; by num; run;
2. data three; set one; set two; by num; run; merge one two; by num; run;
3. data three; set one; set two; by num; run; by num; run;
4. data three; set one; do i = 1 to numobs; set two(rename = (num = num2)) point = i nobs = numobs; if num2 = num then output; end; drop num2; run;

data three; set one; do i = 1 to numobs; set two(rename = (num = num2)) point = i nobs = numobs; if num2 = num then output; end; drop num2; run;