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

In SAS, the FORMAT procedure (PROC FORMAT) allows users to create custom formats that can be used to change the way data is displayed without altering the data itself. The VALUE statement within PROC FORMAT is a key component of this procedure.

The VALUE statement can indeed create both numeric and character formats, which is why option C is correct. Numeric format names typically do not start with a $ sign (this is reserved for character format names), and the keyword UNKNOWN is not a part of the VALUE statement syntax; it is used in a different context within PROC FORMAT, specifically for handling undefined data values when using custom formats.

Moreover, the LIB= option is not used within the VALUE statement. The LIB= option is used at the PROC FORMAT level to specify the library where the formats should be stored or from which they should be read.

References

• SAS 9.4 documentation for the PROC FORMAT and VALUE statement.
• "SAS Formats and Informats." in "Step-by-Step Programming with Base SAS 9.4" from the SAS Institute.

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.

The code creates two datasets, preteen and teen, based on the age variable from the sashelp.class dataset. The if statement checks each observation, and if the age is less than 13, the observation is written to the preteen dataset; otherwise, the observation is written to the teen dataset.

From the provided frequency table, we can see that there are 7 observations with ages less than 13 (2 for age 11 and 5 for age 12), so the preteen dataset will have 7 observations. Since the sashelp.class dataset has a total of 19 observations, the remaining 12 observations (19 total - 7 preteen = 12 teen) will be written to the teen dataset.

Thus, the answer is: B. preteen will have 7 observations and teen will have 12 observations.

References:

• SAS documentation on the DATA step and IF-THEN/ELSE logic, SAS Institute.