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

Course Length:

This is a one day course.

Course Summary:

The Raw Data Handling course provides the means to read/create external data files, in both fixed width and delimited format, enabling the student to apply all the previously learnt data manipulation and reporting techniques to present it in a consistent manner using statements and functions.

What you will be taught:

    • Introduction
      • Understand the Data Step syntax to read Raw Data
      • Introduction to INFORMATS

 

    • Reading Raw Data
      • The INFILE and INPUT Statements
      • Simple input and Formatted input
      • 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 @
      • The PUTLOG Statement

 

 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) and 'Data Steps Techniques - The Language of SAS' course or have completed six months of developing code in the Language of SAS, including:

  • Building DATA steps
  • KEEP and DROP to select variables
  • IF and WHERE statements to select observations
  • Conditional Processing with IF-THEN-ELSE
  • The OUTPUT statement
  • Summarizing observations using RETAIN or SUM statement
  • System Formats

 


 

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.