HARTMANN software group

SAS Programming 2: Beyond the Basics Training in Nashville

Enroll in or hire us to teach our SAS Programming 2: Beyond the Basics class in Nashville, Tennessee by calling us @303.377.6176. Like all HSG classes, SAS Programming 2: Beyond the Basics may be offered either onsite or via instructor led virtual training. Consider looking at our public training schedule to see if it is scheduled: Public Training Classes
Provided there are enough attendees, SAS Programming 2: Beyond the Basics may be taught at one of our local training facilities.
We offer private customized training for groups of 3 or more attendees.
get pricing information

Course Description

  
This course is for those who need to perform advanced data processing and manipulation, and create a variety of outputs. SAS Programming 2 builds on the concepts that are presented in the SAS Programming 1: Fundamentals course and is not appropriate for beginning SAS software users.
 
This course use data from the SASHELP library installed with the software. These courses can be taught
 
using SAS Version 9 or higher
any operating system (focus is either Windows or Linux/Unix. If using MVS you may need to modify as necessary)
any interface (SAS Enterprise Guide is the focus. If using SAS Studio or SAS Display Manager you may need to modify slightly as necessary)
Course Length: 3 Days
Course Tuition: $1290 (US)

Prerequisites
You must have at least six months of experience writing SAS programs or have completed the SAS Programming 1: Fundamentals course and used SAS for at least one month.

Course Outline

  
  • Introduction
    • Explain course logistics.
    • Explain course overview.
    • Review SAS syntax.
  • Controlling Input and Output
    • Use the Delete, Output, and subsetting IF statements to control writing data.
    • Create multiple data sets in the same DATA step.
    • Use DROP and KEEP to control variables output.
    • Use FIRSTOBS and OBS to control observations input.
  • Manipulating Data with Functions
    • Review the purpose of functions.
    • Manipulate character data by changing the case, combining and extracting strings, and other data manipulation techniques.
    • Use summary functions in the DATA step.
    • Use SAS Date functions to manipulate SAS data variables and create SAS dates.
    • Convert a variable from one data type to another.
  • Summarizing Data
    • Create an accumulating total variable.
    • Accumulate totals for a group of data.
  • Processing Data Iteratively
    • Perform repetitive processing with DO-loops.
    • Describe SAS array processing.
    • Use SAS arrays.
  • Restructuring a Data Set
    • Rotate data with the DATA step.
    • Use the TRANSPOSE procedure.
  • Combining SAS Data Sets
    • Use the IN= option with match-merging in the DATA Step.
    • Join data using PROC SQL.
  • Creating User Defined Formats
    • Create a format using PROC FORMAT.
    • Use a created format.
  • Writing Flexible Code with the SAS Macro Facility
    • Use macro variables for text substitution.
    • Write simple macro definitions.
    • Supply parameters.
  • Enhancing Your Output
    • Describe the concepts of the Output Delivery System.
    • Create Text Output.
    • Create HTML Output.
    • Create RTF Output.
    • Create PDF Output.
  • Debugging Your SAS Programs
    • Use the DEBUG option.
    • Use the PUTLOG statement.

Course Directory [training on all levels]

Technical Training Courses
Software engineer/architect, System Admin ... Welcome!
Business Training Courses
Project Managers, Business Analysts, Paralegals ... Welcome!
Upcoming Classes
Gain insight and ideas from students with different perspectives and experiences.

Interesting Reads Take a class with us and receive a book of your choosing for 50% off MSRP.