Data Manipulations and Calculations by Using the DATA Step Functions
Presented: Friday September 7, 2018, 1:30pm-5:00pm
Arthur Li holds an M.S. in Biostatistics from the University of Southern California. Currently, he is a Biostatistician at the City of Hope National Medical Center. In addition, Arthur developed and taught an introductory SAS course at USC for the past 10 years, as well teaching the Clinical Biostatistics course at UCSD extension. As well as teaching and working on cancer-related research, Arthur has written a book titled Handbook of SAS DATA Step Programming.
SAS provides hundreds of functions and CALL routines to perform data manipulation, mathematical calculations, and descriptive statistical computations. This tutorial will start with reviewing the most useful functions that we encounter on a daily basis for data manipulation. Then we will focus on functions for character manipulation, including ones that utilize the Perl Regular Expression (PRX). The last component of this tutorial is an introduction to the FCMP Procedure, which allows users to build their own DATA step functions or CALL routines.
Intended Audience: Beginner
Tools Discussed: Base SAS
Prerequisite: Students should have a basic knowledge of SAS programming (such as creating SAS data sets and variables by using a DATA step).
- Introduction to Functions and CALL Routines
- Date and Time Functions
- Character Manipulation Functions
- Special Functions
- Functions that Use Perl Regular Expressions (PRX)
- Creating User-Defined Functions by Using the FCMP Procedure