Raw Data File

1---+----10---+----20
P  1095        $45.0
C  01-08-89    $37.5
C  01-17-89    $156.5
P  1096        $109.0
C  01-09-89    $45.0
P  1097        $45.0
C  01-02-89    $37.0
P  1099        $45.0
C  01-03-89
C  01-05-89
P  1201
C  01-05-89
C  01-10-89

You can build a SAS data set from a hierarchical file by creating one observation per detail record and storing each header record as part of the observation.

SAS Data Set

Obs	ID	Date	Amount
1	1095	01/08/89	$45.00
2	1095	01/17/89	$37.50
3	1096	01/09/89	$156.50
4	1097	01/02/89	$109.00
5	1099	01/03/89	$45.00
6	1099	01/05/89	$45.00
7	1201	01/05/89	$37.00
8	1201	01/10/89	$45.00

You can also build a SAS data set from a hierarchical file by creating one observation per header record and combining the information from detail records into summary variables.

SAS Data Set

Obs	ID	Total
1	1095	$82.50
2	1096	$156.50
3	1097	$109.00
4	1099	$90.00
5	1201	$82.00

In this lesson, you learn how to read from a hierarchical file and create a SAS data set that contains one observation for each detail record or one observation for each header record. This lesson contains 31 pages and takes approximately 45-60 minutes to complete.

Objectives In this lesson, you learn how to retain the value of a variable conditionally execute a SAS statement determine when the last observation is being processed conditionally execute multiple SAS statements. You can also review how to use a line-hold specifier to hold the current record explicitly write an observation to a data set. Prerequisites Before taking this lesson, you should have completed the following lessons: Introduction to SAS Programming Working in the SAS Environment Basic Concepts Editing and Debugging SAS Programs Setting Up Your SAS Session Creating SAS Data Sets Reading Raw Data Reading Various Types of Raw Data Understanding DATA Step Processing Reading Raw Data in Fixed Fields Reading Free-Format Data Creating Multiple Observations from a Single Record Creating and Modifying Variables Creating Variables