@braam wrote:
Thanks to the PROC REPORT, I can easily check my data. But can I change the format of MEAN of all variables listed? I know I can do that if I define each variable under PROC REPORT. But like shown in the code, I want to give a list (e.g., length, weight,...).
proc report data= sashelp.cars missing;
column type length,(n mean) weight,(n mean);
define type / group; run;
Length
Weight
Type
n
mean
n
mean
Hybrid
3
168.33333
3
2490.6667
SUV
60
188.13333
60
4444.4333
Sedan
262
187.10305
262
3399.0649
Sports
49
173.28571
49
3295.6939
Truck
24
207.70833
24
4250.75
Wagon
30
182.43333
30
3438.8
What I would like to see is just mean values that are rounded up:
Length
Weight
Type
n
mean
n
mean
Hybrid
3
168
3
2491
SUV
60
188
60
4444
Sedan
262
187
262
3399
Sports
49
173
49
3296
Truck
24
208
24
4251
Wagon
30
182
30
3439
Perhaps a different procedure:
proc tabulate data=sashelp.cars;
class type;
var length weight;
table type,
(length weight) *(n mean*f=8.)
;
run;
If you want the same statistics with the same formats applied you use parentheses to group the like variables Example: (length weight)
and then the * indicates which statistics to display. If you have multiple statistics then group them with parentheses as well.
The Mean*f= is how to specify a format for the mean statistic. In this case up to 8 digits with no decimal component.
You can use variable lists such as
proc tabulate data=sashelp.cars;
class type;
var _numeric_;
table type,
(_numeric_) *(n mean*f=8.)
;
run;
or
proc tabulate data=sashelp.cars;
class type;
var _numeric_;
table type,
(enginesize-- MPG_highway) *(n mean*f=8.)
;
run;
where the -- indicates adjacent variables.
... View more