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.
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.