SAS Programming 2: Data Manipulation Techniques

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.

Duration 3 Days
Certificate SAS Global
Language English

Fees 18000 + taxes


Power up your staff’s skills and boost your business

@

or Call us on +91 78294 87000


Course Description

Learn data manipulation techniques using SAS DATA and procedure steps to access, transform, and summarize SAS data sets. 

About Program

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.

This course can help prepare you for the following certification exam(s): SAS Base Programming for SAS 9SAS Certified Clinical Trials Programmer Using SAS 9.

Format of Training

Live Web Classroom

Training is Led by an expert instructor live online using live web training platform, and this are not pre recorded lectures. Trainer can virtually look over your shoulder. Discuss, share, exchange ideas with students from different countries. 

Taste of Live Web - is a perfect platform for indivudals who fear online training. SAS® gives an opportunity to all the registrants to have a closer look at different courses given below with a blend of Online Learning. 

All the benefits of the classroom without the travel:

Classroom training options include courses offered in our regional training centers or via our Live Web classroom.

Taught by certified instructors at High-Tech facilities across the country:

  • A SAS expert at your side.
  • Focused learning away from the office
  • Networking opportunities
  • State-of-the-art facilities
  • Electronic course notes downloadable to your device and permission to print
  • Business Knowledge Series: in-depth courses on the latest business topics
  • We offer Connected Classes! Watch for courses in Cary, New York, Arlington, Dallas and San Francisco that connect remote students via our Live Web classroom.

Self Paced Learning Platform

SAS e-learning courses are online, hands-on tutorials that you can access whenever and wherever is convenient for you – satisfaction guaranteed. All you need is an internet connection. With e-learning from SAS, you can:

  • Train when and where you want.
  • Learn at your own pace.
  • Access the same content as our instructor-based courses, only optimized for self-study.
  • Earn a certificate of completion.
  • Benefit from courses created by SAS experts.

Free Training e-learning subscription - please connect with us

Get a quick, easy start with SAS® online training – or expand your learning without spending a dime.

Prerequisite

Before attending this course, you should have at least six months of experience writing SAS programs or have completed the SAS Programming 1: Essentials course and used SAS for at least one month. Specifically, you should be able to

  • submit a SAS program
  • diagnose and correct syntax errors
  • examine descriptor and data portions of a SAS data set
  • access SAS data libraries
  • read and create SAS data sets
  • read Excel spreadsheets
  • read delimited raw data files
  • examine data errors when reading raw data files
  • use SAS procedures to validate data
  • clean invalid data
  • create variables
  • combine SAS data sets
  • use global statements
  • use labels and formats, including user-defined formats
  • subset observations
  • produce summary reports using the FREQ and MEANS procedures.

This course addresses Base SAS software.

This course is appropriate for students who are using SAS 9 software.

Training Features

  • control SAS data set input and output
  • combine SAS data sets
  • summarize, read, and write different types of data
  • perform DO loop and SAS array processing
  • transform character, numeric, and date variables.

Course Curriculum

Introduction

  • course logistics
  • creating course data files

Controlling Input and Output

  • writing observations explicitly
  • writing to multiple SAS data sets
  • selecting variables and observations

Summarizing Data

  • creating an accumulating total variable
  • accumulating totals for a group of data

Reading Raw Data Files

  • reading raw data files with formatted input
  • controlling when a record loads

Data Transformations

  • manipulating character values
  • manipulating numeric values
  • converting variable type

Debugging Techniques

  • using the PUTLOG statement

Processing Data Iteratively

  • DO loop processing
  • conditional DO loop processing
  • SAS array processing
  • using SAS arrays

Restructuring a Data Set

  • rotating with the DATA step

Combining SAS Data Sets

  • using data manipulation techniques with match-merging

Creating and Maintaining Permanent Formats

  • creating permanent formats

Other SAS Languages

  • an overview of other languages
  • using the SQL procedure
  • the SAS macro language

Learning More

  • SAS resources
  • next steps

Project

  • manipulating character values
  • manipulating numeric values
  • converting variable type

FAQs

Each exam challenges candidates to apply specific knowledge they have acquired through SAS software training and/or job experience. Computer-based in format, SAS Global Certification exams comprise multiple-choice and/or short-answer questions, depending on the exam. Exams are generally scheduled through Pearson VUE but are also held at various locations around the world on a pre-scheduled basis. Candidates are allotted varying time limits to complete the exam, depending on which exam is taken. Specific exam content and passing criteria are located within each exam. To encourage your feedback, SAS Global Certification exams include a feature that allows candidates to comment on specific test questions. Your opinions are important to us and are a critical component in test development. Additionally, SAS Global Certification requires candidates to accept the terms of the SAS Institute Inc. Certification Program CandidatCancele Agreement before taking a certification exam.

Short-answer questions require you type your answer in a text box, rather than select your answer from four options. Typically, you will provide a numeric answer or a short section of SAS programming code. When entering code, case is ignored, and all variations of SAS syntax that correctly complete the program are accepted as correct.

Course Fees

Live Web

  

  

24000

+ Applicable Taxes
Enroll Now

e-learning

  

  

18000

+ Applicable Taxes
Enroll Now