SAS PROC SQL Course
Comprehensive PROC SQL – SAS Training
Updated on Apr, 2024
Language - English
IT & Software,IT Certification,SAS PROC SQL
Lectures -92
Duration -13.5 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
SAS which stands for Statistical Analysis System is a software developed by the SAS Institute a private company based out of Cary, North Carolina, USA. Its primary objective is to be able to process large chunks of data and analyse it to aid in the process of intelligent decision-making. SAS has been widely accepted in the world and it accounts for almost 70% of the data processing marketplace.
Through this training, you shall learn SAS Proc SQL programming step by step with practical examples and projects.
The training will include the following;
- Basic Building Blocks
- More Building Blocks
- Joins
- Subqueries
- Set Operators
- Global Statements, Options, and Session Management
- Using the Macro Facility with PROC SQL
- Table Maintenance and Alternate Strategies
- Views
- PROC SQL as a Report Generator
- Mixed Solutions
- Performance Tuning
Target Customers:
- Statistical Business Analysts
- Data analysts
- Risk analysts
- Market researchers
- Statisticians
- Anyone who wants to learn statistical analysis using SAS
Prerequisites
What are the prerequisites for this course?
- Basic computer working knowledge
- The idea of creating data sheets with help of Excel software and workings of the same
Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction
1 Lectures
-
Introduction to Comprehensive PROC SQL - SAS Training
11:05
11:05
Statement
2 Lectures
Proc SQL Basic
4 Lectures
Proc SQL Function
4 Lectures
Proc SQL Clauses
3 Lectures
Proc SQL Data Set
2 Lectures
Basic Building Blocks
5 Lectures
Joins
6 Lectures
Sub Queries
2 Lectures
Set Operators
4 Lectures
Global Macros
6 Lectures
PROC SQL-STRUCTURES
2 Lectures
PROC SQL-DATA MAINTENANCE
2 Lectures
PROC SQL-METADATA
3 Lectures
Proc SQL-Data
4 Lectures
Proc SQL-Data with Examples
3 Lectures
Proc SQL-Dictionary and Proc SQL-Report Generator
3 Lectures
Proc SQL-Views
3 Lectures
Proc SQL-Formatting Output
3 Lectures
Proc SQL-Coding Logic
6 Lectures
Populating Data Using Proc SQL
4 Lectures
Proc SQL-Updating Indexes
3 Lectures
Coding Complex Queries
7 Lectures
Compex View
2 Lectures
Trouble Shooting and Debugging Techniques
3 Lectures
Tunning Code
2 Lectures
Subqueries Final
2 Lectures
Matrix Solution
1 Lectures
Instructor Details
Corporate Bridge Consultancy Private Limited
eCourse Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now