Call : (+91) 968636 4243
Mail : info@EncartaLabs.com
EncartaLabs

SAS Programming - Data Manipulation Techniques

( Duration: 3 Days )

This SAS Programming - Data Manipulation Techniques training course is for those who need to learn data manipulation techniques using the SAS DATA step and procedures to access, transform, and summarize data. The course builds on the concepts that are presented in the SAS Programming - Essentials course and is not recommended for beginning SAS software users.

By attending SAS Programming - Data Manipulation Techniques workshop, delegates will learn to:

  • Understand and control DATA step processing
  • Create an accumulating column and process data in groups
  • Manipulate data with functions
  • Convert column type
  • Create custom formats
  • Concatenate and merge tables
  • Process repetitive code
  • Restructure tables

  • Write DATA step code to subset rows and columns, compute new columns, and process data conditionally
  • Sort tables using the SORT procedure
  • Apply SAS formats

The SAS Programming - Data Manipulation Techniques class is ideal for:

  • Business analysts and SAS programmers

COURSE AGENDA

1

Controlling DATA Step Processing

  • Understanding DATA step processing
  • Directing DATA step output
2

Summarizing Data

  • Creating an accumulating column
  • Processing data in groups
3

Manipulating Data with Functions

  • Understanding SAS functions and CALL routines
  • Using numeric and date functions
  • Using character functions
  • Using special functions to convert column type
4

Creating Custom Formats

  • Creating and using custom formats
  • Creating custom formats from tables
5

Combining Tables

  • Concatenating tables
  • Merging tables
  • Identifying matching and nonmatching rows
6

Processing Repetitive Code

  • Using iterative DO loops
  • Using conditional DO loops
7

Restructuring Tables

  • Restructuring data with the DATA step
  • Restructuring data with the TRANSPOSE procedure

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting https://www.encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top
Notice
X