Articles

Data Step Techniques - The Language of SAS
  • Print

Data Step Techniques - The Language of SAS training at Newtyne, Edinburgh

 

If you experience any problems with our on-line booking service, you can call us on +44 (0)131 225 6952.

Course Length:

This is a three-day course.

Course Summary:

The Data Step Techniques Course builds on the learnings of the Foundations course and provides the student with an immediately useful armoury of new statements and functions.

What you will be taught:

  • Introduction
    • Course Data
    • Review of 'Foundations - The Language of SAS'
  • The OUTPUT Statement
    • The OUTPUT Statement
    • Outputting to Multiple Datasets
    • Selecting Observations
    • Selecting Variables
  • Summarizing Observations
    • The RETAIN Statement
    • The SUM Statment
    • BY-GROUP Processing
  • Manipulating Data using Functions
    • Transforming Character Variables
    • Transforming Numeric Variables
    • Transforming Date Variables
    • Changing Variable Type
  • Debug programs using PUT Statements
    • The PUT Statement
    • The PUTLOG Statement
  • Iterative Processing
    • DO Loops
    • DO WHILE and DO UNTIL Loops
  • Array Processing
    • Defining an ARRAY
    • Using an ARRAY to Create Variables
    • ARRAYs with Initial Values
    • The _TEMPORARY_ Keyword
    • Using an ARRAY with Existing Variables
    • Using an ARRAY to Transpose Data
  • Reading Raw Data
    • The INFILE and INPUT Statements
    • Fixed-Width Column Data
    • Data Errors
    • Formatted Data
    • INFORMATS
    • Detecting Errors
    • The DATALINES Statement
    • The Single Trailing @
    • The Double Trailing @
    • Delimited Data
    • The DSD Option

 What you should already know:

In order to gain a suitable understanding from this course, it is expected that you should have attended the, 'Foundations: The Language of SAS' course (or comparable course of study), or have completed six months of developing code in the language of SAS, including:

  • Building DATA and PROC steps
  • Character, Numeric and Date functions
  • KEEP and DROP to select variables
  • IF and WHERE statements to select observations
  • Conditional Processing with IF-THEN-ELSE
  • Combining Data Sets vertically and horizontally
  • Summarizing data with the FREQ, MEANS and TABULATE procedures

 

 

If you experience any problems with our on-line booking service, you can call us on +44 (0)131 225 6952.

 

Don't Delay - Book Today!

Select a date and click on the button below to register.