SASCRUNCH TRAINING
  • Home
  • SASĀ® Certification Training
    • SAS Certified Specialist Exam Training Program
    • How to Prepare For SAS Certified Specialist Base Programming Exam
  • Online Courses
    • Practical SAS Training Course for Beginners
    • Proc SQL Course
    • SAS Project Training Course
    • Logistic Regression (Credit Scoring) Modeling using SAS
  • Articles
    • Get Started >
      • 18 Free Resources to Help You Learn SAS
      • SAS Tutorial
      • How to Install SAS Studio
      • How to Learn SAS Fast
    • Data Import >
      • Importing Excel Spreadsheet
      • Importing CSV Files
      • Importing Text Files
    • SAS Functions >
      • CAT, CATT, CATS, CATX Functions
      • If-Then-Else statement
      • TRIM Function
      • STRIP Function
      • YEAR, MONTH, DAY Functions
      • Compress Function
      • Do-Loop
      • SCAN Function
      • LIKE Operator
      • INDEX Function
    • Data Manipulations >
      • The Ultimate Guide to Proc SQL
      • Proc Datasets
      • Dictionary Tables
      • Dealing with Missing Values
      • Proc Compare
      • Proc Transpose
      • RETAIN Statement
      • SAS Formats
      • SAS Arrays
    • Statistical Analysis >
      • Proc Means
      • Proc Freq
      • Proc Tabulate
    • Machine Learning >
      • Predicting Fish Species Using K-nearest Neighbor in SAS
      • Classify Product Reviews on Amazon Using Naive Bayes Model in SAS
    • Informational Interviews >
      • How to get a Clinical Trial/Research job without experience
      • Senior Recruiter at a Fortune 500 Retail Company
      • Manager, Non-profit Health Services Research
      • HR Manager
      • Quantitative Analyst
  • Services
    • The Ultimate Job Search Automation Services
    • Statistical Consulting
    • SAS Project or Assignment Help
    • Data Import Services
    • Data Manipulation and Reporting Services
  • In-class Training
    • SAS Training for Job Seekers
  • Guest Lecture
  • Sample Resume
  • About us
  • Contact Us
Master SAS
​in 30 Days
Start your Free training now!
x
Picture
Need help studying for the new
SAS Certified Specialist Exam?
Get access to:
  • Two Full Certificate Prep Courses
  • ​300+ Practice Exercises
Picture
Start your free training now
How to Prepare for the SAS Certified Specialist Base Programming Exam
Picture
 

Proc SQL Course (Part 1)


PROC SQL greatly increases SAS’s flexibility in handling data, especially for multiple-table joining and database access, and has been widely used for SAS users, especially advanced SAS users.
​
​This course is the first course (Part 1) for SAS Programming on Proc SQL.

It is an intermediate level course. It is designed to help you master Proc SQL programing skills and also help prepare you for the SAS certification exams.​
​
Fee: $35
Rating: 4.9
30 Days
(money-back guarantee)
Learn Proc SQL Now

About This Course


In this course, you will learn essential SAS Proc SQL programming skills including:
  • Retrieving data from a single table by using the SELECT statement and its clauses(including SELECT clause, FROM clause, WHERE clause, GROUP BY clause, HAVING clause, ORDER BY clause)
  • Retrieving Data from Multiple Tables Using Joins including inner joins, outer joins and special joins as well as comparison of merges with joins
  • Using Subqueries to Select Data including single value or multiple values of subqueries, testing for the existence of a group of values, correlated subqueries, combining a Join with a subquery, and multiple Levels of subquery nesting
  • Combine Queries with Set Operators including UNION, EXCEPT, INTERSECT and OUTER UNION
Learn Proc SQL Now

Who is this class for?


​This course is for:
  • Students or professionals who wants to learn SAS Proc SQL programming skills, which are highly demanded skills in SAS and statistics industry
  • Students or professionals who wants to become an advanced SAS programmer, and be more demanded and successful in their SAS career
  • Students or professionals who wants to take SAS Programming Certification Exams
Learn Proc SQL Now

Requirements


​Students or professionals who plan to take this course need to have basic knowledge about SAS base programming.

You can learn SAS base programming here. 
Learn Proc SQL Now

Instructor


​Sharon Cheng
  • Online Instructor at SCStatisticalProgramming.com
Learn Proc SQL Now

Course Outline


  • Section 1: Proc SQL introduction
  • Section 2: Retrieving Data from a Single Table
  • Section 3: Retrieving Data from Multiple Tables using Joins
  • Section 4: Using Subqueries to Select Data
  • Section 5: Combine Queries with Set Operators
Learn Proc SQL Now

Disclosure: we are an affiliate for the course we recommended on this page. We will receive a commission if you purchase a course through our links.

 

Master SAS in 30 Days

Start your Free training now!
Copyright © 2012-2019 SASCrunch.com All rights reserved.
  • Home
  • SASĀ® Certification Training
    • SAS Certified Specialist Exam Training Program
    • How to Prepare For SAS Certified Specialist Base Programming Exam
  • Online Courses
    • Practical SAS Training Course for Beginners
    • Proc SQL Course
    • SAS Project Training Course
    • Logistic Regression (Credit Scoring) Modeling using SAS
  • Articles
    • Get Started >
      • 18 Free Resources to Help You Learn SAS
      • SAS Tutorial
      • How to Install SAS Studio
      • How to Learn SAS Fast
    • Data Import >
      • Importing Excel Spreadsheet
      • Importing CSV Files
      • Importing Text Files
    • SAS Functions >
      • CAT, CATT, CATS, CATX Functions
      • If-Then-Else statement
      • TRIM Function
      • STRIP Function
      • YEAR, MONTH, DAY Functions
      • Compress Function
      • Do-Loop
      • SCAN Function
      • LIKE Operator
      • INDEX Function
    • Data Manipulations >
      • The Ultimate Guide to Proc SQL
      • Proc Datasets
      • Dictionary Tables
      • Dealing with Missing Values
      • Proc Compare
      • Proc Transpose
      • RETAIN Statement
      • SAS Formats
      • SAS Arrays
    • Statistical Analysis >
      • Proc Means
      • Proc Freq
      • Proc Tabulate
    • Machine Learning >
      • Predicting Fish Species Using K-nearest Neighbor in SAS
      • Classify Product Reviews on Amazon Using Naive Bayes Model in SAS
    • Informational Interviews >
      • How to get a Clinical Trial/Research job without experience
      • Senior Recruiter at a Fortune 500 Retail Company
      • Manager, Non-profit Health Services Research
      • HR Manager
      • Quantitative Analyst
  • Services
    • The Ultimate Job Search Automation Services
    • Statistical Consulting
    • SAS Project or Assignment Help
    • Data Import Services
    • Data Manipulation and Reporting Services
  • In-class Training
    • SAS Training for Job Seekers
  • Guest Lecture
  • Sample Resume
  • About us
  • Contact Us