A00-215 Exam Dumps : SAS Certified Associate: Programming Fundamentals Using SAS 9.4

The correct answer is A. The SET statement in SAS is used within a DATA step to specify which existing SAS dataset is to be read. This statement is used to read in data from an existing SAS dataset to be processed in the current DATA step. The SET statement does not specify an output data set; that is determined by the name specified in the DATA statement.

Options B, C, and D are incorrect because:

• B and C are incorrect as the SET statement is not used in the PROC SORT step at all.
• D is incorrect because the SET statement specifies the input dataset, not the output dataset, in the DATA step.

References:

• SAS 9.4 Language Reference: Concepts, "DATA Step Processing"
• SAS documentation on the SET statement.

The FORMAT statement in the DATA step assigns formats to variables for the SAS dataset being created. In the code provided, MSRP is given the dollar12. format and Invoice is given the dollar10. format. However, during the PROC PRINT step, MSRP is reassigned to the comma12.2 format. The format specified in the most recent PROC step or DATA step that executes is the one that is used in the output.

Therefore, the format for MSRP in the PROC PRINT output will be comma12.2, making the answer: B. Comma12.2

References:

• SAS documentation on PROC PRINT and FORMAT statement, SAS Institute.