Programming the statistical procedures from SAS

Tertile in SAS mean

Accepted Solution Solved
Reply
Contributor
Posts: 30
Accepted Solution

Tertile in SAS mean

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.

 


Accepted Solutions
Solution
4 weeks ago
SAS Employee
Posts: 386

Re: Tertile in SAS mean

[ Edited ]
Posted in reply to Sathish_jammy

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

View solution in original post


All Replies
PROC Star
Posts: 1,283

Re: Tertile in SAS mean

Posted in reply to Sathish_jammy

Please provide some example data for calculation.

Contributor
Posts: 30

Re: Tertile in SAS mean

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 

sample.png

Hope u understand now....

 

Weightfollw1_weight
94.7595.1
77.176.1
127126.7
69.769.6
81.482.3
92.891
84.182.8
84.983
85.682.5
101.298.9
72.2570.8
79.580.5
7775.3
101.896.5
8481.6
89.786
115.7115.7
102.397.4
82.475.9
87.980.9
59.755
71.0571.4
95.796
78.279.6
79.576.1
71.570.8
102101.6
8076.5
88.988.7
78.274.75
89.290
78.978.9
86.184.1
76.475
88.386
82.1581.3
93.892.05
79.279.2
6664.8
95.295.4
82.781.2
87.580.7
106.4105.3
85.785.6
84.184.4
114.4113.4
66.266.2
99.994.7
68.368
75.571.65
8786.9
75.268.7
89.386.2
8885.8
81.579.9
72.0572.2
105.4102.9
68.368.7
82.986.4
96.393.2
83.281.9
79.989.8
88.789.3
97.491.6
89.888
8585.8
84.178.1
9088.5
92.193.65
119.2115.2
111.896
98.5102.1
83.486.1
92.793.3
103.2105.9
76.376.8
104.2102.1
97.794.05
78.676.1
108100.9
62.5560.85
9494
99.296.8
93.292.3
76.6574.85
82.681.7
91.488.3
80.976.35
99.9102
114114.8
104.8102.9
105.9101.4
107.3103.8
63.162.8
72.769
58.557.2
88.785.5
86.5589.2
84.481
122.7120.4
95.3588.1
91.287.5
10092.5
86.957.8
8884.1
99.292.75
73.273.75
74.773.2
80.380.55
73.872.5
70.269.8
72.771.7
83.681.1
83.382
95.693.3
91.193
67.364.6
117.3116.5
59.558
94.6589.8
7574.8
91.6588.2
102.4101.2
89.184.5
97.993.95
110.6110.6
65.1564.75
83.8581.05
88.586.3
100.898
78.271.9
89.8592.2
91.186.2
84.278.5
91.190.3
76.775.3
78.275.9
67.5568
81.182.7
72.770.2
76.4574
89.885.7
69.266.8
76.675.4
87.986.6
72.5570.4
86.885.6
9794.1
77.376.7
82.483.7
79.5579.25
89.690
103.295.6
72.166.7
89.590.6
83.483.06
115.9114.6
123.2122.1
81.680.2
84.987.6
87.9588.75
95.595.6
93.690.4
84.382.35
73.570.9
111.3109
116.5112.2
75.369.9
72.871.05
82.680.5
69.6566.5
95.495.2
77.1575.75
75.873.45
84.182.1
9489.6
89.789.5
86.285
93.289.5
86.786.2
100.596.7
89.587.8
70.764.95

 

Solution
4 weeks ago
SAS Employee
Posts: 386

Re: Tertile in SAS mean

[ Edited ]
Posted in reply to Sathish_jammy

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

Trusted Advisor
Posts: 1,252

Re: Tertile in SAS mean

Posted in reply to StatDave_sas

Note for future readers: This thread was continued there.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 170 views
  • 0 likes
  • 4 in conversation