IS196 Finals
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.
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.
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.