SAS Institute A00-215 Practice Test Questions Answers

In SAS, datasets can be either temporary or permanent, depending on the library where they are stored. Temporary datasets are stored in the Work library and are deleted at the end of the session, while permanent datasets reside in user-defined libraries or in libraries that refer to a more persistent storage location.

For this question:

B. Mylib.new: This is a permanent dataset. The prefix 'Mylib' suggests it is stored in a user-defined library (not the temporary 'Work' library), implying that the data persists beyond the current session unless explicitly deleted or if the library's link to the storage location is removed.

D. Temp.new: Despite the potentially misleading name 'Temp', if this dataset is not explicitly stored in the Work library, it could indeed be permanent. The permanence of a dataset is determined by its library reference, not by its name. If 'Temp' is a user-defined library linked to a persistent storage, then 'Temp.new' is also permanent.

C. Work.new: This dataset is explicitly temporary as it is stored in the Work library, which is cleared at the end of the SAS session.

A. New: Without additional context about the library, 'New' does not provide enough information to determine its permanence. It could be either temporary or permanent depending on the library it references.

References:SAS documentation on libraries and dataset management, SAS Institute.

The PROC PRINT statement is used for printing SAS datasets. To customize the column headers in the report, you use the label statement within the PROC PRINT procedure to assign new labels to variables, and the label option in the PROC PRINT to activate these labels. The noobs option suppresses the printing of observation numbers in the report.

Option B has the correct syntax for what is being requested:

proc print data=cities label noobs; specifies the dataset to print with the label option to display variable labels and noobs to hide the observation numbers.

label Name='Employee Name' City='Birth City'; assigns the label 'Employee Name' to the 'Name' variable and 'Birth City' to the 'City' variable.

run; signifies the end of the PROC PRINT procedure.

Options A, C, and D are incorrect due to syntax errors:

A uses an incorrect option showlabelse instead of label and noobs.

C is incorrect because it lacks the label option in the proc print statement which is necessary to actually display the labels, and the labels are being incorrectly used within the proc print instead of in a label statement.

D has several issues: there is no display statement in SAS, the option noobs should be outside of the proc print statement, and the labels should be defined in a label statement, not within proc print.

References:

SAS 9.4 documentation for the PROC PRINT statement: SAS Help Center: PROC PRINT

The error messages in the SAS log indicate issues with the treatment of text as a character string. In SAS, character strings must be enclosed in quotation marks. The log shows that 'ABC Inc.' is treated as if it is a variable or an expression, which is causing a syntax error. Enclosing 'ABC Inc.' in quotation marks will correctly identify it as a character string. Therefore, Option B is the correct action to resolve the error messages. This error is evident as the log indicates it was expecting an arithmetic operator, which suggests that the text was misinterpreted as part of an expression.

References:

SAS documentation on character strings and data step options, 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

The correct answer is B. The DATA step in SAS is used to read, process, and create data sets. It can read from various sources, not just raw data files but also existing SAS datasets and external databases. It processes the data by executing operations on each observation and can create one or more SAS datasets as output. The other options are incorrect because:

A is incorrect because the DATA step is not limited to reading only raw data files.

C is incorrect because the DATA step can output multiple data sets using the OUTPUT statement.

D is incorrect because the DATA step does not have to be the first step in a program; it can be used anywhere in the program where data processing is required.

References:

SAS 9.4 Language Reference: Concepts, "DATA Step"

SAS documentation on processing data with the DATA step.