BookmarkSubscribeRSS Feed
katemcguckin
Fluorite | Level 6

Hi,

 

I really need help asap.  I am caught up in this unsystematic study that I did not set up. I am being torn apart by MDs who want this asap. 

 

Please help me. 

 

I need to do:

1. check normality bt 4 vars with different names

2. do an ANOVA or appropriate nonparametric test bt those 4 vars. 

 

The data looks like this.  (Gosh, I wish people would consult prior to doing their own thing without knowing what is needed.

 


final_no_
pre5case_ post5case_ final5case_ 5case_
Obs pid ppf5 percent percent percent percent group

1 2 1200 66.7 66.7 66.7 55.6 1
2 222 2900 44.4 66.7 66.7 44.4 1
3 36 1600 66.7 88.9 77.8 66.7 1
4 37 2000 33.3 22.2 33.3 55.6 1
5 39 2300 44.4 66.7 55.6 44.4 1
6 42 1900 33.3 55.6 66.7 66.7 1

6 REPLIES 6
katemcguckin
Fluorite | Level 6

And I have more questions. I have been up all night. 

 

Kate McGuckin

PaigeMiller
Diamond | Level 26

@katemcguckin wrote:

I need to do:

1. check normality bt 4 vars with different names


Not sure what "bt" means

 

2. do an ANOVA or appropriate nonparametric test bt those 4 vars. 

 

The data looks like this.

 


final_no_
pre5case_ post5case_ final5case_ 5case_
Obs pid ppf5 percent percent percent percent group

1 2 1200 66.7 66.7 66.7 55.6 1
2 222 2900 44.4 66.7 66.7 44.4 1
3 36 1600 66.7 88.9 77.8 66.7 1
4 37 2000 33.3 22.2 33.3 55.6 1
5 39 2300 44.4 66.7 55.6 44.4 1
6 42 1900 33.3 55.6 66.7 66.7 1

In order to do an ANOVA, you need a Y-variable, and categorical X variables. But none of your variables are obviously (to me) categorical, and you haven't clearly stated which of these variables is a Y variable.
 
So please state, either in SAS language, or just in words, what model it is you want to fit and what statistical tests you want to perform.
--
Paige Miller
katemcguckin
Fluorite | Level 6
there is NO Y variable!!!!
That's why I am so confused. He just wants to see if there is a difference
in the scores between tests.


Any ideas? I have been spending more time on this on my jama papers
without pay. and their abstract is due on Monday. and on Sunday, I have
plans, but he will make me work on this.

the study is poorly designed.
ChrisHemedinger
Community Manager

Hi @katemcguckin, from what @PaigeMiller says, it sounds like your data (as you've shared it) won't support the test you've been asked to design.  Is it possible that the data need to be transposed?  If you have 4 variables, do the values of each variable represent a different group?  If so, you'll need to rearrange your data so that the table is "long", with a new variable that indicates the group (former variable) for each measure.

Check out SAS Innovate on-demand content! Watch the main stage sessions, keynotes, and over 20 technical breakout sessions!
PaigeMiller
Diamond | Level 26

@katemcguckin wrote:
there is NO Y variable!!!!
He just wants to see if there is a difference in the scores between tests.

I still don't really understand what you mean. "Scores" -- please define. "Tests" -- please define. Which of your variables are scores? Which of your variables are tests?

 

In fact, it would be a good idea if you took a step back and describe the data, and described how it was collected. Explain the data to me as if I had never seen your problem before, start from scratch.

--
Paige Miller
Reeza
Super User

Do what you can do and leave it at that. 

 

It looks like you have pre and post tests. I would do a few things:

 

1. Graph the data using a histogram and overlay the pre/post to see the distributions. This assumes you have more data than shown obviously. 

2. Create some summary statistics of each variable. 

3. Re-stack the data, so that you have a single variable with another variable that shows the four categories. Then use that to produce a PROC ANOVA. 

 

Var Value

1    25

1   24

2 24

2  30

3 20

3 54

4 56

4 78

 

If you could explain a bit more about the data perhaps we could help provide some more suggestions. 

 

Good Luck. 

 

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 6 replies
  • 753 views
  • 3 likes
  • 4 in conversation