SAS Chapter 2 Referencing Files And Setting Options

1. Which statement prints a summary of all the files stored in the library named Area51?

Proc contents data=area51._all_ nods;

Proc contents data=area51 _all_ nods;

Proc contents data=area51 _all_.nods;

To print a summary of library contents with the CONTENTS procedure, use a period to append the _ALL_ option to the libref. Adding the NODS option suppresses detailed information about the files.

Explanation

To print a summary of library contents with the CONTENTS procedure, use a period to append the _ALL_ option to the libref. Adding the NODS option suppresses detailed information about the files.

2. If you submit the following program, how does the output look? options pagesize=55 nonumber; proc tabulate data=clinic.admit; class actlevel; var age height weight; table actlevel,(age height weight)*mean; run; options linesize=80; proc means data=clinic.heart min max maxdec=1; var arterial heart cardiac urinary; class survive sex; run;

The PROC TABULATE output has no page numbers, but the PROC MEANS output has page numbers.

The date does not appear on output from either PROC step.

When you specify a system option, it remains in effect until you change the option or end your SAS session, so both PROC steps generate output that is printed 55 lines per page with no page numbers. If you don't specify a system option, SAS uses the default value for that system option.

Explanation

When you specify a system option, it remains in effect until you change the option or end your SAS session, so both PROC steps generate output that is printed 55 lines per page with no page numbers. If you don't specify a system option, SAS uses the default value for that system option.

3. Which time span is used to interpret the two-digit year values if the YEARCUTOFF= option is set to 1950?

1950-2049

1950-2050

1949-2050

1950-2000

The YEARCUTOFF= option specifies which 100-year span is used to interpret two-digit year values. The default value of YEARCUTOFF= to the first year of another 100-year span. If you specify YEARCUTOFF= 1950, then the 100-year span will be from 1950 to 2049.

Explanation

The YEARCUTOFF= option specifies which 100-year span is used to interpret two-digit year values. The default value of YEARCUTOFF= to the first year of another 100-year span. If you specify YEARCUTOFF= 1950, then the 100-year span will be from 1950 to 2049.

4. When you specify an engine for a library, you are always specifying

The file format for files that are stored in the library.

The version of SAS that you are using.

Access to other software vendors' files.

Instructions for creating temporary SAS files.

A SAS engine is a set of internal instructions that SAS uses for writing to and reading from files in a SAS library. Each engine specifies the file format for files that are stored in the library, which in turn enables SAS to access files with a particular format. Some engines access SAS files, and other engines support access to other vendors' files.

Explanation

A SAS engine is a set of internal instructions that SAS uses for writing to and reading from files in a SAS library. Each engine specifies the file format for files that are stored in the library, which in turn enables SAS to access files with a particular format. Some engines access SAS files, and other engines support access to other vendors' files.

5. What does the following statement do? libname osiris spss 'c:\myfiles\sasdata\data';

Defines a library called Spss using the OSIRIS engine

Defines a library called Osiris using the SPSS engine

Defines two libraries called Osiris and Spss using the default engine

Defines the default library using OSIRIS and SPSS engines

In the LIBNAME statement, you specify the library name before the engine name. Both are followed by the path.

Explanation

In the LIBNAME statement, you specify the library name before the engine name. Both are followed by the path.

6. The following PROC Print output was created immediately after PROC TABULATE output. Which system options were specified when the report was created?

OBS=, DATE, and NONUMBER

NUMBER, PAGENO=1, and DATE

NUMBER and DATE only

None of the above

Clearly, the DATE and NUMBER(page number) options are specified. Because the page number on the output is 1, even though the PROC TABULATE output was just produced, PAGENO=1 must also have been specifed. If you don't specify PAGENO=, all output in the Output window is numbered sequentially throughout your SAS session.

Explanation

Clearly, the DATE and NUMBER(page number) options are specified. Because the page number on the output is 1, even though the PROC TABULATE output was just produced, PAGENO=1 must also have been specifed. If you don't specify PAGENO=, all output in the Output window is numbered sequentially throughout your SAS session.

7. Which of the following programs correctly references a SAS data set named SalesAnalysis that is stored in a permanent SAS library?

Data saleslibrary.salesanalysis; set mydata.quarter1sales; if sales>1000000;run;

Data mysales.totals; set sales_99.salesanalysis; if totalsales>50000;run;

Aproc print data=salesanalysis.quarter1; var sales salesrep month;run;

Proc freq data=1999data.salesanalysis; tables quarter*sales;run;

Librefs must be 1 to 8 characters long, must begin with a letter or underscore and can contain only letters, numbers, or underscores. After you assign a libref, you specify it as the first element in the two-level name for a SAS file.

Explanation

Librefs must be 1 to 8 characters long, must begin with a letter or underscore and can contain only letters, numbers, or underscores. After you assign a libref, you specify it as the first element in the two-level name for a SAS file.

8. Assuming you are using SAS code and not special SAS windows, which one of the following statements is false?

LIBNAME statements can be stored with a SAS program to reference the SAS library automatically when you submit the program.

Librefs can last from one SAS session to another.

You can access files that were created with other vendors' software by submitting a LIBNAME statement.

The LIBNAME statement is global, ehich means that librefs remain in effect until you modify them, cancel them, or end your SAS session. Therefore, the LIBNAME statement assigns the libref for the current SAS session only. You must assign a libref before accessing SAS files that are stored in a permanent SAS data library.

Explanation

The LIBNAME statement is global, ehich means that librefs remain in effect until you modify them, cancel them, or end your SAS session. Therefore, the LIBNAME statement assigns the libref for the current SAS session only. You must assign a libref before accessing SAS files that are stored in a permanent SAS data library.

9. How can you create SAS output in HTML format on any SAS platform?

By specifying system options

By using programming statements

By using SAS windows to specify the result format

You can't create HTML output on all SAS platforms

You can create HTML output using programming statements on any SAS platform. In addition, on all except mainframe platforms, you can use SAS windows to specify HTML as a result format.

Explanation

You can create HTML output using programming statements on any SAS platform. In addition, on all except mainframe platforms, you can use SAS windows to specify HTML as a result format.

10. In order for the date values 05May1955 and 04Mar2046 to be read correctly, what value must the YEARCUTOFF= option have?

A value between 1947 and 1954, inclusive

1955 or higher

1946 or higher

Any value

As long as you specify an informat with the correct field width for reading the entire date value, the YEARCUTOFF= option doesn't affect date values that have four-digit years.

Explanation

As long as you specify an informat with the correct field width for reading the entire date value, the YEARCUTOFF= option doesn't affect date values that have four-digit years.