Adding new variable

[yael]

Hello 

I am tring to add a new variable with the following code:

data new; set sasuser.hed1;
lncapax = ln(capaxass);
run;

The log I got is:

NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.NEW may be incomplete. When this step was stopped there were 0
observations and 183 variables.
NOTE: At least one W.D format was too small for the number to be printed. The decimal may be shifted
by the "BEST" format.

I believe the reason is that there is observation with 0 value and the ln of it is an error. How can I fix it?

Thanks a lot!

[PeterClemmensen · Accepted solution]

Use the LOG function instead of LN when you want the natural logarithm.

And remember that the logarithm is defined only for values >0. You can not take the logarithm of zero or a negative number.