BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
_maldini_
Barite | Level 11

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.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User

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;

View solution in original post

2 REPLIES 2
Reeza
Super User

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_
Barite | Level 11

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

Catch up on SAS Innovate 2026

Dive into keynotes, announcements and breakthroughs on demand.

Explore Now →
How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 5731 views
  • 2 likes
  • 2 in conversation