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

The report shown is a cross-tabulation of 'Region' by 'Product'. The FREQ Procedure indicates that PROC FREQ has been used, and the presence of 'Frequency', 'Percent', 'Row Percent', and 'Column Percent' suggests that a cross tabulation (or contingency table) has been requested. The correct code for this output would include the tables statement to specify the two variables ('Region' and 'Product') with an asterisk between them, which indicates a request for a cross-tabulation of these two categorical variables, and the crosslist option to display the table in a cross-tabulated list format. Therefore, option D is the correct answer:

proc freq data=sashelp.shoes;

tables region*product / crosslist;

run;

Options A and C use the order=freq option incorrectly, as this option would order the table by frequency counts rather than providing a cross-tabulation. Option B is missing the crosslist option needed to produce the cross-tabulated format.

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.

In SAS, footnotes are set using the footnote statement and they will appear on all subsequent output until they are either changed or cleared. Based on the second image provided with the SAS code, the footnote for the second PROC PRINT report is set immediately before it runs.

The code sets footnote1 as 'Created by HR' and footnote2 as 'Confidential' initially. However, before the second PROC PRINT step, footnote2 is redefined as 'Draft - Do Not Distribute'. Since footnote1 is not redefined or cleared, it is no longer in effect for the second report.

Therefore, the only footnote that appears for the second PROC PRINT report is what is defined for footnote2 at that point in the code, which is 'Draft – Do Not Distribute'. That's why the correct answer is D.

References:

• SAS 9.4 documentation for the FOOTNOTE statement: SAS Help Center: FOOTNOTE Statement