Data Step Techniques - The Language of SAS
Simply fill in the form below to sign up for our Newsletter:
captcha 
Sign Up for our Newsletter

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

 

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 Statement
    • 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
    • Simple input and Formatted input
    • INFORMATS
    • Fixed-Width Columnar Data
    • Absolute / Relative Pointer Control
    • Delimited Data
    • DLM= and DSD Options
    • The Colon Modifier
    • Detecting Errors
    • The DATALINES Statement
    • Record Handling - FLOWOVER, MISSOVER, TRUNCOVER, STOPOVER
    • Handling Variable Length Records
    • Multiple INPUT Statements
    • Absolute Line-Pointer Control
    • The Single Trailing @
    • The Double Trailing @
    • Hierarchical Raw Data
  • Writing to External Files
    • DATA _NULL_
    • The FILE and PUT Statements
    • Simple Output and Formatted Output
    • Fixed-Width Columnar Output
    • Delimited Output
    • Multiple PUT Statements
    • The Single Trailing @
    • The Double Trailing @

 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 the dates below do not suit please contact us on +44 (0)131 225 6952 as alternative dates can be arranged.

 


 

Don't Delay - Book Today!

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