Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

- JMP User Community
- :
- Discussions
- :
- Comparing individual groups to a baseline group

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Jul 21, 2019 8:19 AM
(902 views)

Hello,

a medical statistic problem for me:

- a discrete outcome variable - alive - 1/0

- multiple groups, which I created by binning a continuos variable per percentiles (0-25,25-50,50-75,75-100)

- for each group, I created a specific column (0-25, 25-50, 50-75, 75-100) which is again 1/0

my problem:

I want to set all the patients in group 1 (0-25) as a baseline group and compare each individual (25-50, 50-75,75-100) to the baseline group (0-25) and subsequently calculate OR in relation to the baseline group (0-25) - example attached.

Patient | Outcome | 0-25% | 25-50% | 50-75% | 75-100% |

A | 1 | 0 | 1 | 0 | 0 |

B | 1 | 1 | 0 | 0 | 0 |

C | 1 | 0 | 0 | 1 | 0 |

D | 0 | 0 | 0 | 0 | 1 |

E | 0 | 1 | 0 | 0 | 0 |

Many thanks for your help and ideas ! Marc

2 ACCEPTED SOLUTIONS

Accepted Solutions

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

I would setup you data table differently. 3 columns, Patient, Outcome, Percentile. Percentile would have the values "0-25", "26-50" etc. Then, make sure all of your columns are set to a Modeling Type of "Nominal". Then you can run the Fit Y by X platform, and by using a Local Data Filter, that you would set to select on Percentile, you can then select the grouping you want to compare, and JMP would perform a Chi Square analysis on the groups.

Jim

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

*yet*. Only if you have a context where the treatment period (or whatever time period you are using) is over, is the 0/1 response variable the correct way to view this. Instead, you might try the survival platform (e.g., fit prorportional hazard model) - but you would need to have a continous response variable which is usually the time at which death occurs.

5 REPLIES 5

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Comparing individual groups to a baseline group

Hi,

I'm not sure we can help you with this level of information. Could you clarify a couple of points?

Is it correct that for each groups A - E, you have the actual frequency of death which you expressed as 1 or 0 depending on the quartile these belong to?

What is the relationship between the Outcome column and the other columns (if any)?

Most importantly, what is the scientific / medical question you need to address?

I'm not sure we can help you with this level of information. Could you clarify a couple of points?

Is it correct that for each groups A - E, you have the actual frequency of death which you expressed as 1 or 0 depending on the quartile these belong to?

What is the relationship between the Outcome column and the other columns (if any)?

Most importantly, what is the scientific / medical question you need to address?

Thierry R. Sornasse

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Comparing individual groups to a baseline group

Hi - for clarity

Column A represents individual patients - about 3000 - I just listed here just as example (A-E)

Column B - outcome - my outcome variable (Y)

Column C, D, E, F - group distribution related to their percentile distribution and binned for percentiles

Column C would be my reference group

What is the outcome (B) in regards to OR for patients in group D to C, group E to C and group F to C.

Thanks a lot for looking into this. Marc

Highlighted
I would setup you data table differently. 3 columns, Patient, Outcome, Percentile. Percentile would have the values "0-25", "26-50" etc. Then, make sure all of your columns are set to a Modeling Type of "Nominal". Then you can run the Fit Y by X platform, and by using a Local Data Filter, that you would set to select on Percentile, you can then select the grouping you want to compare, and JMP would perform a Chi Square analysis on the groups.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Jim

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

*yet*. Only if you have a context where the treatment period (or whatever time period you are using) is over, is the 0/1 response variable the correct way to view this. Instead, you might try the survival platform (e.g., fit prorportional hazard model) - but you would need to have a continous response variable which is usually the time at which death occurs.

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Comparing individual groups to a baseline group

Thank you both - the local data filter made it easy for me to compare those groups.

Indeed I first run the mixed model with continuos variable (time to death), however as many even high impact medical journals tend more to binning of variables (which I personally dont support) I added this as a new feature for my article.

I also run cox proportional hazard, but I restricted my analysis now to multivariate models , which seem also better to fit using nominal variables only , as mixed (continuos and nominal variables) give me a lot of times a positive lack of fit test.

Thanks again for your help !

Article Labels

There are no labels assigned to this post.