DURATION | PRICE | inc-VAT | |
---|---|---|---|
1 | £425 | £510 | |
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'LL 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