Index
Special Characters
- _ERROR_ automatic variable
- _N_ automatic variable
A
- APPEND procedure
- attributes
- See variable attributes
B
- BY statement
-
- DESCENDING option
- group processing with
- Example: Grouping Observations Using Multiple BY Variables
Group Processing Using the BY Statement - match-merging data sets
- Methods of Combining SAS Data Sets: The Basics
Match-Merging Syntax - PRINT procedure
- Creating Subtotals for Variable Groups
Creating a Customized Layout with BY Groups and ID Variables - SORT procedure
- Example: PROC SORT
Example: Merge in Descending Order - syntax
- BY-group processing
C
- calculations
- case sensitivity
- CATX function
- character variables
-
- removing trailing blanks
- Overview of the LEFT and RIGHT Functions
Overview of the TRIM Function - replacing
- searching for strings
- character-to-numeric conversions
- A Word about Converting Data
Automatic Character-to-Numeric Conversion
- columns
- See variables
- combining data sets
-
- by appending
- by concatenating
- Methods of Combining SAS Data Sets: The Basics
Concatenating Syntax - by match-merging
- Methods of Combining SAS Data Sets: The Basics
Match-Merging Syntax - by one-to-one reading
- Methods of Combining SAS Data Sets: The Basics
One-to-One Reading Syntax - excluding unmatched observations
- methods for
- renaming variables
- COMMAw.d format
- Specifying SAS Formats
Field Widths
- compilation phase (DATA step)
- concatenating data sets
- Methods of Combining SAS Data Sets: The Basics
Concatenating Syntax
Example: Using Concatenating to Combine Data Sets
- concatenation operator (||)
- Automatic Numeric-to-Character Conversion
Explicit Numeric-to-Character Conversion
- conditional processing
- CONTENTS procedure
- converting data
- See data conversion
- CSS statistic
- CV statistic
D
- data sets
- See also combining data sets
See also match-merging data sets- BY-group processing
- data portion
- descriptor portion
- Descriptor Portion
Descriptor Portion of the SAS Data Set - dropping and keeping variables
- iteratively processing data
- manipulating data
- missing values
- naming
- naming conventions
- observations (rows)
- reading
- specifying observations via system options
- summarized using MEANS procedure
- testing programs
- variable attributes
- SAS Variable Attributes
Data Set Variables - variables and
- DATA step
-
- BY-group processing
- checking processing
- compilation phase
- creating/modifying variables
- debugging
- execution phase
- functionality
- iterations of
- manipulating data
- naming data sets
- reading Microsoft Excel data
- Steps for Reading Excel Data
SET Statement - submitting
- syntax
- writing
- Naming the Data Set with the DATA Statement
SET Statement
- DATDIF function
- SAS Date Functions
DATDIF and YRDIF Functions
- DATE function
- SAS Date Functions
DATE and TODAY Functions
- DATE9. format
- Examples: Data Values and Formats
Example: Finding the Year and Month
Example: Finding the Year
- dates and times
- DATEw. format
-
- examples
- Specifying SAS Formats
Overview
- DATEw. informat
- DAY function
- debugging
- DELETE statement
- delimiters
- DESCENDING option
- descriptive statistics
-
- creating summarized data sets
- creating tables in list format
- group processing with BY statement
- group processing with CLASS statement
- limiting decimal places
- procedure syntax
- producing frequency tables
- What Does the FREQ Procedure Do?
Example: Creating a One-Way Table for One Variable
Create Two-Way and N-Way Tables - selecting statistics
- specifying variables in FREQ procedure
- specifying variables in MEANS procedure
- DO groups
- DO loops
- DO statement
- See also iterative DO statements
- DO UNTIL statement
- Overview
Using the DO UNTIL Statement
- DO WHILE statement
-
- functionality
- Overview
Using the DO WHILE Statement - syntax
- dollar sign ($)
-
- in format names
- name literals and
- Overview
Name Literals
- DROP= data set option
E
- END statement
- engines
- See SAS engines
- error handling
-
- correcting common errors
- error types
- IF-THEN/ELSE statement
- in DATA step compilation phase
- in DATA step execution phase
- interpreting messages
- invalid option
- resubmitting revised programs
- semicolon errors
- unbalanced quotation marks
- Unbalanced Quotation Marks
Correcting the Error in the UNIX Environment - validating or cleaning data
- Excel data
- See Microsoft Excel data
- execution phase (DATA step)
- expressions
- See also SAS expressions
- external files
F
- FILENAME statement
- filerefs
-
- associating with external files
- fully qualified filenames in
- Defining a Fully Qualified Filename
Referencing a Fully Qualified Filename
- files
- See SAS files
- FIND function
- FIRST.variable
- FOOTNOTE statement
- FORMAT procedure
- FORMAT statement
-
- assigning formats to variables
- Assigning Formats to Variables
The WORDDATEw. Format - formatting dates
- Example: Finding the Year and Month
Example: Finding the Year - functionality
- syntax
- forward slash (/)
- FRAME= option
- FREQ procedure
- See also TABLES statement, FREQ procedure
- detecting invalid data
- Debugging Data Errors
Debugging Data Errors [2] - producing frequency tables
- What Does the FREQ Procedure Do?
Example: Creating a One-Way Table for One Variable
Create Two-Way and N-Way Tables - specifying variables
- suppressing table information
- syntax
- Debugging Data Errors
FREQ Procedure Syntax
- frequency tables
- functions
G
- group processing
H
- HTML link and path options
- HTML output
-
- appearance of HTML
- frame files
- link and path options
- The URL= Suboption
The PATH= Option - ODS overview
- overview
- specify link and path
- table of contents
- Creating HTML Output with a Table of Contents
Using the Table of Contents
- HTML table of contents
I
- ID statement, PRINT procedure
- IF-THEN statement
- INDEX function
- index variables in DO loops
- Decrementing DO Loops
Examples: Nesting DO Loops
- initializing variables
- Initializing Variables
Initializing Sum Variables
- INPUT function
-
- character-to-numeric conversion
- A Word about Converting Data
Using the INPUT Function - examples
- syntax
- INTCK function
-
- examples
- functionality
- SAS Date Functions
Details - syntax
- INTNX function
- SAS Date Functions
Overview of the INTNX Function
K
- KEEP= data set option
L
- LABEL statement
- LAST.variable
- LENGTH statement
- length, variable
- Variable Attributes
Specifying Variable Length
- LIBNAME statement
- libraries
- See SAS libraries
- librefs
- list reports
- logic errors
- logical operators
- LOWCASE function
- Finding a String Regardless of Case
LOWCASE Function
M
- MAX statistic
- MDY function
- MEAN statistic
- MEANS procedure
-
- BY statement
- CLASS statement
- creating summarized data sets
- descriptive statistics
- detecting invalid data
- Debugging Data Errors
Debugging Data Errors [2] - functionality
- hypothesis testing
- keywords supported
- limiting decimal places
- MAXDEC= option
- OUTPUT statement
- quantile statistics
- selecting statistics
- specifying variables
- syntax
- Debugging Data Errors
MEANS Procedure Syntax - VAR statement
- Debugging Data Errors
Specifying Variables Using the VAR Statement
- MERGE statement
- Microsoft Excel data
-
- CONTENTS procedure
- creating worksheets
- DATA statement
- Steps for Reading Excel Data
SET Statement - name literals
- PRINT procedure
- Steps for Reading Excel Data
Name Literals
Printing an Excel Worksheet as a SAS Data Set - referencing workbooks
- RUN statement
- Steps for Reading Excel Data
Name Literals - SET statement
- steps for reading
- WHERE statement, DATA step
- writing the DATA step
- MIN statistic
- missing values
- MMDDYYw. informat
- MODE statistic
- MONTH function
N
- N statistic
- n-way frequency tables
- What Does the FREQ Procedure Do?
Create Two-Way and N-Way Tables
- naming conventions
- NMISS statistic
- numeric-to-character conversion
- A Word about Converting Data
Automatic Numeric-to-Character Conversion
O
- observations
- See also combining data sets
- ODS EXCEL destination
- ODS EXCEL statement
- ODS HTML CLOSE statement
- ODS HTML statement
- ODS LISTING CLOSE statement
- Syntax
Closing the HTML Destination
- ODS PDF destinations
- ODS PDF statement
- ODS RTF
- ODS RTF destinations
- ODS RTF statement
- one-to-one reading of data sets
- one-way frequency tables
- What Does the FREQ Procedure Do?
Example: Creating a One-Way Table for One Variable
- operators
- Output Delivery System (ODS)
-
- advantages
- EXCEL
- The ODS EXCEL Statement
Details About the Excel ODS Destination - HTML support
- The ODS HTML Statement
Creating HTML Output with a Table of Contents - opening and closing destinations
- The ODS PDF Statement
The ODS Printer Family of Statements
Opening and Closing the PDF Destination
Working with the Table of Contents
Changing the Appearance of PDF Output - RTF
- The ODS RTF Statement
Opening and Closing the RTF Destination
Understanding How RTF Formats Output
ODS RTF and Graphics
- OUTPUT statement
- OUTPUT statement, MEANS procedure
P
- parentheses ()
- PATH= Option
- PDV
- See program data vector
- period (.)
- PRINT procedure
-
- BY statement
- Creating Subtotals for Variable Groups
Creating a Customized Layout with BY Groups and ID Variables - creating list reports
- ID statement
- Example: ID and VAR Statement
Creating a Customized Layout with BY Groups and ID Variables - LABEL option
- NOOBS option
- reading Microsoft Excel data
- Steps for Reading Excel Data
Name Literals
Printing an Excel Worksheet as a SAS Data Set - SUM statement
- The SUM Statement
Creating Subtotals for Variable Groups - VAR statement
- The VAR Statement
Example: ID and VAR Statement - WHERE statement
- PROC IMPORT
- PROC step
- program data vector
-
- DATA step processing
- Program Data Vector (PDV)
Iterations of the DATA Step
Iterations of the DATA Step [2] - match-merge processing
- The Basics of Match-Merge Processing
The Compilation Phase: Setting Up a New Data Set
The Execution Phase: Match-Merging Observations
The Execution Phase: Match-Merging Observations [2]
Handling Unmatched Observations and Missing Values
- programming workspace
- PUT function
-
- numeric-to-character conversion
- A Word about Converting Data
Example: INPUT Function
Explicit Numeric-to-Character Conversion - syntax
- PUT statement
Q
- QTR function
- quotation marks
R
- RANGE statistic
- RETAIN statement
- rows
- See observations
- RUN statement
-
- reading Microsoft Excel data
- Steps for Reading Excel Data
Name Literals
S
- SAS formats
- See formats
- SAS informats
- See informats
- SAS libraries
-
- creating
- defining
- Predefined SAS Libraries
Defining Libraries
Assigning Librefs - deleting
- storing SAS files
- viewing
- viewing library contents
- Viewing Libraries
Viewing Libraries Using PROC CONTENTS
- SAS programs
- SAS sessions
- SAS statements
- See also assignment statements
- SAS/ACCESS LIBNAME statement
- SCAN function
- semicolon (;)
- SET statement
-
- BY statement and
- concatenating data sets
- Methods of Combining SAS Data Sets: The Basics
Concatenating Syntax - DATA step processing
- SET Statement
Iterations of the DATA Step - one-to-one reading
- Methods of Combining SAS Data Sets: The Basics
One-to-One Reading Syntax - reading data sets
- reading Microsoft Excel data
- Steps for Reading Excel Data
SET Statement - RETAIN statement and
- syntax
- SORT procedure
- STD statistic
- STDERR statistic
- strings
- See character strings
- STYLE= option
- subsetting IF statement
- SUBSTR function
- subtotaling variables
- Creating Subtotals for Variable Groups
Example: Determining the Report Layout
- sum statement
- SUM statement, PRINT procedure
- SUM statistic
- SUMWGT statistic
- syntax errors
- Types of Errors
Syntax Errors
- system options
T
- T statistic
- target variables
- temporary variables
- Overview
Specifying Variables Using the VAR Statement
- testing programs
- TITLE statement
- trailing blanks, removing
- Overview of the LEFT and RIGHT Functions
Overview of the TRIM Function
Overview of the CATX Function
U
- UNIX environment
-
- SAS library implementation
- How SAS Files Are Stored
Assigning Librefs - storing files
- unbalanced quotation marks
- Unbalanced Quotation Marks
Correcting the Error in the UNIX Environment
- UPCASE function
- Finding a String Regardless of Case
UPCASE Function
- USS statistic
V
- VALIDMEMNAME= system option
- VALIDNARNAME= system option
- VALUE statement, FORMAT procedure
- VAR statement
- VAR statistic
- variable attributes
- variables
-
- accumulating totals
- assigning formats
- Assigning Formats to Variables
The WORDDATEw. Format - assigning labels
- Variable Attributes
Suppressing Table Information - assigning values conditionally
- attributes
- SAS Variable Attributes
Variable Attributes - creating or modifying
- creating/modifying
- DO groups
- format overview
- functionality
- generating totals
- index
- Decrementing DO Loops
Examples: Nesting DO Loops - informat overview
- initializing
- Initializing Variables
Initializing Sum Variables - labels for
- length of
- Variable Attributes
Specifying Variable Length - missing values
- naming conventions
- VALIDVARNAME=System Option
VALIDMEMNAME=System Option
Variable Attributes - renaming
- requesting subtotals
- Creating Subtotals for Variable Groups
Example: Determining the Report Layout - selecting in list reports
- selecting to drop and keep
- specifying in FREQ procedure
- specifying in MEANS procedure
- specifying lengths
- subsetting data
- sum
- target
- Target Variables
Example: Finding the Date - temporary
- Overview
Specifying Variables Using the VAR Statement - testing programs
- types of
W
- WEEKDAY function
- SAS Date Functions
Overview of the WEEKDAY Function
- WHERE statement, DATA step
- WHERE statement, PRINT procedure
- Windows environment
-
- SAS library implementation
- How SAS Files Are Stored
Assigning Librefs - storing files
- unbalanced quotation marks
- Unbalanced Quotation Marks
Correcting the Error in the Windows Operating Environment
Y
- YEAR function
- YRDIF function
- SAS Date Functions
DATDIF and YRDIF Functions
Z
- z/OS environment
-
- SAS library implementation
- How SAS Files Are Stored
Assigning Librefs - unbalanced quotation marks
- Unbalanced Quotation Marks
Correcting the Error in the z/OS Operating Environment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.