Midterm 2

Question 1

Multiple INPUT statements

Answer 1

By default, SAS advances the pointer to column 1 of the next input record when SAS encounters an INPUT statement.

Question 2

/ Line-pointer control

Answer 2

Advances the pointer to column 1 of the next input record.

Ex.
data work.kids8;
infile 'kids8.dat';
input name $1-8
siblings 10
/ @1 bdate mmddyy10.
@ 12 allowance comma2.

Question 3

n line pointer control

Answer 3

Advances the pointer to column 1 of record n.
Ex.
data work.kids8;
infile 'kids8.dat';
input #1 name $1-8
siblings 10
#2 @1 bdate mmddyy10.
@ 12 allowance comma2.

Question 4

Single Trailing @

Answer 4

Holds an input record for the execution of the next INPUT statement within the same iteration of the DATA step.
Useful when you must read a record multiple times.

Question 5

Which statement is false concerning the single trailing @?
A. In the INPUT statement, the single trailing @ must be the last item before the semicolon.
B. SAS releases a record held by a single trailing @ when an INPUT statement without a trailing @ executes.
C. The single trailing @ prevents the next INPUT statement from automatically releasing the current input record.
D. the single trailing @ holds the input record for the execution of the next INPUT statement across iterations of the DATA step.

Answer 5

D. the single trailing @ holds the input record for the execution of the next INPUT statement across iterations of the DATA step.

Question 6

Double trailing @

Answer 6

Holds the input record for the execution of the next INPUT statement across iterations of the DATA step.
Is useful when each input line contains values for several observations.

Question 7

Which statement is false concerning the double trailing @?
A. The double trailing @ must be the first item in the INPUT statement.

B. The double trailing @ is useful when one record contains several observations.

C. The double trailing @ holds a record for the next INPUT statement across iterations of the DATA step.

D. SAS releases the record that is held by a double trailing @ if the pointer moves past the end of the input record.

Answer 7

A. The double trailing @ must be the first item in the INPUT statement.

Question 8

SAS/ACCESS LIBNAME statement

Answer 8

With the SAS/ACCESS interface to PC File Formats the LIBNAME statement can be used to access Microsoft excel workbooks.

If SAS has a library reference name assigned to an Excel workbook, the workbook cannot be opened in Excel.

This enables you to reference a worksheet directly in a DATA step or SAS procedure, and to read from and write to an Excel worksheet as if it were a SAS data set.

ex. libname myxls ‘customers.xls’;
proc contents data=myxls.all;

Question 9

How do you reference the females worksheet in the Excel workbook customer base on the following LIBNAME statement?

libname myxls ‘customers.xls’;

A. myxls.females$
B. customer.females
C. myxls.’females$’n
D. customer.’females’n

Answer 9

C. myxls.’females$’n

Question 10

Worksheets in SAS/ACCESS

Answer 10

Worksheet names appear with a dollar sign at the end of the name.

Question 11

SAS name literal

Answer 11

Enable special characters to be included in data set names.

A name token that is expressed as a string withing quotation marks, followed immediately by the letter n.

ex. myxls.’females$’n

Question 12

Which statement dis associates the MYXLS library reference name?

A. libname myxls end;
B. libname myxls clear;
C. libname myxls close;
D. libname myxls disassociate;

Answer 12

B. libname myxls clear;

Question 13

SAS/ACCESS and bit count

Answer 13

The default Excel engine can be specified when the bit count of SAS and Microsoft Office are the same (both are 32-bit or both are 64-bit).
libname myxls excel ‘customers.xls’;

The PC Files Server engine must be specified when the bit counts differ.
libname myxls pcfiles path= ‘customers.xls’;