BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Sathish_jammy
Lapis Lazuli | Level 10

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.

 

1 ACCEPTED SOLUTION

Accepted Solutions
StatDave
SAS Super FREQ

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

4 REPLIES 4
PeterClemmensen
Tourmaline | Level 20

Please provide some example data for calculation.

Sathish_jammy
Lapis Lazuli | Level 10

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

 

StatDave
SAS Super FREQ

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
Jade | Level 19

Note for future readers: This thread was continued there.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is ANOVA?

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.

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