CONTENTS procedure
Displays the descriptor portion of a SAS data set.
.
It is a required delimiter
BETWEEN-AND
Selects observations in which the value of a variable falls within an inclusive range of values.
$
Indicates a character format.
Character Values
Must be enclosed in quotation marks and are case sensitive.
Format
Changes the appearance of variable value.
Data portion
The ___ of a SAS data set is a rectangular table of character and/or numeric data values.
Numeric
Values do not use quotation marks.
%
In the LIKE operator, __ replaces any number of characters
Logical Operators
Combine or modify expressions.
Output
Contains reports generated by the SAS program.
Libref
It is needed if a permanent data set is being read or created.
LIKE
Selects observations by comparing character values to specified patterns.
Comments
SAS ___ are text that SAS ignores during processing.
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.
MAXDEC=
Specifies the number of decimal places in numeric formats.
Comparison operators
Compare a variable with a value or with another variable.
DATALINES
The ___ is used when reading data located directly in the program.
Displays the data portion of a SAS data set.
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.
COMMAXw.d
Writes numeric values with a period that separates every three digits and a comma that separates the decimal fraction.
_
In the LIKE operator, __ replaces one characters
Descriptor portion
The ___ of a SAS data set contains general information about the SAS data set.
Numeric Values
SAS stores DATE values as
COMMAw.d
Writes numeric values with a comma that separates every three digits and a period that separates the decimal fraction.
CONTAINS
Selects observations that include the specified substring.
W
Specifies the total format width including decimal places and special characters.
DATA
What statement is used to write to a SAS data set in the DATA step?
SET
What statement is used to read from a SAS data set in the DATA step?
WHERE
Subsets observations that meet a certain condition.
IS NULL/IS MISSING
Select observations in which the value of a variable is missing.
If-Then/Else
Only one executable statement is allowed in ___ statements.
KEEP=
The ___ data set option in the DATA statement specifies the variables for writing the output data set.
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.
DROP
The ___ statement specifies the names of the variables to omit from the output data set(s).
Label
Changes the appearance of a variable name.
By
A ___ statement after the MERGE statement performs a match-merge.
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.
RENAME=
The ____ data set option changes the name of a variable.
Libname
What statement is used to point to a physical filename including the path, filename, and extension of an Excel workbook?
Appending
Adds the observation in the second data set directly to the end of the original data set.
IMPORT
Enables you to read data from an external data source and write it to a SAS data set.
The ____ procedure can show the job titles that are missing and the hire dates that occur before the birth dates.
Operands
____ are constants (character, numeric or date) and variables (character or numeric).
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.
$
What character appears at the end of an excel worksheet name in the SAS explorer?
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.
FORCE
Option forces the observations to be appended when the DATA= data set contains variables that are not in BASE= data set.
Arithmetic
____ operators indicate that an arithmetic is performed.
MEANS
The ___ procedure can show if any salaries are not in the range of 24000 to 500000.
COPY
As an alternative to the DATA step, the ____ procedure can be used to create an Excel worksheet.
IF-THEN DO/ELSE DO
Multiple executable statements are allowed in ____ statements.
Operators
____ are symbols that represents an arithmetic calculation and SAS functions.
SORT
The ___ procedure orders SAS data set observations by the values of one or more variables.
Interleaving
Interserses observations from two or more data sets, based on one or more common variables.
IF-THEN DELETE
An alternative to the subsetting IF statement is the ____ statement.
Merging
Involves combining observations from two or more SAS data sets into a single observation in a new SAS data set.
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.
KEEP
The ___ statement specifies the names of the variables to write to the output data set(s).
IF-THEN
The ____ statement executes a SAS statement for observations that meet specific conditions.
MEANS
The ____ procedure can show if any salaries are not in the range of 24000 to 500000.
APPEND
Procedure that adds the observations from one SAS data set to the end of another SAS data set.
Clear
How do you disassociate a libref?
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.
EXPORT
Reads data from a SAS data set and writes it to an external file source.