SAS Programming 1: Essentials

This course is for users who want to learn how to write SAS programs. It is the entry point to learning SAS programming and is a prerequisite to many other SAS courses.

Learn how To:

    • Navigate the SAS windowing environment
    • Read various types of data into SAS data sets
    • Validate and clean SAS data sets
    • Create SAS variables and subset data
    • Combine SAS data sets
    • Create and enhance listing and summary reports.

Who Should Attend:

Anyone getting started writing SAS programs

Prerequisites:

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

    • No prior SAS experience is needed
    • Understand file structures and system commands on your operating systems
    • Access data files on your operating systems.

Course Contents:

1. Getting Started with SAS

  • Introduction to SAS programs
  • Submitting a SAS program

2. Working with SAS Syntax

  • Mastering fundamental concepts
  • Diagnosing and correcting syntax errors

3. Getting Familiar with SAS Data Sets

  • Examining descriptor and data portions
  • Accessing SAS data libraries
  • Accessing relational databases (Self-Study)

4. Reading SAS Data Sets

  • Introduction to reading data
  • Using SAS data as input
  • Subsetting observations and variables
  • Adding permanent attributes

5. Reading Excel Worksheets

  • Using Excel data as input
  • Doing more with Excel worksheets (Self-Study)

6. Reading Delimited Raw Data Files

  • Using standard delimited data as input
  • Using nonstandard delimited data as input

7. Validating and Cleaning Data

  • Introduction to validating and cleaning data
  • Examining data errors when reading raw data files
  • Validating data with the PRINT and FREQ procedures
  • Validating data with the MEANS and UNIVARIATE procedures
  • Cleaning invalid data

8. Manipulating Data

  • Creating variables
  • Creating variables conditionally
  • Subsetting observations

9. Combining SAS Data Sets

  • Introduction to combining data sets
  • Appending a data set
  • Contenating data sets
  • Merging data sets one-to-one
  • Merging data sets one-to-many
  • Merging data sets with non-matches

10. Enhancing Reports

  • Using global statements
  • Adding labels and formats
  • Creating user-defined formats
  • Subsetting and grouping observations
  • Directing output to external files

11. Producing Summary Reports

  • Using the FREQ procedure
  • Using the MEANS procedure
  • Using the TABULATE procedure (Self-Study)

3 thoughts on “SAS Programming 1: Essentials

  1. fernissa says:

    apa komtek buka pelatihan SAS???

  2. hadi says:

    kapan nih trainingnya dimulai?

  3. lukehendri says:

    apa ini adalah session yg sama dengan SAS Programming 1 atau SAS Macro, mohon pencerahannya

Leave a Reply