IS196 Finals

अब Quizwiz के साथ अपने होमवर्क और परीक्षाओं को एस करें!

By

A ___ statement after the MERGE statement performs a match-merge.

One to many many to one

A single observation in one data set is related to more than one observation from another data set based of one or more selected variables and vice versa.

One to one

A single observation in one data set is related to one and only one observation from another data set based on the values of one or more selected variables.

Appending

Adds the observation in the second data set directly to the end of the original data set.

IF-THEN DELETE

An alternative to the subsetting IF statement is the ____ statement.

COPY

As an alternative to the DATA step, the ____ procedure can be used to create an Excel worksheet.

Non Matches

At least one single observation in one data set is unrelated to any observation from another data set based on the values of one or more selected variables.

Label

Changes the appearance of a variable name.

Format

Changes the appearance of variable value.

Logical Operators

Combine or modify expressions.

Match-Merging

Combines observations from two or more SAS data sets into a single observation in a new data set based on the values of one or more common variables.

Comparison operators

Compare a variable with a value or with another variable.

Output

Contains reports generated by the SAS program.

Concatenating

Copies all observations from the first data set and then copies all observations from one or more successive data sets into a new data set.

PRINT

Displays the data portion of a SAS data set.

CONTENTS procedure

Displays the descriptor portion of a SAS data set.

IMPORT

Enables you to read data from an external data source and write it to a SAS data set.

Clear

How do you disassociate a libref?

%

In the LIKE operator, __ replaces any number of characters

_

In the LIKE operator, __ replaces one characters

$

Indicates a character format.

Interleaving

Interserses observations from two or more data sets, based on one or more common variables.

Merging

Involves combining observations from two or more SAS data sets into a single observation in a new SAS data set.

.

It is a required delimiter

Libref

It is needed if a permanent data set is being read or created.

IF-THEN DO/ELSE DO

Multiple executable statements are allowed in ____ statements.

Character Values

Must be enclosed in quotation marks and are case sensitive.

If-Then/Else

Only one executable statement is allowed in ___ statements.

FORCE

Option forces the observations to be appended when the DATA= data set contains variables that are not in BASE= data set.

APPEND

Procedure that adds the observations from one SAS data set to the end of another SAS data set.

EXPORT

Reads data from a SAS data set and writes it to an external file source.

Comments

SAS ___ are text that SAS ignores during processing.

Numeric Values

SAS stores DATE values as

IS NULL/IS MISSING

Select observations in which the value of a variable is missing.

LIKE

Selects observations by comparing character values to specified patterns.

BETWEEN-AND

Selects observations in which the value of a variable falls within an inclusive range of values.

CONTAINS

Selects observations that include the specified substring.

MAXDEC=

Specifies the number of decimal places in numeric formats.

W

Specifies the total format width including decimal places and special characters.

WHERE

Subsets observations that meet a certain condition.

KEEP=

The ___ data set option in the DATA statement specifies the variables for writing the output data set.

DATALINES

The ___ is used when reading data located directly in the program.

Descriptor portion

The ___ of a SAS data set contains general information about the SAS data set.

Data portion

The ___ of a SAS data set is a rectangular table of character and/or numeric data values.

MEANS

The ___ procedure can show if any salaries are not in the range of 24000 to 500000.

SORT

The ___ procedure orders SAS data set observations by the values of one or more variables.

DROP

The ___ statement specifies the names of the variables to omit from the output data set(s).

KEEP

The ___ statement specifies the names of the variables to write to the output data set(s).

RENAME=

The ____ data set option changes the name of a variable.

MEANS

The ____ procedure can show if any salaries are not in the range of 24000 to 500000.

PRINT

The ____ procedure can show the job titles that are missing and the hire dates that occur before the birth dates.

IF-THEN

The ____ statement executes a SAS statement for observations that meet specific conditions.

Merge

The ____ statement in a DATA step joins observations from two or more SAS data sets into single observations.

Assignment

The _____ statement evaluates an expression and assigns the resulting value to a variable.

Numeric

Values do not use quotation marks.

$

What character appears at the end of an excel worksheet name in the SAS explorer?

Libname

What statement is used to point to a physical filename including the path, filename, and extension of an Excel workbook?

SET

What statement is used to read from a SAS data set in the DATA step?

DATA

What statement is used to write to a SAS data set in the DATA step?

COMMAw.d

Writes numeric values with a comma that separates every three digits and a period that separates the decimal fraction.

DOLLARw.d

Writes numeric values with a leading dollar sign, a comma that separates every three digits, and a period that separates the decimal fraction.

EUROXw.d

Writes numeric values with a leading euro symbol, a period that separates every three digits, and a comma that separates the decimal fraction.

COMMAXw.d

Writes numeric values with a period that separates every three digits and a comma that separates the decimal fraction.

Operands

____ are constants (character, numeric or date) and variables (character or numeric).

Operators

____ are symbols that represents an arithmetic calculation and SAS functions.

Arithmetic

____ operators indicate that an arithmetic is performed.


संबंधित स्टडी सेट्स

Insulation and Ventilation Systems Set

View Set

Physical and Chemical Control of Microbes

View Set

AREndurance STUDY NOTES - BDCS-Jennypdx

View Set