DATA Step, Macro, Functions and more

Invalid argument to function LOG(0)

Accepted Solution Solved
Reply
Regular Contributor
Posts: 199
Accepted Solution

Invalid argument to function LOG(0)

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.

 


Accepted Solutions
Solution
‎05-10-2016 06:26 PM
Super User
Posts: 17,962

Re: Invalid argument to function LOG(0)

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

 

My guess - 0 or missing values. 

 

 

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

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

View solution in original post


All Replies
Solution
‎05-10-2016 06:26 PM
Super User
Posts: 17,962

Re: Invalid argument to function LOG(0)

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

 

My guess - 0 or missing values. 

 

 

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

proc means data=check n min max;
var score;
run;
Regular Contributor
Posts: 199

Re: Invalid argument to function LOG(0)

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

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 422 views
  • 1 like
  • 2 in conversation