Differences between revisions 1 and 2
⇤ ← Revision 1 as of 2020-05-22 17:15:59 →
Size: 895
Editor: DominicRicottone
Comment:
← Revision 2 as of 2023-01-13 23:49:08 → ⇥
Size: 936
Editor: DominicRicottone
Comment:
Deletions are marked like this. Additions are marked like this.
Line 1: Line 1:
## page was renamed from SASAggregation

Aggregation

The transformation of record-level data to a higher level of analysis. An exceedingly common task, but one that requires a thorough cheat-sheet documenting the 'gotchas' and tricks.

Contents

  1. Aggregation
    1. Implicit Aggregation

Implicit Aggregation

Several procedures compute intermediary variables to produce a report. These intermediary variables can be stored and used.

To count observations by catgegory, use proc freq. 

proc freq data=LIBREF.TABLE noprint;
  tables=VAR / out=LIBREF.OUT;
run;

Many higher-level statistics can be retrieved through proc means. For example, to compute VARMEAN and VARMAX from VAR1 for each category of VAR2. 

proc means data=LIBREF.TABLE noprint;
  var VAR1;
  class VAR2;
  ways 1;
  output out=LIBREF.OUT(drop=_FREQ_ _TYPE_) mean=VARMEAN max=VARMAX;
run;

CategoryRicottone

SAS/AggregatingData (last edited 2023-01-13 23:51:26 by DominicRicottone)