LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (May 2004, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Thu, 13 May 2004 13:20:17 -0500
Reply-To:   "Copeland, Laurel" <Laurel.Copeland@MED.VA.GOV>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   "Copeland, Laurel" <Laurel.Copeland@MED.VA.GOV>
Subject:   Re: Dependent variable is ratio of continuous values

Thank you! I have put it at this location: http://czresearch.com/info/goldstein_ratios.pdf <http://czresearch.com/info/goldstein_ratios.pdf>

_____

From: Droogendyk, Harry [mailto:harry.droogendyk@rbc.com]

Attachments are stripped by the list serve.

-----Original Message----- From: Copeland, Laurel [mailto:Laurel.Copeland@MED.VA.GOV <mailto:Laurel.Copeland@MED.VA.GOV> ] Sent: Thursday, May 13, 2004 1:30 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: Dependent variable is ratio of continuous values

Some issues regarding analysis of ratios are addressed in the attached PDF by Richard Goldstein, which I copied from a Univ Virginia Health System site

no longer in existence. -Laurel

On Tue, 11 May 2004 16:35:37 -0400, Talbot Michael Katz <topkatz@MSN.COM> wrote:

>Hi. > >I have a situation where the target variable I want to model takes on >values between 0 and 1, endpoints inclusive, because it is a ratio of >two continuous quantities (e.g., actual sales / sales target)... > >Is there a "preferred" method for modeling ratios of continuous quantities, and if so, is it available in SAS? > > Someone suggested the use of the PROC LOGISTIC events/trials syntax, >but the SAS documentation for that really seems to stress binary >outcome trials... > >Is it legitimate to use PROC LOGISTIC events/trials for continuous >numerator and denominator? > >An econometrics textbook ("Econometric Analysis" by W.H. Greene, 5th >edition, Prentice-Hall) suggests Minimum Chi-Squared Estimation (or >MCSE - - >don't tell Microsoft!) for proportions; it looks like that discussion >was motivated by proportions of binary outcomes, but I think the >equations still work in the case of continuous numerator and >denominator. However, a >search of support.sas.com didn't turn up any procedures that support >the MCSE methodology. One weakness of MCSE is that the estimation only >works when the proportion does not take on the extreme values of 0 or >1. In such cases, it seems that the suggested work-around is to add or subtract a >small constant... > >Is there a SAS procedure that does minimum chi-squared estimation for >proportions? > >I could also transform the ratio from the unit interval to the entire >line with the logit transform, log(y/(1-y)), and then perform a >standard regression. Again, I'd have to smudge the extreme values >before performing the transformation... > >Is it legitimate to logit transform the ratio after slightly modifying >the extreme values, and then do OLS? > >Thanks, as ever, for your indulgence... > >-- TMK --

============================================================


Back to: Top of message | Previous page | Main SAS-L page