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

Option C is correct. The set statement is used within a DATA step to read an existing SAS data set. In this case, set sashelp.shoes; reads the SASHELP.SHOES data set, and data work.total; specifies the creation of a new data set named TOTAL in the WORK library. The options A, B, and D are incorrect because they either use the wrong syntax or are not proper statements for reading an input data set and creating an output data set.

References:

• SAS 9.4 documentation on the DATA step.

In SAS, when you use a BY statement in a DATA step, SAS creates two temporary variables for each variable listed in the BY statement: one to indicate the first occurrence (FIRST.variable) and another to indicate the last occurrence (LAST.variable) of the value within the BY-group. Given the provided code and assuming that State is the variable used in the BY statement, SAS will create First.State and Last.State. Thus, option A is correct.

References:

• SAS documentation on the BY statement, SAS Institute.