title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.
SAS II: Data Manipulation with the SAS System
Duration
3 Days
Course
PLSA-125
Available Formats
Classroom Training
Course Description
Overview
This course is designed to teach intermediate-level SAS users to manipulateand manage data using SAS functions, DO loops, and SAS arrays.
Objectives
Upon completion of this course, students will be able to:
- Summarize the DATA step
- Read almost any kind of record layout to create a SAS data set
- Manipulate data using SAS functions – including many of the new SAS9 functions
- Read and generate data using DO loops
- Use SAS arrays to manipulate data
- Perform advanced joins of SAS data sets using the SET and MERGE statements
Audience
- SAS Users who have been using the SAS System for a short time and who want to move their understanding to the next level
Prerequisites
- SAS 1: Introduction to the SAS System or equivalent experience
Topics
- Course Overview
- Review of program flow
- Review of basic SAS concepts
- Reading Non-SAS data files with the DATA step
- Generating one observation from more than one record
- Reading files of different record layouts
- Generating more than one observation from only one record
- Reading hierarchical data
- Manipulating numeric values using the LAG, Date family, ROUND, CEIL, RANUNI, and Postal Code family of functions
- Manipulating character values using the PROPCASE, CAT family, ANY family, SUBSTR, SCAN, and INDEX family of functions
- Data conversion using the PUT and INPUT functions
- Other useful functions such as COMPRESS, TRANSLATE, RIGHT, LEFT and REVERSE functions
- Using the DATASET family of functions to learn more about your data
- Reading data with DO Loops
- Generating data with DO Loops
- Using DO Loops to make the job easier
- Array applications
- Transposing data with SAS arrays
- Transposing data with the TRANSPOSE procedure.
- SET statement applications
- Random sampling using the SET statement
- MERGE statement applications
- Comparing the DATA step with the SQL procedure
- How to create one observation from more than one record
- How to read files with different record layouts
- How to generate more than one observation from only one record
- How to read hierarchical data
- How to manipulate numeric and character values
- How to use functions for data conversion
- How to use other useful functions
- How to read hierarchical data
- How to read data with DO loops
- Generating data with DO loops
- Typical SAS applications using DO loops
- How to use SAS Arrays
- Using SAS arrays to transpose SAS data sets
- How to use special tools to read a SAS data set
- How to perform complex joins with the SAS System
- How to use special tools while joining SAS data sets
- How to perform random sampling with the SAS system (with and without replacement)
- How to use SAS data sets in table lookup applications
Related Courses
-
SAS 1: Introduction to the SAS System
PLSA-115- Duration: 3 Days
- Delivery Format: Classroom Training
- Price: 2,100.00 USD
Self-Paced Training Info
Learn at your own pace with anytime, anywhere training
- Same in-demand topics as instructor-led public and private classes.
- Standalone learning or supplemental reinforcement.
- e-Learning content varies by course and technology.
- View the Self-Paced version of this outline and what is included in the SPVC course.
- Learn more about e-Learning
Course Added To Shopping Cart
bla
bla
bla
bla
bla
bla
Self-Paced Training Terms & Conditions
??spvc-wbt-warning??
Exam Terms & Conditions
??exam-warning??
??group-training-form-area??
??how-can-we-help-you-area??
??personalized-form-area??
??request-quote-area??
Sorry, there are no classes that meet your criteria.
Please contact us to schedule a class.
STOP! Before You Leave
Save 0% on this course!
Take advantage of our online-only offer & save 0% on any course !
Promo Code skip0 will be applied to your registration
Nothing yet
Purchase Information
??elearning-coursenumber?? ??coursename??
View Cart
title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.