SAS QUIZ 2

Which WHERE statement will return all the observations that have a first name starting with the letter M for the given values?

where Name like '_, M_';

where Name like '_, M%';

where Name like '%, M%';

Where Name like '%, M_';

TheAnswer ____________________ rocedure produces summary reports that display descriptive statistics.

Means

Univariate

Proc means

Sum

How do you disassociate a libref?

DISASSOCIATE option

CLEAR option

RUN option

QUIT option

The Answer ______________________ procedure produces one-way to n-way frequency tables.

FREQ

Univariate

MEANS

SUM

The Answer ____________ statement assigns a library reference name (libref) to a SAS data library.

LIBNAME

LIBREFF

LIB

SUM LIB

A Answer_______________ is needed if a permanent data set is being read or created

library reference name

Libref

Refname

Read

Enumerate the 3 logical operators

(AND) LOGICAL AND

(OR) LOGICAL OR

(NOT) LOGICAL NOT

(WHERE) LOGICAL WHERE

Procedures can be used to detect invalid data (hint: there are 4)

PROC PRINT

PROC FREQ

PROC MEANS

PROC UNIVARIATE

How can you limit the variables written to an output data set in the DATA step? (Hint : 2 statements)

DROP or KEEP STATEMENT

DROP OR REMAIN STATEMENT

QUIT OR STAY STATEMENT

Two types of SAS Data

DESCRIPTOR INFORMATION

DATA VALUES

REAL DATA

DEPENDENT DATA

Examples of SAS informats used to convert nonstandard numeric data to SAS numeric values (two only)

COMMA

DOLLAR

PERIOD

QUESTIONMARK

Which FORMAT statement creates the output? Birth_Date 21/05/1969 Hire_Date 15/10/1992 Term_Date MAR2007

Format Birth_Date Hire_Date ddmmyyyy. Term_Date mmmyyyy.;

format Birth_Date Hire_Date ddmmyy10. Term_Date monyy7.;

C. format Birth_Date Hire_Date ddmmyy9. Term_Date mmyy7.;

format Birth_Date Hire_Date ddmmyy10. Term_Date monyyyy7.;

Which PROC PRINT step displays the worksheet containing employees from the United States?

proc print data=orionxls.'UnitedStates'n;

. Proc print data=orionxls.'UnitedStates';

proc print data=orionxls.'UnitedStates$'n; run;

Proc print data=orionxls.'UnitedStates$'; run

Which statement is true?

An input buffer is only created if you are reading data from a raw data file.

The descriptor portion is the first item that is created at compile time.

The PDV at compile time holds the variable name, type, byte size, and initial value

An input buffer is only created if you are outputting data from a raw data file.

Which statement is true?

When SAS returns to the top of the DATA step, any variable coming from a SAS data set is set to missing.

At the bottom of the DATA step, the contents of the PDV are output to the output SAS data set

At the bottom of the DATA step, the contents of the PDV are output to the log SAS data set.

Data is read directly from the raw data file to the PDV.

Which statements are used to read a delimited raw data file and create a SAS data set?

DATA, SET, and INPUT only

DATA and SET only

DATA, INFILE, and INPUT only

DATA and INFILE only

Which types of files will you read into SAS?

Excel Worksheets

Answer will vary.

raw data delimited file

SAS Data sets

Which value will not be returned based on the WHERE statement? where Job_Title contains 'Rep';

Representative

Service rep III

Sales Rep. IV

Office Rep

Which WHERE statement correctly subsets the numeric values for May, June, or July and missing character names?

Where Months in (567) and Names = '.';

where Months in ('5','6','7') and Names = '.';

where Months in (5,6,7) and Names = ' ';

Where Months in (5-7) and Names = .;

Occur when data values are not appropriate for the SAS statements that are specified in a program.

DATA ERRORS

ERROR 101

SYNTAX ERRORS

HUMAN ERROR

A ___________ statement can be used in a conditional statement to write the current observation to a specific data set that is listed in the DATA statement.

OUTPUT

FEEDBACK

RUN

Any data that SAS cannot read without a special instruction

NONSTANDARD DATA

A Answer LENGTH statement defines the length of a variable explicitly.

LENGTH

SAS QUIZ 2

More Quizzes