Creating One Observation per Header Record

The Basics of Creating One Observation per Header Record

This example uses the data set below to create a summary variable, Total.
Raw Data File
SAS Data Set
As you write the DATA step to read this file, think about performing several tasks. First, the value of Address must be retained as detail records are read and summarized.
data perm.residents; 
   infile census; 
   retain Address;
Using a RETAIN Statement
Next, the value of Type must be read in ...

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.