A00-215 SAS Institute Exam Lab Questions

In the provided image of the SAS code for the PROC PRINT step, the following statements are present:

• proc print data=sashelp.cars; - PROC PRINT step beginning
• var Make Model MSRP MPG_City MPG_Highway Horsepower Weight; - VAR statement to specify variables to print
• format Weight comma8.; - FORMAT statement to apply a format to a variable
• The final run; statement which would be necessary to execute the PROC PRINT step is not visible in the image, but it can be inferred to be there since every PROC step must be ended with a run; or quit; statement.

Thus, there are four statements related to the PROC PRINT step.

References:

• SAS 9.4 Language Reference: Concepts, "PROC PRINT"
• SAS documentation on "VAR Statement" and "FORMAT Statement"

The DROP statement during the compilation phase of the DATA step flags variables in the Program Data Vector (PDV) to be dropped when the data set is output. This means that although the variables exist in the PDV during the DATA step execution, they will not be written to the output data set. The DROP statement does not affect the order of variables (which is the purpose of the ORDER= data set option), nor does it remove variables from the input data set or prevent them from being created in the PDV.

References:

• SAS documentation on the DROP statement.

To create SAS date values, the correct syntax involves specifying the date in a string format followed by the letter 'd'. This indicates to SAS that the string should be interpreted as a date value. Therefore, the correct answers are:

• A. "10/19/2019"d - This format directly specifies the month, day, and year, enclosed in quotes followed by 'd', which SAS correctly interprets as a date value.
• C. "19Oct2019"d - This format uses a three-letter abbreviation for the month combined with the day and year, also followed by 'd'. This is another valid way to specify a date in SAS.

Option B, mdy(10, 19, 2019), is incorrect because while the MDY function does create date values from month, day, and year components, the function itself should be used within a DATA step or another context where SAS functions are evaluated, and it doesn't directly create a date literal in the same way as options A and C.

Option D, mdy(19, Oct, 2019), is syntactically incorrect because the MDY function expects numeric arguments for the month, day, and year, and "Oct" as a literal month name is not a valid numeric argument.

References: SAS 9.4 Language Reference: Concepts.