Which statement is true regarding a DATA step concatenation?
A.
Columns with the same name must be renamed.
B.
The length of variables is determined from the first data set listed on the SET statement.
C.
A DATA step concatenation can contain a maximum of two tables on the same SET statement.
D.
A DATA step concatenation combines the data horizontally.
The Answer Is:
B
This question includes an explanation.
Explanation:
In a DATA step concatenation in SAS, when multiple datasets are listed in a SET statement, SAS concatenates the datasets vertically, stacking them one on top of the other. The length of variables in the resulting dataset is determined by the first dataset that appears in the SET statement. If the same variable appears in multiple datasets, SAS uses the length as it is first encountered. It does not require columns with the same name to be renamed; rather, it stacks them directly. There is no maximum number of tables that can be listed in a SET statement for concatenation; more than two can be concatenated. Lastly, concatenation combines data vertically, not horizontally as option D suggests.
References
SAS 9.4 Language Reference: Concepts, "Concatenating Data Sets."
A00-215 PDF/Engine
Printable Format
Value of Money
100% Pass Assurance
Verified Answers
Researched by Industry Experts
Based on Real Exams Scenarios
100% Real Questions
Get 65% Discount on All Products,
Use Coupon: "ac4s65"