SAS® Programming: Data Manipulation Techniques
Duration: 3 days
If you experience any problems with our on-line booking service, you can call us on
+44 (0)131 225 6952.
Description
This three-day course builds on the concepts presented in the SAS® Essentials:
An Introduction to SAS® Programming: Data Manipulation Techniques course. It focuses on how to manage SAS data set input and output, work
with different data types and manipulate data.
Objectives
After attending this course you will be able to:
- read and write different types of data
- combine SAS data sets
- summarize data
- perform data manipulation and transformation using SAS functions
- use options and statements to identify logic problems
- process data iteratively
- use arrays
- understand DATA step processing
Prerequisite Skills
Before attending this course, you should have completed a SAS® Essentials: An Introduction
to SAS® Programming course or have at least six months of experience writing SAS programs
Specifically you should be able to:
- understand file structure and write system commands to create and access files on your operating system
- write DATA and PROC steps
- explore the structure and contents of a SAS data set
- understand error messages in the SAS Log and debug your programs
- understand programming logic concepts (IF/THEN logic)
- create a SAS data set from an external file
- use SAS to access SAS data libraries
- use TITLE statements
- read a SAS data set using a SET statement
- perform a simple merge using a MERGE statement
- use DROP= and KEEP= data set options
- create and use SAS date values
SAS® System Modules used
This course covers Version 9 of Base SAS®.
Course Topics
Introduction
Controlling Input and Output
- outputting multiple observations
- writing to multiple SAS data sets
- selecting variables and observation
Summarizing Data
- creating an accumulating total variable
- accumulating totals for groups of data
Reading and Writing Different Types of Data
- reading delimited raw data files
- controlling when a record loads
- reading hierarchical raw data files
- writing to an external file
Data Transformations
- introduction
- manipulating character values
- manipulating numeric values
- manipulating numeric values based on dates
- converting data types
Debugging Techniques
- using the PUT statement
- using the DEBUG option
Processing Data Iteratively
- DO loop processing
- SAS array processing
- using SAS arrays
Combining SAS data sets
- match-merging two or more SAS data sets
- simple joins using the SQL procedure
Reserve your place on this Newtyne SAS Training Course
|
