Return to Homepage

Goto the Tip of the Month Archive

Other interesting pages ...
LinkedIn Profile
SAS Cheat Sheet
Useful SAS Code
Full SAS Example
Basic Statistics
Contact Information

SAS Tip of the Month
July 2015
(for SAS)

Lets say we have a dataset with variables A1, A2, A3, …., A20 and I want to find the average. We could write:


But this is inefficient and if any of the variables in the list are missing the variable AVG will be missing. We could then change it to:


But writing out this list is tedious. Better is to use the OF statement and a list of the variables as shown below:

  avg=MEAN(OF a1-a20);

Another way is to use an array, as the following example shows:

  array zaz{*} a1-20;
  avg=MEAN(OF zaz(*));

This example uses the MEAN function but the same idea of using the OF function can also be used for N, NMISS, STD, MIN, MAX, STDERR, MEDIAN, GEOMEAN, SUM, VAR, PCTL or the myriad of other descriptive statistic functions.

Hope this was useful.

Updated July 2, 2015