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.
Use PROC RANK GROUPS=3 to add a variable with tertile scores to your data. Then just use PROC MEANS; CLASS tertile; VAR weight;
Please provide some example data for calculation.
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 |
Use PROC RANK GROUPS=3 to add a variable with tertile scores to your data. Then just use PROC MEANS; CLASS tertile; VAR weight;
Note for future readers: This thread was continued there.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.
Find more tutorials on the SAS Users YouTube channel.