topic Invalid argument to function LOG(0) in SAS Programming

Invalid argument to function LOG(0)

_maldini_ — Tue, 10 May 2016 21:44:04 GMT

I'm trying to transform a continuous variable that contains all positive values, using a variety of functions (See code).

        logPAMIN  	 = log (SCORE);
	log10PAMIN       = log10 (SCORE);
	rootPAMIN        = sqrt (SCORE);
	expPAMIN   	 = exp (SCORE/10);

The LOG and LOG10 functions return an error message relatiing to an invalid argument.

Any ideas what's going on?

Thanks.

Reeza — Tue, 10 May 2016 21:46:13 GMT

When this happens you'll get missing values. So you can filter your data and figure out what's going on yourself 😉

My guess - 0 or missing values.

data check;
set have;
where missing (logpamin);
run;

proc means data=check n min max;
var score;
run;

_maldini_ — Tue, 10 May 2016 22:26:12 GMT

@Reeza You were correct. Zero values were being converted to missing. Thanks!