Synopsis
SAS 8: Combining and Updating Data Sets presents various methods for combining and updating existing SAS data sets.

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

Time
5 hours

Product Code: SASS09
After completing SAS 8: Combining and Updating Data Sets, the user should be able to:

Create new data sets through concatenating, interleaving or merging observations
Update a master data set with values from a transaction data set
Manipulate a SAS data set in place
Read a data set twice
Determine the source of an observation
Combine portions of data sets
Read only certain observations
Access observations nonsequentially

Concatenating Data Sets
Using the SET statement
Using PROC APPEND
Using SET vs. APPEND

Interleaving and Merging Data Sets
Interleaving
One-to-one merging
Match merging

Updating with UPDATE
Simple updates
Missing values
Processing updates
Changing values to missing
Summing values
Aging data set files

Updating with MODIFY
Updating a data set in place
Summing values
MODIFY vs. UPDATE
Refining MODIFY statements
Implications of updating in place

Using Other Techniques
Reading a data set twice
Determining the source of an observation
Combining portions of data sets
Reading only certain observations
Accessing observations nonsequentially

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 course index
A glossary
A Skill Assessment

SAS 8: Introduction (SASS01)
SAS 8: Using SAS (SASS02)
SAS 8: Data Manipulation (SASS03)
SAS 8: DATA Step Programming (SASS04)
SAS 8: Results (SASS05)
SAS 8: Display Manager System (SASS06)
SAS 8: Data Libraries (SASS07)
SAS 8: Inputting Data and PROC SQL (SASS08)

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.


Home | Training | Products | Specials | Tips | Resources
Copyright © 2001 - 2003 StaffKit, Inc.
All Rights Reserved.