BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Hello,
I am comparing the difference in shell area (mm^2) between two species of clams under ambient environmental conditions over a one year period using monthly measurement intervals. Unfortunately, part-way into the experiment the clams of both species started experiencing heavy mortality (i.e. “Species 1” – 38% mortality at month 4, and 94% mortality at month 8; “Species 2” – 7% mortality at month 4, and 50% at month 8).
As a consequence, I have many missing values in my data set due to this mortality.
I know that SAS usually drops subjects with missing variables in PROC MIXED and GLM.
Does anyone know a way to do a Repeated Measures analysis on growth measurements without loosing the data from the dead organisms?
Thanks.
4 REPLIES 4
1162
Calcite | Level 5
I thought SAS dropped subjects with missing data for proc anova and proc glm, but NOT proc mixed.
deleted_user
Not applicable
Thanks, but I'm positive SAS drops subjects with missing data for PROC ANOVA, GLM, and MIXED...I've tried doing my analysis with all three. If you know of any other procedure that might be helpful though, I'd like to hear it.
1162
Calcite | Level 5
I wonder if I'm misunderstanding the issue because as far as I understand things, you should be getting different results with PROC GLM and PROC MIXED for repeated measures. In the Class Levels section of the GLM output, are you getting a note that observations have been removed due to missing data? In the Dimensions section of the PROC MIXED output, how many observations are used and not used? Does the number used match the total number of non-missing values or just for the subjects with complete data?

I found this in the SAS Course Notes for Mixed Model Analyses:

"In the presence of missing repeated measures for a subject, the MIXED procedure does not exclude this subject from the analysis; instead it uses all the available data. This method (likelihood-based ignorable analysis) leads to a valid analysis when the missing data can be assumed missing at random (MAR)."

Unfortunately, it doesn't sound like your data is missing at random, so there might be better methods than PROC MIXED anyway.

Here are some other web links about this topic:
http://support.sas.com/rnd/app/papers/mixedglm.pdf
http://www.stat.lsu.edu/faculty/moser/exst7037/repeatedpres.pdf
http://www.ats.ucla.edu/stat/sas/faq/mixmiss.htm

There is an example in the third link that shows how GLM drops 4 of the 8 subjects because of missing data, but MIXED uses the available data from all 8 subjects. The two methods produce different p-values because of this.
deleted_user
Not applicable
Thanks for the help!
Actually, It was I who was misunderstanding the issue. I started to finally figure that out, and then your response confirmed it for me. Thanks for the links as well, I really appreciate it!

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!

New Learning Events in April

 

Join us for two new fee-based courses: Administrative Healthcare Data and SAS via Live Web Monday-Thursday, April 24-27 from 1:00 to 4:30 PM ET each day. And Administrative Healthcare Data and SAS: Hands-On Programming Workshop via Live Web on Friday, April 28 from 9:00 AM to 5:00 PM ET.

LEARN MORE

Discussion stats
  • 4 replies
  • 978 views
  • 0 likes
  • 2 in conversation