SAS Programming 1: Fundamentals

SAS Programming 1: Fundamentals Courseware (SASPRG1)

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)
  • your installation of SAS, or SAS On Demand for Academics (free version of SAS for learning purposes)

Benefits

At the end of this course students will be able to:

  1. Understand the basics of using the Base SAS system.
  2. Understand how to write simple SAS programs.
  3. Identify basic, common table processing tasks: sorting, summarizing, merging and reporting.

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.

Required Prerequisites

Before attending this course, you should have experience using computer software. Specifically, you should:

  • Understand file structures on your operating system.