https://communities.sas.com/t5/SAS-Procedures/What-kind-of-transformation-procedure-need-to-applied-for-this/m-p/297662#M60279 I tried the ln(ln(x)) ~ The distribution almost looks the same with the reduced SD! Mon, 12 Sep 2016 05:11:34 GMT mantubiradar19 2016-09-12T05:11:34Z https://communities.sas.com/t5/SAS-Procedures/What-kind-of-transformation-procedure-need-to-applied-for-this/m-p/295705#M60157 <P>Hi All ~ I'm dealing with a contienous variable whose distrubution looks as shown in the two figures. Which tranformation procedure would you recommnend for this kind of distrubution?&nbsp;</P><BR /><IMG src="https://communities.sas.com/t5/image/serverpage/image-id/12916iDEA2BF2CB080F40B/image-size/large?v=1.0&amp;px=600" border="0" alt="Capture.JPG" title="Capture.JPG" /><IMG src="https://communities.sas.com/t5/image/serverpage/image-id/12917i640DD0F7D5D126E0/image-size/large?v=1.0&amp;px=600" border="0" alt="Capture1.JPG" title="Capture1.JPG" /> Thu, 01 Sep 2016 07:17:35 GMT https://communities.sas.com/t5/SAS-Procedures/What-kind-of-transformation-procedure-need-to-applied-for-this/m-p/295705#M60157 mantubiradar19 2016-09-01T07:17:35Z https://communities.sas.com/t5/SAS-Procedures/What-kind-of-transformation-procedure-need-to-applied-for-this/m-p/295732#M60158 <P>Why are you transforming?</P> Thu, 01 Sep 2016 08:46:23 GMT https://communities.sas.com/t5/SAS-Procedures/What-kind-of-transformation-procedure-need-to-applied-for-this/m-p/295732#M60158 Reeza 2016-09-01T08:46:23Z https://communities.sas.com/t5/SAS-Procedures/What-kind-of-transformation-procedure-need-to-applied-for-this/m-p/295734#M60159 <P>I'm using this as the dependent variable for my GLM analysis ~ which assumes the normal distrubution of outcome!&nbsp;</P> Thu, 01 Sep 2016 08:50:25 GMT https://communities.sas.com/t5/SAS-Procedures/What-kind-of-transformation-procedure-need-to-applied-for-this/m-p/295734#M60159 mantubiradar19 2016-09-01T08:50:25Z https://communities.sas.com/t5/SAS-Procedures/What-kind-of-transformation-procedure-need-to-applied-for-this/m-p/295739#M60160 <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/16379">@mantubiradar19</a> wrote:<BR /> <P>I'm using this as the dependent variable for my GLM analysis ~ which assumes the normal distrubution of outcome!&nbsp;</P> <HR /></BLOCKQUOTE> <P>Logistic regression falls under GLM and a binary response is definitely not normal.&nbsp;</P> <P>&nbsp;</P> Thu, 01 Sep 2016 09:13:46 GMT https://communities.sas.com/t5/SAS-Procedures/What-kind-of-transformation-procedure-need-to-applied-for-this/m-p/295739#M60160 Reeza 2016-09-01T09:13:46Z https://communities.sas.com/t5/SAS-Procedures/What-kind-of-transformation-procedure-need-to-applied-for-this/m-p/295770#M60162 <PRE> Your data is right bias. Try Log Normal distribution. </PRE> Thu, 01 Sep 2016 10:50:50 GMT https://communities.sas.com/t5/SAS-Procedures/What-kind-of-transformation-procedure-need-to-applied-for-this/m-p/295770#M60162 Ksharp 2016-09-01T10:50:50Z https://communities.sas.com/t5/SAS-Procedures/What-kind-of-transformation-procedure-need-to-applied-for-this/m-p/295822#M60164 <P>Box cox transformation using proc transreg may be an option</P> Thu, 01 Sep 2016 13:27:30 GMT https://communities.sas.com/t5/SAS-Procedures/What-kind-of-transformation-procedure-need-to-applied-for-this/m-p/295822#M60164 Reeza 2016-09-01T13:27:30Z https://communities.sas.com/t5/SAS-Procedures/What-kind-of-transformation-procedure-need-to-applied-for-this/m-p/295933#M60167 <P>How did you create that panel of histogram + box plot + Q-Q plot? &nbsp;Is that something you wrote with GTL or was it generated by&nbsp;a SAS procedure?</P> Thu, 01 Sep 2016 16:47:05 GMT https://communities.sas.com/t5/SAS-Procedures/What-kind-of-transformation-procedure-need-to-applied-for-this/m-p/295933#M60167 Rick_SAS 2016-09-01T16:47:05Z https://communities.sas.com/t5/SAS-Procedures/What-kind-of-transformation-procedure-need-to-applied-for-this/m-p/296194#M60183 <P>That is an interesting plot. &nbsp;Even the log10 values show an extreme skew. &nbsp;Is there a possibility that these are maximum values for something? &nbsp;If so, you may want to look at a Weibull distribution or some other generalized extreme value distribution. &nbsp;a ln(ln (x)) transformation might be useful. &nbsp;I don't know if TRANSREG will hande this, though.</P> <P>&nbsp;</P> <P>Steve Denham</P> Fri, 02 Sep 2016 18:43:46 GMT https://communities.sas.com/t5/SAS-Procedures/What-kind-of-transformation-procedure-need-to-applied-for-this/m-p/296194#M60183 SteveDenham 2016-09-02T18:43:46Z https://communities.sas.com/t5/SAS-Procedures/What-kind-of-transformation-procedure-need-to-applied-for-this/m-p/296410#M60188 <P><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/13684">@Rick_SAS</a>&nbsp;that looks like the output from proc univariate.&nbsp;</P> Sun, 04 Sep 2016 21:03:00 GMT https://communities.sas.com/t5/SAS-Procedures/What-kind-of-transformation-procedure-need-to-applied-for-this/m-p/296410#M60188 Reeza 2016-09-04T21:03:00Z https://communities.sas.com/t5/SAS-Procedures/What-kind-of-transformation-procedure-need-to-applied-for-this/m-p/297657#M60276 <P>The distrubution shown here is the log tranformed values of orifinal values!&nbsp;</P> Mon, 12 Sep 2016 05:09:06 GMT https://communities.sas.com/t5/SAS-Procedures/What-kind-of-transformation-procedure-need-to-applied-for-this/m-p/297657#M60276 mantubiradar19 2016-09-12T05:09:06Z https://communities.sas.com/t5/SAS-Procedures/What-kind-of-transformation-procedure-need-to-applied-for-this/m-p/297658#M60277 Can you please educate me more about this transformation with an example? Thanks Mon, 12 Sep 2016 05:09:52 GMT https://communities.sas.com/t5/SAS-Procedures/What-kind-of-transformation-procedure-need-to-applied-for-this/m-p/297658#M60277 mantubiradar19 2016-09-12T05:09:52Z https://communities.sas.com/t5/SAS-Procedures/What-kind-of-transformation-procedure-need-to-applied-for-this/m-p/297660#M60278 This is the output from PROC UNIVARIATE! Mon, 12 Sep 2016 05:10:27 GMT https://communities.sas.com/t5/SAS-Procedures/What-kind-of-transformation-procedure-need-to-applied-for-this/m-p/297660#M60278 mantubiradar19 2016-09-12T05:10:27Z https://communities.sas.com/t5/SAS-Procedures/What-kind-of-transformation-procedure-need-to-applied-for-this/m-p/297662#M60279 I tried the ln(ln(x)) ~ The distribution almost looks the same with the reduced SD! Mon, 12 Sep 2016 05:11:34 GMT https://communities.sas.com/t5/SAS-Procedures/What-kind-of-transformation-procedure-need-to-applied-for-this/m-p/297662#M60279 mantubiradar19 2016-09-12T05:11:34Z https://communities.sas.com/t5/SAS-Procedures/What-kind-of-transformation-procedure-need-to-applied-for-this/m-p/297664#M60280 <P>Here are the log(x) and log(log(x)) distrubution!&nbsp;</P><BR /><IMG src="https://communities.sas.com/t5/image/serverpage/image-id/12965i1B7E903DDB20C3E4/image-size/large?v=1.0&amp;px=600" border="0" alt="Capture.JPG" title="Capture.JPG" /> Mon, 12 Sep 2016 05:13:34 GMT https://communities.sas.com/t5/SAS-Procedures/What-kind-of-transformation-procedure-need-to-applied-for-this/m-p/297664#M60280 mantubiradar19 2016-09-12T05:13:34Z https://communities.sas.com/t5/SAS-Procedures/What-kind-of-transformation-procedure-need-to-applied-for-this/m-p/297671#M60283 <P>It's hard to see what your doing now, since the forum doesn't sort the responses. So no way to tell which reply goes with which post. In the future please just do one response. This isn't your fault - limitation of the forum.&nbsp;</P> <P>&nbsp;</P> <P>Did you post your original distribution? Also, what is the variable, in laymans terms. Context can help with deciding what type of transformation to use, and there are certain standard transformation in diff industries.&nbsp;</P> Mon, 12 Sep 2016 06:02:51 GMT https://communities.sas.com/t5/SAS-Procedures/What-kind-of-transformation-procedure-need-to-applied-for-this/m-p/297671#M60283 Reeza 2016-09-12T06:02:51Z https://communities.sas.com/t5/SAS-Procedures/What-kind-of-transformation-procedure-need-to-applied-for-this/m-p/297672#M60284 <P>It's hard to see what your doing now, since the forum doesn't sort the responses. So no way to tell which reply goes with which post. In the future please just do one response. This isn't your fault - limitation of the forum.&nbsp;</P> <P>&nbsp;</P> <P>Did you post your original distribution? Also, what is the variable, in laymans terms. Context can help with deciding what type of transformation to use, and there are certain standard transformation in diff industries.&nbsp;</P> Mon, 12 Sep 2016 06:02:52 GMT https://communities.sas.com/t5/SAS-Procedures/What-kind-of-transformation-procedure-need-to-applied-for-this/m-p/297672#M60284 Reeza 2016-09-12T06:02:52Z https://communities.sas.com/t5/SAS-Procedures/What-kind-of-transformation-procedure-need-to-applied-for-this/m-p/297675#M60286 <PRE> Or you could check Box-Cox transformation . PROC TRANSREG or PROC MCMC can do that. Check example of them in documentation. </PRE> Mon, 12 Sep 2016 06:26:48 GMT https://communities.sas.com/t5/SAS-Procedures/What-kind-of-transformation-procedure-need-to-applied-for-this/m-p/297675#M60286 Ksharp 2016-09-12T06:26:48Z https://communities.sas.com/t5/SAS-Procedures/What-kind-of-transformation-procedure-need-to-applied-for-this/m-p/297676#M60287 Let me check these two! Xie Xie Mon, 12 Sep 2016 06:27:29 GMT https://communities.sas.com/t5/SAS-Procedures/What-kind-of-transformation-procedure-need-to-applied-for-this/m-p/297676#M60287 mantubiradar19 2016-09-12T06:27:29Z https://communities.sas.com/t5/SAS-Procedures/What-kind-of-transformation-procedure-need-to-applied-for-this/m-p/297677#M60288 <P>In layman terms I'm dealing with a contineous variable! Here is the distrubution before and after the log transformation!</P><BR /><IMG src="https://communities.sas.com/t5/image/serverpage/image-id/12966i6FEFB26EEAF9630E/image-size/large?v=1.0&amp;px=600" border="0" alt="Capture.JPG" title="Capture.JPG" /> Mon, 12 Sep 2016 06:28:41 GMT https://communities.sas.com/t5/SAS-Procedures/What-kind-of-transformation-procedure-need-to-applied-for-this/m-p/297677#M60288 mantubiradar19 2016-09-12T06:28:41Z https://communities.sas.com/t5/SAS-Procedures/What-kind-of-transformation-procedure-need-to-applied-for-this/m-p/297679#M60289 <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/16379">@mantubiradar19</a> wrote:<BR /> <P>In layman terms I'm dealing with a contineous variable! Here is the distrubution before and after the log transformation!</P> <HR /></BLOCKQUOTE> <P>What type of continuous variable, blood pressure, stock price, number of asteroids heading towards earth?&nbsp;<BR /><BR /><BR /></P> Mon, 12 Sep 2016 06:35:42 GMT https://communities.sas.com/t5/SAS-Procedures/What-kind-of-transformation-procedure-need-to-applied-for-this/m-p/297679#M60289 Reeza 2016-09-12T06:35:42Z