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
Keyword
Course #
State

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


Using SQL In SAS Programming


Description: 

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
     
Prerequisite: 

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

 

 

 
   
     
Duration: 
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.