Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

SAS Programming 2: Data Manipulation Techniques

GK# 2417

Course Overview

TOP

This course is for those who need to learn data manipulation techniques using SAS DATA and procedure steps to access, transform, and summarize SAS data sets. The course builds on the concepts that are presented in the SAS Programming 1: Essentials course and is not recommended for beginning SAS software users.

Certification:

SAS Certified Clinical Trials Programmer Using SAS 9

Schedule

TOP
  • Delivery Format:
  • Date:
  • Location:
  • Access Period:

$

Outline

TOP
Viewing outline for:

Classroom Live Outline

1. Introduction

  • Course logistics
  • Creating course data files

2. Controlling Input and Output

  • Writing observations explicitly
  • Writing to multiple SAS data sets
  • Selecting variables and observations

3. Summarizing Data

  • Creating an accumulating total variable
  • Accumulating totals for a group of data

4. Reading Raw Data Files

  • Reading raw data files with formatted input
  • Controlling when a record loads

5. Data Transformations

  • Manipulating character values
  • Manipulating numeric values
  • Converting variable type

6. Debugging Techniques

  • Using the PUTLOG statement

7. Processing Data Iteratively

  • DO loop processing
  • Conditional DO loop processing
  • SAS array processing
  • Using SAS arrays

8. Restructuring a Data Set

  • Rotating with the DATA Step

9. Combining SAS Data Sets

  • Using data manipulation techniques with match-merging

10. Creating and Maintaining Permanent Formats

11. Other SAS Languages

  • An overview of other languages
  • Using the SQL procedure
  • The SAS macro language

12. Learning More

  • SAS resources
  • Next steps

Labs

TOP
Viewing labs for:

Classroom Live Labs

Exercises or hands-on workshops are included with most SAS courses.

Prerequisites

TOP

Who Should Attend

TOP

SAS programmers and business analysts

Follow-On Courses

TOP
Course Delivery

This course is available in the following formats:

Classroom Live

Receive face-to-face instruction at one of our training center locations.

Duration: 3 day

Virtual Classroom Live

Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.

Duration: 6 day

Request this course in a different delivery format.
Enroll