turn on suggestions

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

Showing results for

Find a Community

- Home
- /
- Health Care and Pharma
- /
- SAS in Health Care Related Fields
- /
- Log transform of data with negative values

Topic Options

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

06-16-2011 07:03 PM

Hey all, I have some data that we're trying to analyze using mixed models but it looks like the data is non-linear. We decided to try a log transform since it looks like the fixed effect has an acute phase and then levels off after the first couple of weeks. The problem is the data has negative values (directionality is important). We're hearing conflicting suggestions about what to do next. Someone told us that we should add a constant to all the values and use the offset to make everything in the positive domain, while others said that's a bad idea. Any suggestions?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to yiferic

06-17-2011 03:55 PM

Hello Yiferic,

I do not think that adding a constant to y is a bad idea. For a simple model

log(y+C)=A+SUM(BiXi), we get y=exp(A+SUM(BiXi))-C. What "others" say, why is it a bad idea?

Sincerely,

SPR

I do not think that adding a constant to y is a bad idea. For a simple model

log(y+C)=A+SUM(BiXi), we get y=exp(A+SUM(BiXi))-C. What "others" say, why is it a bad idea?

Sincerely,

SPR

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

06-17-2011 07:19 PM

Thanks for the reply SPR, one of the issues is we don't know what constant to use and how it'll affect our likelihood/significance values. I'm assuming we should use a constant that's about the same order as the smallest negative value?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to yiferic

06-19-2011 08:44 AM

Yes, it is true. This constant could be found from the equation log(y+C) = 1 for y < 0. This guarantees that log(y+C) => 0.

SPR

SPR