Programming the statistical procedures from SAS

Adding new variable

Accepted Solution Solved
Reply
Contributor
Posts: 69
Accepted Solution

Adding new variable

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!


Accepted Solutions
Solution
‎05-18-2017 02:47 AM
PROC Star
Posts: 634

Re: Adding new variable

[ Edited ]

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.

View solution in original post


All Replies
Solution
‎05-18-2017 02:47 AM
PROC Star
Posts: 634

Re: Adding new variable

[ Edited ]

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.

☑ This topic is solved.

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

Discussion stats
  • 1 reply
  • 120 views
  • 0 likes
  • 2 in conversation