O'Reilly logo

Combining and Modifying SAS® Data Sets: Examples Second Edition by Michele M. Burlew

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Example 8.17 Combining Generation Data Sets

Goal

Concatenate specific data sets in a generation group of data sets.

Example Features

Featured StepPROC APPEND

DATA step

PROC SQL
Featured Step Options and StatementsGENNUM= option

Input Data Sets

A library system maintains daily circulation records for the main library. The system maintains copies of the daily records for three days. It adds the daily records to a monthly data set daily after closing.

                CITYLIB.MAINLIB_DAILY (GENNUM=-2)

 Obs   circdate type                 adult juvenile youngpeople 1 03/06/2010 Audiocassettes 16 7 5 2 03/06/2010 CompactDiscs 111 78 11 3 03/06/2010 HardcoverFiction 31 4 1 4 03/06/2010 HardcoverNonfiction 236 87 18 5 03/06/2010 LargeTypeFiction 10 0 0 6 03/06/2010 LargeTypeNonfiction ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required