IS196 - Quiz 2 Reviewer
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.
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.
