SAS 8

Synopsis
SAS: Inputting Data and PROC SQL describes ways to create and manipulate SAS data sets, including an introduction to using the SQL procedure in SAS.

Audience
This course is for end users, programmers and business professionals who have an introductory level of experience with SAS.

Time
4 hours

Product Code: SAS608

After completing SAS: Inputting Data and PROC SQL, the user should be able to:

Describe various input styles used with the INPUT statement

Use the INPUT and INFILE statements to handle external files

Explain the basics of using SQL with SAS

Use PROC SQL to query data sets and generate reports

Input Styles
Overview

List input

Column input

Formatted input

Named input

Reading External Files
Multiple records per observation

Multiple reads per record

INFILE statement options

Introduction to SQL
SQL basics

SELECT statement – required clauses

SELECT statement – optional clauses

Using PROC SQL
Joining tables

Creating tables, views and indexes

Modifying tables

This course has the following features:

Exercises that allow users to practice in SAS

A file containing the text of the exercises

Simulations that allow users to practice course skills, even if they don't have access to SAS

A glossary

A Skill Assessment

SAS: Introduction (SAS601)

SAS: Using SAS (SAS602)

SAS: Data Manipulation (SAS603)

SAS: DATA Step Programming (SAS604)

SAS: Results (SAS605)

SAS: Display Manager System (SAS606)

SAS: Data Libraries (SAS607)

SAS: Combining and Updating Data Sets (SAS609)

SAS is a registered trademark of SAS Institute Inc.

Get more out of your Software
Improve your Skills
Prepare for Certification
Save time every time and reduce frustration.

Our online training material lets you:
TEST your skills
LIST the areas where you need additional training
Take lessons that TEACH SKILLS to improve these areas
Tests your skills again

NO HIDDEN CHARGES.
NO SETUP or SHIPPING CHARGES.
NO ads or banners in the training material.
No selling of your personal information, no email lists.
Just 100% Quality Training at one low price.

Repeat the courses as often as you need, you have 12 months of unlimited access and can view your scores anytime so you can easily track your progress.

Our training is tested and guaranteed to provide RESULTS and save you TIME.

All courseware is online 24 hours a day.
Our courseware is optimized so content delivery is fast even with a 28.8 modem connection.
If you can get on the Internet you can access the training, ANYWHERE, ANYTIME.