Tertile in SAS mean

[Sathish_jammy]

HI,

I want to get a (Tertile) mean and STD of column(Weight) as

Example:

(Weight)           Mean           STD

1st tertile            77.23           5.2

2nd tertile           86.52           7.7

3rd tertile            101.82        6.8

Please post the accurate code/ method to complete further. 

Thanks.

[PeterClemmensen]

Please provide some example data for calculation.

[Sathish_jammy]

My table consist of patient informations such as their test results, measurements etc...

 from that I just want to calculate the tertile mean and std for the given columns in the table

like 

Hope u understand now....

Weight	follw1_weight
94.75	95.1
77.1	76.1
127	126.7
69.7	69.6
81.4	82.3
92.8	91
84.1	82.8
84.9	83
85.6	82.5
101.2	98.9
72.25	70.8
79.5	80.5
77	75.3
101.8	96.5
84	81.6
89.7	86
115.7	115.7
102.3	97.4
82.4	75.9
87.9	80.9
59.7	55
71.05	71.4
95.7	96
78.2	79.6
79.5	76.1
71.5	70.8
102	101.6
80	76.5
88.9	88.7
78.2	74.75
89.2	90
78.9	78.9
86.1	84.1
76.4	75
88.3	86
82.15	81.3
93.8	92.05
79.2	79.2
66	64.8
95.2	95.4
82.7	81.2
87.5	80.7
106.4	105.3
85.7	85.6
84.1	84.4
114.4	113.4
66.2	66.2
99.9	94.7
68.3	68
75.5	71.65
87	86.9
75.2	68.7
89.3	86.2
88	85.8
81.5	79.9
72.05	72.2
105.4	102.9
68.3	68.7
82.9	86.4
96.3	93.2
83.2	81.9
79.9	89.8
88.7	89.3
97.4	91.6
89.8	88
85	85.8
84.1	78.1
90	88.5
92.1	93.65
119.2	115.2
111.8	96
98.5	102.1
83.4	86.1
92.7	93.3
103.2	105.9
76.3	76.8
104.2	102.1
97.7	94.05
78.6	76.1
108	100.9
62.55	60.85
94	94
99.2	96.8
93.2	92.3
76.65	74.85
82.6	81.7
91.4	88.3
80.9	76.35
99.9	102
114	114.8
104.8	102.9
105.9	101.4
107.3	103.8
63.1	62.8
72.7	69
58.5	57.2
88.7	85.5
86.55	89.2
84.4	81
122.7	120.4
95.35	88.1
91.2	87.5
100	92.5
86.9	57.8
88	84.1
99.2	92.75
73.2	73.75
74.7	73.2
80.3	80.55
73.8	72.5
70.2	69.8
72.7	71.7
83.6	81.1
83.3	82
95.6	93.3
91.1	93
67.3	64.6
117.3	116.5
59.5	58
94.65	89.8
75	74.8
91.65	88.2
102.4	101.2
89.1	84.5
97.9	93.95
110.6	110.6
65.15	64.75
83.85	81.05
88.5	86.3
100.8	98
78.2	71.9
89.85	92.2
91.1	86.2
84.2	78.5
91.1	90.3
76.7	75.3
78.2	75.9
67.55	68
81.1	82.7
72.7	70.2
76.45	74
89.8	85.7
69.2	66.8
76.6	75.4
87.9	86.6
72.55	70.4
86.8	85.6
97	94.1
77.3	76.7
82.4	83.7
79.55	79.25
89.6	90
103.2	95.6
72.1	66.7
89.5	90.6
83.4	83.06
115.9	114.6
123.2	122.1
81.6	80.2
84.9	87.6
87.95	88.75
95.5	95.6
93.6	90.4
84.3	82.35
73.5	70.9
111.3	109
116.5	112.2
75.3	69.9
72.8	71.05
82.6	80.5
69.65	66.5
95.4	95.2
77.15	75.75
75.8	73.45
84.1	82.1
94	89.6
89.7	89.5
86.2	85
93.2	89.5
86.7	86.2
100.5	96.7
89.5	87.8
70.7	64.95

[StatDave · Accepted solution]

Use PROC RANK GROUPS=3 to add a variable with tertile scores to your data. Then just use PROC MEANS; CLASS tertile; VAR weight; 

[FreelanceReinh]

Note for future readers: This thread was continued there.