As the first step in the decommissioning of sasCommunity.org the site has been converted to read-only mode.
Here are some tips for How to share your SAS knowledge with your professional network.
The SUMMARY procedure enables computation of a variety of statistical measures across all or groups of observations in a dataset.
Various options in the SUMMARY procedure make it possible to report statistics where no observations exist in the source, without needing to generate a cartesian product of the desired reporting categories.
The SUMMARY procedure is very similar to the MEANS procedure. The main difference between the two procedures is how they behave if the VAR statement is omitted. In the SUMMARY procedure, if the VAR statement is omitted then the procedure produces a count of observations in the dataset, by default, or else generates an error if any statistics keywords are specified in the procedure statement.
- PROC SUMMARY <options> <statistics keyword(s)> ;
- RUN statement ;
- Statements shown in italics are optional. Not all statements are necessary and some statements may be omitted or statement order may be changed. This could affect the behaviour of the procedure.
- PROC SUMMARY <option(s)> <statistic-keyword(s)>;
- BY <DESCENDING> variable-1<…<DESCENDING> variable-n> <NOTSORTED>;
- CLASS variable(s) </ option(s)>;
- FREQ variable;
- ID variable(s);
- OUTPUT <OUT=SAS-data-set><output-statistic-specification(s)> <id-group-specification(s)> <maximum-id-specification(s)> <minimum-id-specification(s)> </ option(s)> ;
- TYPES request(s);
- VAR variable(s)</ WEIGHT=weight-variable>;
- WAYS list;
- WEIGHT variable;
The SUMMARY procedure is a computationally intensive procedure and has the potential to run for a long time, consume all available memory and produce large output datatsets, depending on the options chosen, even with a comparatively small input dataset.
- Bench Marking Proc Summary
- SUM Enchanted Procedure: The Advanced Power of PROC SUMMARY
- Transpose using IDGROUP in PROC SUMMARY
- Adding statistics to the PROC MEANS/SUMMARY default output dataset.
- Replacing Missing with Mean
- Statistical Models for Identifying Aberrant Utilization Patterns
- Summary Cross-Tab
- Using Formats for Data Review
- Tips:Using Multilabel Formats to Expand or Duplicate Data