Free Access SAS Institute A00-215 New Release

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.

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

In SAS, the code you provided involves creating two datasets, table1 and table2, from the dataset sashelp.shoes. The key part to understand here is how the DATA statement and OUTPUT statement interact with the specified datasets.

• DATA Statement: The statement data table1 table2; initiates the creation of two new datasets named table1 and table2.
• SET Statement: The set sashelp.shoes; statement is used to read data from the sashelp.shoes dataset. This dataset includes data on shoe sales from SASHELP library, which is commonly used for demonstration purposes in SAS.
• OUTPUT Statement: In the context of the DATA step where multiple datasets are specified in the DATA statement (as in table1 table2), the OUTPUT statement without a dataset name specified outputs the current observation to all datasets listed in the DATA statement. This is a critical point because it determines where the data goes after processing in the DATA step.
• Execution: When the run; statement is executed, it processes each observation from sashelp.shoes. For each observation, because there is no condition or additional OUTPUT statements specifying dataset names, each observation is output to both table1 and table2.

Therefore, the correct behavior as described is that each observation in sashelp.shoes is written to both table1 and table2. This effectively duplicates each row from the source into both target datasets.

References:

• SAS 9.4 Language Reference: Concepts, "DATA Step Processing" and "OUTPUT Statement" sections provide detailed explanations on how DATA steps process and how OUTPUT statement works in different contexts.
• Practical examples and explanations from SAS programming courses and official SAS documentation, which discuss DATA and SET statements, and their interaction with OUTPUT in data duplication scenarios.

In SAS, the SUBSTR function is used to extract a substring from a character string. The function syntax is SUBSTR(string, position, length), where:

• string is the variable or string literal you want to extract the substring from.
• position is the starting position of the substring within string.
• position starts counting at 1 in SAS, not 0 as in some other languages.
• length is the number of characters to extract.

For the value of date provided ("02Apr2019"), we want to extract the year, which is the four characters at the end of the string.

Here's how each option would work given the string:

A) year=substr(date, 7, 4);This starts at the 7th character of the string ("2019") and extracts 4 characters, which correctly represents the year.

B) year=substr(date, 4, 6);This starts at the 4th character ("Apr2019") and would extract 6 characters, which gives us "Apr201", not just the year.

C) year=substr(date, 6, 4);This starts at the 6th character ("r2019") and would extract 4 characters, resulting in "r201", which is not correct.

D) year=substr(date, 4, 7);This starts at the 4th character and would extract 7 characters, resulting in "Apr2019", which is the whole string from the 4th character to the end, not just the year.

The correct answer is A, as it extracts the four-digit year from the end of the string.

References:

• The SAS documentation on the SUBSTR function, which details how to use it for extracting parts of strings.
• SAS programming tutorials that often provide examples of common functions like SUBSTR for string manipulation