HARTMANN software group

SAS Programming 1: Fundamentals Training in Mount Vernon

Enroll in or hire us to teach our SAS Programming 1: Fundamentals class in Mount Vernon, New York by calling us @303.377.6176. Like all HSG classes, SAS Programming 1: Fundamentals 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 1: Fundamentals 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 SAS Programming 1: Fundamentals foundation course is for people who need to write SAS programs to access, explore, prepare, and analyze data. The course focuses on the following key areas: reading SAS data sets, creating SAS variables and recoding data values, filtering data, and combining multiple SAS data sets.
 
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: 2 Days
Course Tuition: $790 (US)

Prerequisites
Before attending this course, you should have experience using computer software. Specifically, you should: Understand file structures on your operating system.

Course Outline

  
  • Getting Started
    • Describe the basics of a SAS program.
    • List the portions of a SAS data set.
    • List the required attributes of a variable.
    • List the types of variables.
    • Describe the SAS naming conventions.
    • Identify where SAS data sets are stored.
  • Getting Started with the SAS Interface
    • Using SAS Enterprise Guide®
      • Open SAS Enterprise Guide.
      • Explain EG projects.
      • Work with workflows.
      • View the data portion of a SAS data set.
      • View the descriptor portion of a SAS data set.
    • Using SAS Studio ®
      • Open SAS Studio.
      • Describe the interface.
      • View the data portion of a SAS data set.
      • View the descriptor portion of a SAS data set.
  • Using DATA Steps and PROC Steps
    • Create and submit a DATA step.
    • Use PROC CONTENTS to display the descriptor portion.
  • Manipulate Data
    • Create new variables using an assignment statement.
    • Use functions on character variables.
    • Use functions on numeric variables.
    • Use date functions.
    • Perform conditional processing.
    • Set the length of a variable.
  • Sorting, Printing, and Summarizing Your Data
    • Display the data portion of a SAS data set.
    • Add titles to a report.
    • Filter the data in a PROC step.
    • Change how a variable name displays.
    • Sort the data.
    • Create a summary report.
    • Create a frequency report.
  • Stacking SAS Data Sets
    • Stack (concatenate) SAS data sets.
  • Combining SAS Data Sets
    • Combining Data Sets Using a One-to-One Match Merge.
    • Combining Data Sets Using a One-to-None Match Merge.
    • Combining Data Sets Using a One-to-Many Match Merge.
  • Introduction to PROC SQL
    • Describe Structured Query Language (SQL).
    • Explain how SQL is used.
  • Simple PROC SQL Queries
    • Display all columns in a table.
    • Display select columns from a table.
    • Create column alias.
    • Select a subset of rows in a query.
    • Sort data for report.
  • Creating Permanent Data Sets
    • Write SAS data sets out to a permanent library.

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.