Turn on suggestions

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

Showing results for

- Home
- /
- Analytics
- /
- Stat Procs
- /
- Inverse tranformation

Options

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

🔒 This topic is **solved** and **locked**.
Need further help from the community? Please
sign in and ask a **new** question.

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

Posted 02-08-2018 03:22 PM
(2813 views)

How do you write a code for inverse transformation in SAS??

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

Ahh, I understand now.

If you know PROC SQL, use that to compute the max and the new (inverse transformed) variable in one step. Otherwise, you will need to compute the max (or min) in one step, put it in a macro variable, and then use the DATA step to create the new variable.

4 REPLIES 4

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

The inverse transformation of what?

If your transformation is LOG, the inverse transformation is EXP.

If your transformation is SQRT, the inverse transformation is x^2.

If your transformation is LOGISTIC, the inverse transformation is LOGIT.

In many regression procedures, you can specify ILINK on a statement to get parameter estimates on the original scale instead of the transformed scale.

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

I think I meant to ask this:

I know we obtain inverse transformed values by using following formula.

new variable = 1/(K − old variable) (for negatively skewed data)

or 1/(C + old variable) (for positively skewed data)

K = largest score + 1

If zero is in the range use this equation, where C = smallest score + 1.

I wondered if there is SAS code that I can simply use instead of figuring out the largest or smallest values and using the formula.

But thanks for your information though.

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

Ahh, I understand now.

If you know PROC SQL, use that to compute the max and the new (inverse transformed) variable in one step. Otherwise, you will need to compute the max (or min) in one step, put it in a macro variable, and then use the DATA step to create the new variable.

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

I don't know proc sql, so maybe I will just do the way I described.

Thanks for confirming that there isn't one code for inverse transformation!

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. **Registration is now open through August 30th**. Visit the SAS Hackathon homepage.

What is ANOVA?

ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.

Find more tutorials on the SAS Users YouTube channel.