LOG(LN) function in PROC SQL

Phil_NZ — Wed, 17 Feb 2021 05:39:43 GMT

Hi SAS Users,

Today when I run this code

/******Calculate delta_q industry*****/
proc sql;
create table work.industry_return as
  select Type, year, INDC3,wRETURN, 
		ln(1 + mean(wRETURN)) as industry_ret
  from canus_sample
  group by INDC3,year
  ;
quit;

The log is

28         proc sql;
29         create table work.industry_return as
30           select Type, year, INDC3,wRETURN,
31         		ln(1 + mean(wRETURN)) as industry_ret
32           from canus_sample
33           group by INDC3,year
34           ;
ERROR: Function LN could not be located.
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
35         quit;
NOTE: The SAS System stopped processing this step because of errors.

Could you please tell me how to deal with this problem? Whether we must create another data step to calculate ln in this case, is there any shorter way to do so?

Warm regards.

Re: LOG(LN) function in PROC SQL

PeterClemmensen — Wed, 17 Feb 2021 05:54:18 GMT

The Log Function Returns the natural (base e) logarithm.

topic Re: LOG(LN) function in PROC SQL in SAS Programming

LOG(LN) function in PROC SQL

Re: LOG(LN) function in PROC SQL