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

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.

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.

In the DATA step provided, average is calculated using the mean function, which calculates the average of the non-missing values of the variables listed. The variables provided are:

• var1 = 2
• var2 = 4
• var3 = .
• var4 = 6

The mean function in SAS ignores missing values, represented by a period (.). Hence, the average is computed using the non-missing values (2, 4, and 6). The mean of these three numbers is calculated as: (2 + 4 + 6) / 3 = 12 / 3 = 4

Therefore, the value of average is 4.

References:

• SAS documentation on the MEAN function, SAS Institute.