SAS BASE AND ADVANCED TRAINING COURSE CONTENT
- Overview
- SAS Programs
- SAS Libraries
- Referencing SAS Files
- SAS Data Sets
- Variable Attributes
- Practice
- Overview
- Referencing Files
- Viewing the Contents of SAS Libraries
- Setting SAS System Options
- Viewing System Options
- Additional System Options
- Practice
- Overview
- SAS Program Layout
- Interpreting Error Messages
- Correcting Errors
- Resolving Common Problems
- Additional Features
- Practice
- Overview
- Types of Reports
- Creating a Basic Report
- Identifying Observations
- Selecting Observations
- Sorting Data
- Generating Column Totals
- Double-Spacing Listing Output
- Specifying Titles and Footnotes
- Assigning Descriptive Labels
- Formatting Data Values
- Using Permanently Assigned Labels and Formats
- Additional Features
- Practice
- Overview
- Raw Data Files
- Steps to Create a SAS Data Set
- Referencing a SAS Library
- Referencing a Raw Data File
- Writing a DATA Step Program
- Submitting the DATA Step Program
- Creating and Modifying Variables
- Sub setting Data
- Reading In stream Data
- Steps to Create a Raw Data File Additional Features
- Practice
- Overview
- Writing Basic DATA Steps
- How SAS Processes Programs
- Compilation Phase
- Execution Phase
- Debugging a DATA Step
- Testing Your Programs
- Practice
- Overview
- Introduction to PROC FORMAT
- Invoking PROC FORMAT
- Defining a Unique Format
- Associating User-Defined Formats with Variables
- Practice
- Overview
- Creating a Default List Report
- Selecting Variables
- Selecting Observations
- Defining Variables
- Defining Column Attributes
- Defining Column Headings
- Specifying Column Justification
- Enhancing the Heading’s Appearance
- Defining Variable Usage
- Practice
- Overview
- Computing Statistics for Numeric Variables
- Producing Frequency Tables
- Practice
- Overview
- The Output Delivery System
- Opening and Closing ODS Destinations
- Creating Simple HTML
- Creating HTML Output with a Table of Contents
- Using Options to Specify Links and Paths
- Changing the Appearance of HTML Output
- Additional Features
- Practice
- Overview
- Creating and Modifying Variables
- Assigning Values Conditionally
- Specifying Lengths for Variables
- Sub setting Data
- Assigning Permanent Labels and Formats
- Assigning Values Conditionally Using SELECT Groups
- Grouping Statements Using DO Groups
- Practice
- Fundamentals Review: Building basic maps
- Parameter Basics
- Data types of parameters
- Using parameters in calculated fields
- Inputting parameter values and parameter control options
- Advanced Usage of Parameters
- Using parameters for titles, field selections, logic statements, Top X
- Overview
- Reading a Single Data Set
- Manipulating Data
- Using BY-Group Processing Reading Observations
- Using Direct Access Detecting the End of a Data Set
- Understanding How Data Sets Are Read
- Additional Features Summary
- Practice
- Overview
- One-to-One Reading
- Concatenating
- Interleaving
- Simple Match---Merging
- Match-Merge Processing
- Renaming Variables
- Excluding Unmatched Observations
- Selecting Variables
- Additional Features
- Practice
- Overview
- Understanding SAS Functions
- General Form of SAS Functions
- Converting Data with Functions
- Manipulating SAS Date Values with Functions
- Modifying Character Values with Functions
- Modifying Numeric Values with Functions
- Nesting SAS Functions
- Practice
- Overview
- Constructing DO Loops
- Nesting DO Loops
- Iteratively Processing Data That Is Read from a Data Set
- Conditionally Executing DO Loops (Statistical Analysis System)
- Using Conditional Clauses with the Iterative DO
- Statement
- Creating Samples
- Practice
- Overview
- Creating One-Dimensional Arrays
- Expanding Your Use of Arrays
- Additional Features
- Overview
- Review of Column Input
- Identifying Standard and Nonstandard Numeric Data
- Choosing an Input Style
- Using Formatted Input
- Using In formats
- Record Formats
- Practice
- Overview
- Reading Free-Format Data
- Using List Input
- Reading Missing Values
- Specifying the Length of Character Values
- Modifying List Input
- Creating Free-Format Data
- Mixing Input Styles
- Practice
- Overview
- How SAS Stores Date Values
- How SAS Stores Time Values
- More about SAS Date and Time Values
- Reading Date and Time In formats
- Using Dates and Times in Calculations
- Using Date and Time Formats
- Practice
- Overview
- Use Line Pointer Controls
- Reading Multiple Records Sequentially
- Reading Multiple Records Non-Sequentially
- Combining Line Pointer Controls
- Overview
- Reading Repeating Blocks of Data
- Reading the Same Number of Repeating Fields
- Reading a Varying Number of Repeating Fields
- Practice
- Purpose of the macro facility
- Program flow
- Course data
- Introduction
- Automatic macro variables
- Macro variable references
- User defined macro variables
- Delimiting macro variable names
- Macro functions
- Defining and calling a macro
- Macro parameters
- Creating macro variables in the DATA step
- Indirect references to macro variables
- Retrieving macro variables in the DATA step
- Creating macro variables in SQL.
- Conditional processing
- Iterative processing global and local symbol tables
- Avoiding Macro Error
- Merrror and Serror Options
- Mlogic, Mprint, Symbolgen Options
- %put Statements
- Introducing the Structured Query Language
- Similarities and Differences
- Overview of the SQL procedure
- Specifying columns
- Specifying rows
- Operators
- Expression
- Presenting data
- Summarizing data
- Non correlated sub queries
- Exists
- Calculated
- Overview
- Understanding Joins
- Generating a Cartesian Product
- Using Inner Joins
- Using Outer Joins
- Creating an Inner Join with Outer Join-Style Syntax
- Comparing SQL Joins and DATA Step Match---Merges
- Using In-Line Views
- Joining Multiple Tables and Views
- Practice
- Overview
- Understanding Set Operations
- Using the EXCEPT Set Operator
- Using the INTERSECT Set Operator
- Using the UNION Set Operator
- Using the OUTER UNION Set Operator
- Comparing Outer Unions and Other SAS Techniques
- Practice
- Creating tables with the SQL procedure
- Integrity constraints
- Creating views with the SQL procedure
- Inserting Data
- Drop and Alter the Tables and Views
- Inserting, Deleting, Update the Rows
- Creating and dropping the indexes
- Setting SQL procedure options
- Dictionary tables and views
- Interfacing PROC SQL with the Macro language
- Program testing and performance
- Connecting to databases using LIBNAME and CONNECT statements
- Using database tables in SQL procedure queries
- Database execution of naïve SQL statements (SQL Pass-through)
- Overview
- Charts
- Two---Dimensional Plots
- Go options Statements
- Legend Statements
- Axis Statements
- Symbol Statements
- Pattern Statements
- The G polt Procedure
- The G chart Procedure
- Practice
- The Distribution of data with Proc UNIVARIATE
- Producing Statistics with Proc MEANS
- Testing categorical data Proc FREQ
- Examining correlations with Proc CORR
- Using Proc REG for simple Regression Analysis
- Reading the output of Proc Reg
- Using Proc ANOVA for one-way analysis of variance
- Reading the output of Proc ANOVA
- Practice