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

In SAS, when you use a BY statement in a DATA step, SAS creates two temporary variables for each variable listed in the BY statement: one to indicate the first occurrence (FIRST.variable) and another to indicate the last occurrence (LAST.variable) of the value within the BY-group. Given the provided code and assuming that State is the variable used in the BY statement, SAS will create First.State and Last.State. Thus, option A is correct.

References:

• SAS documentation on the BY statement, SAS Institute.

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

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.