topic Re: log transformation in SAS Programming

log transformation

peiy5920 — Sat, 30 May 2020 00:28:27 GMT

Hi all,

I have a data set and a variable named PCR in it. I want to normalize this variable, but I am not sure how to change it. Can someone give me some suggestions. Thanks.

Re: log transformation

Kurt_Bremser — Sat, 30 May 2020 03:44:54 GMT

Pkease provide example data innzsable form (data step with datalines), and what you expect to get out of it.

Re: log transformation

ed_sas_member — Sat, 30 May 2020 07:11:51 GMT

Hi @peiy5920

Here are some suggestions:

- to standardize the data (center around the mean and divide by standard deviation), you can use PROC STANDARD for example.

- to normalize the data, you can also try transformations: log transformation (in a data step, you define a new variable as NEWVAR = log(NEW)), square root transformation (in a data step, you define a new variable as NEWVAR = sqrt(NEW)), ... You can also try Box and Cox transformation using PROC TRANSREG with the option BOXCOX in the MODEL statement.

Re: log transformation

peiy5920 — Sat, 30 May 2020 17:41:53 GMT

Thank you so much!

Re: log transformation

ed_sas_member — Sat, 30 May 2020 17:52:10 GMT

You’re welcome 😊