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

 

 



 Course Search
Keyword
Course #
State

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


Using SQL In SAS Programming Overview


Topics

Introduction to SQL Procedure

Constructing a Simple Query

SELECT

FROM

WHERE

Arithmetic Expressions

Formats

Selecting Rows -  WHERE

Grouping and Ordering Data

Functions

HAVING

Selecting Rows Based on Summaries

CASE Logic

Creating Tables

LIKE

Column Definitions

Creating Indexes

Modifying Tables

ALTER

UPDATE

INSERT

DELETE

Joining Tables

Table Aliases

Inner Joins

Outer Joins

Reflexive Joins

Views

Creating

Multiple Tables

Subqueries

Accessing External Tables

 

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.