DATA Step, Macro, Functions and more

Comparing means of 3 different groups in a prospective data

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 83
Accepted Solution

Comparing means of 3 different groups in a prospective data

Hello,

 

I appreciate anyone can help - I am looking for an appropriate test to "compare means of 3 different groups in a prospective data"

 

data wide; 
input id hand06 hand07 hand08 hand09;
cards;
1 40 32 . 35
2 26 34 . 39
3 39 41 . 47
4 36 50 . 41
5 42 38 . 39
;
run;

proc means data=wide fw=8;
var hand06 - hand09;
run;

 

data long; set wide;
year=06;
hand_=hand06;
output;

year=07;
hand_=hand07;
output;

year=09;
hand_=hand09;
output;

drop hand06-hand09;
run;

 

proc means data=long;
class year;
var hand_;
run;


Accepted Solutions
Solution
3 weeks ago
Super User
Posts: 22,827

Re: Comparing means of 3 different groups in a prospective data

ANOVA is a starting point. Make sure to visually inspect the data and do some histograms. 

 


@PhanS wrote:

Hello,

 

I appreciate anyone can help - I am looking for an appropriate test to "compare means of 3 different groups in a prospective data"

 

data wide; 
input id hand06 hand07 hand08 hand09;
cards;
1 40 32 . 35
2 26 34 . 39
3 39 41 . 47
4 36 50 . 41
5 42 38 . 39
;
run;

proc means data=wide fw=8;
var hand06 - hand09;
run;

 

data long; set wide;
year=06;
hand_=hand06;
output;

year=07;
hand_=hand07;
output;

year=09;
hand_=hand09;
output;

drop hand06-hand09;
run;

 

proc means data=long;
class year;
var hand_;
run;


 

View solution in original post


All Replies
Solution
3 weeks ago
Super User
Posts: 22,827

Re: Comparing means of 3 different groups in a prospective data

ANOVA is a starting point. Make sure to visually inspect the data and do some histograms. 

 


@PhanS wrote:

Hello,

 

I appreciate anyone can help - I am looking for an appropriate test to "compare means of 3 different groups in a prospective data"

 

data wide; 
input id hand06 hand07 hand08 hand09;
cards;
1 40 32 . 35
2 26 34 . 39
3 39 41 . 47
4 36 50 . 41
5 42 38 . 39
;
run;

proc means data=wide fw=8;
var hand06 - hand09;
run;

 

data long; set wide;
year=06;
hand_=hand06;
output;

year=07;
hand_=hand07;
output;

year=09;
hand_=hand09;
output;

drop hand06-hand09;
run;

 

proc means data=long;
class year;
var hand_;
run;


 

Frequent Contributor
Posts: 83

Re: Comparing means of 3 different groups in a prospective data

Thank you - I agreed.

Beside the ANOVA, is there any test. 

 

 

 

 

☑ This topic is solved.

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

Discussion stats
  • 2 replies
  • 64 views
  • 0 likes
  • 2 in conversation