KT-4000 Using SQL In SAS Programming Training - Minneapolis, Minnesota IT MN Technical Financial New York, NY
Knowledge Transfer Microsoft Certified Silver Training Partner CPLS
Knowledge Transfer is a Microsoft Certified Silver Learning Partner
Oracle University


Microsoft Certified Training Partner CTEC
Search for a Course Topic:
Public Courses
Corporate Services & Training



 Course Search
Course #

 Training Delivery
Training Delivery
Custom Curriculum
Course List
 Main Menu
View Courses
Site Index

Using SQL In SAS Programming


Structured Query Language (SQL) has been added to the base SAS system in order to take advantage of this standardized structured coding language.  No additional purchase is necessary for you to use this tool.  PROC SQL is a natural for individuals who are already familiar with SQL coding as well as new users to whom it would be valuable to learn this emerging language.  SQL allows ready access to many different file types and data bases with the same general metaphor of relational design and data representation of tables of rows and columns.  This language also has the particular advantage in SAS of  both a simpler and more efficient alternative to the match-merge.  

This course focuses on using Structured Query Language (SQL) for data retrieval within SAS programs from SASdatasets.  Emphasis will be placed on extracting and manipulating data from multiple files or tables with simple and concise queries.

Course objectives:

Upon completion, the student will be able to perform queries on data using:

  • Column and row  selection
  • Use column calculations and functions
  • Summarize data
  • Retrieve data from multiple sources using JOINs, UNIONs and other methods
  • Create views,  tables and indices


Click here to view the Course Outline

Knowledge of  basic SAS programming including:

  • Submitting SAS programs on your operating system
  • Creating and accessing SASdatasets
  • Invoking SAS Procedures
  • Using arithmetic, comparison, and logical operations



2 Days  

View Printer Friendly Page


To Inquire About Future Classes

Request a class date

if one is not scheduled.

Comments on the Course

This class is only offered privately for a group. There are no public sessions of this class.

The SAS workshops have all been developed in house by our consultant/instructors.  Our instructors hold SAS Certifications in V8 and keep current through SAS Workshops and Consulting projects.  We offer a wide variety of on-site training courses.  All of our courses are modularized so the curriculum can be tailored to meet your training needs.