SAS Certification Prep Guide: Base Programming for SAS 9, Third Edition

Overview

Introduction

Raw data files can be hierarchical in structure, consisting of a header record and one or more detail records. Typically, each record contains a field that identifies the record type.

Here, the P indicates a header record that contains a patient's ID number. The C indicates a detail record that contains the date of the patient's appointment and the charges that the patient has incurred.

You can build a SAS data set from a hierarchical file by creating one observation per detail record, retaining the patient ID from the header record.

You can also build a SAS data set from a hierarchical file by creating one observation ...