A00-202 · Question #4
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…
The correct answer is B. data three;D.data three. See the full explanation below for the reasoning.
Question
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?
Options
- Adata three;C.data three;
- Bdata three;D.data three;
- Cdata three;
- Ddata three;
How the community answered
(33 responses)- A9% (3)
- B82% (27)
- C3% (1)
- D6% (2)
Community Discussion
No community discussion yet for this question.