PROC TRANSREG invalid values

[SanKH1]

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]

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.

https://documentation.sas.com/?cdcId=pgmmvacdc&cdcVersion=9.4&docsetId=statug&docsetTarget=statug_tr...

[SanKH1]

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

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

[PaigeMiller]

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;

[SanKH1]

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