Advanced SAS

SAS SQL Course Contents
Chapter 1 : Introduction
2
SAS Functions
3
Case Study
Chapter 2 : Basic Queries
1
Overview of sql procedure
2
Specifying Columns
3
Specifying Rows
4
Presenting data
5
Summarizing data
6
Exercises
Chapter 3 : Combining Tables
1
Overview
2
Joins
3
Complex Joins
4
Set operators
5
Exercises
Chapter 4: Creating and modifying tables and views
1
Creating tables
2
Creating views
3
Creating Indexes
4
Maintaining Tables
5
Exercises
Chapter 5 : Additional SQL features
1
Setting PROC SQL Options
2
Dictionary Tables and Views
3
Interfacing PROC SQL with macro language
4
Program testing and performance
Chapter 6: Overview of table and column name
1
Table and Column names Sorted by Column names
2
Table and column names Sorted by table names
3
Partial table listings
Chapter 7: Dictonary Tables
Chapter 8: Highly Advanced Concepts
Chapter 9: Top 30 professional Programming techniques
SAS MACROS
Chapter 1: Introduction
1
Purpose of the macro facility
2
Program flow
3
Course data
Chapter 2 : Macro Variables
1
Introduction to Macro variables
2
Automatic Variables
3
Macro Variable References
4
User defined macro variables
5
Delimiting macro variables names
6
Macro Functions
Chapter 3: Macro definitions
1
Defining and calling a Macro
2
Macro Parameters
Chapter 4: DATA step and SQL Interfaces
1
Creating Macro variables in the data step
2
Indirect reference to macro variables
3
Retrieving macro variables in the data step
4
Creating macro variables in SQL
Chapter 5 : Macro Programs
1
Conditionally Processing
2
Iterative processing
3
Global and Local Symbol tables
Chapter 6 : Macro Execution Process
Chapter 7: Advanced Concepts
Chapter 8: Top 30 professional Programming techniques
Productivity Hacks to Get More Done in 2018
— 28 February 2017
- Facebook News Feed Eradicator (free chrome extension) Stay focused by removing your Facebook newsfeed and replacing it with an inspirational quote. Disable the tool anytime you want to see what friends are up to!
- Hide My Inbox (free chrome extension for Gmail) Stay focused by hiding your inbox. Click "show your inbox" at a scheduled time and batch processs everything one go.
- Habitica (free mobile + web app) Gamify your to do list. Treat your life like a game and earn gold goins for getting stuff done!