IS196 - Quiz 2 Reviewer

अब 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.

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.

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.

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?

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.

IF-THEN DO/ELSE DO

Multiple executable statements are allowed in ____ statements.

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.

KEEP=

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

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.

$

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?

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.


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

Ch 54 Care for Patients With Problems of the Biliary System and Pancreas

View Set

General accounting test - Chapter 2

View Set

Chapter 14 - True/False Test Bank Questions

View Set

Environmental Ethics, Environmental Ethics, Environmental Ethics 2

View Set

Programming Fundamentals I Chapter 1

View Set

Pre-Calculus Linear and Quadratic Functions and Modeling

View Set