BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
nlpurumi
Obsidian | Level 7

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
Rick_SAS
SAS Super FREQ

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.

View solution in original post

4 REPLIES 4
Rick_SAS
SAS Super FREQ

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.

nlpurumi
Obsidian | Level 7

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.

Rick_SAS
SAS Super FREQ

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.

nlpurumi
Obsidian | Level 7

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!

 

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

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.

Discussion stats
  • 4 replies
  • 2663 views
  • 0 likes
  • 2 in conversation