Creating One Observation per Detail Record

The Basics of Creating One Observation per Detail Record

In order to create one observation per detail record, it is necessary to distinguish between header and detail records. Having a field that identifies the type of the record makes this task easier.
In the partial raw data file Census shown below, H indicates a header record that contains a street address, and P indicates a detail record that contains information about a person who lives at that address.
Partial Raw Data File

Retaining the Values of Variables

While writing the DATA step to read this file, remember that you want to keep the header record as ...

Get SAS Certification Prep Guide, 4th Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.