topic Re: PROC TRANSREG invalid values in SAS Procedures

PROC TRANSREG invalid values

ANKH1 — Tue, 13 Aug 2019 15:52:43 GMT

Hello,

How do you deal with a dependent variable that has some values equal to zero when using boxcox transformations in proc transreg?

proc transreg data = sample1;
model boxcox(DV)=identity(IV);
run;

ERROR: 11 invalid values were encountered while attempting to transform variable DV.

Thank you

PaigeMiller — Tue, 13 Aug 2019 17:35:18 GMT

You could prevent λ in the Box-Cox transformation from being exactly equal to zero, then you shouldn't have any problems with zero values of Y.

ANKH1 — Tue, 13 Aug 2019 17:53:50 GMT

Thanks for your answer. I tried this and didn't work:

proc transreg data = sample1;
model boxcox(DV / lambda ^= 0) = identity(IV);
run;

PaigeMiller — Tue, 13 Aug 2019 18:26:10 GMT

proc transreg data = sample1;
model boxcox(DV / lambda = -3 to -0.25 by 0.25,-0.1, 0.1, 0.25 to 3 by 0.25) = identity(IV);
run;

ANKH1 — Tue, 13 Aug 2019 19:26:15 GMT

Thanks for your response. I tried using the code with that specific lambda but it showed the same error.