I have a table with 11 columns and 31 rows the first column is a description and the rest of the columns represent various counts for each description.
What I want to do in SAS is create a table that provides the following for columns 2 - 11:
Sum
Median
Mean
Max
This is really easy to do in excel but I can't seem to figure how to do it in SAS EG.
Thanks, Dick Shryock
Example Data:
Date | Admit | Obs | AMA | D/C | LWBS | Trans | LBEC | LD | Expired | DayTotal |
---|
01/01/2013 | 44 | 0 | 1 | 130 | 0 | 1 | 1 | 0 | 0 | 177 |
01/02/2013 | 44 | 0 | 0 | 124 | 0 | 3 | 0 | 0 | 0 | 171 |
01/03/2013 | 41 | 0 | 0 | 156 | 2 | 3 | 0 | 0 | 0 | 202 |
Total | 129 | 0 | 1 | 410 | 2 | 7 | 1 | 0 | 0 | 550 |
Median | 44.0 | 0.0 | 0.0 | 130.0 | 0.0 | 3.0 | 0.0 | 0.0 | 0.0 | 177.0 |
Mean | 43.0 | 0.0 | 0.3 | 136.7 | 0.7 | 2.3 | 0.3 | 0.0 | 0.0 | 183.3 |
Max | 44 | 0 | 1 | 156 | 2 | 3 | 1 | 0 | 0 | 202 |