Adding new variable

yael — Thu, 18 May 2017 05:38:37 GMT

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!

Re: Adding new variable

PeterClemmensen — Thu, 18 May 2017 06:40:38 GMT

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.

topic Re: Adding new variable in Statistical Procedures

Adding new variable

Re: Adding new variable