Excel LOGEST and LINEST estimation equation in SAS

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 14
Accepted Solution

Excel LOGEST and LINEST estimation equation in SAS

Hi,

Anyone can help me how can I get the Excel's LOGEST and LINEST equation in sas.

Thanks,

KP


Accepted Solutions
Solution
‎11-26-2013 11:51 AM
Super User
Posts: 19,770

Re: Excel LOGEST and LINEST estimation equation in SAS

Posted in reply to Kpatel306

Yes proc reg is what you need, and can be used for both.

You'll need to restructure your data though, so that you have 2 variables and 11 observations instead.

Here's an example of uing proc reg for exponential regression and there is an abundance of proc reg samples in the documentation and online.

http://www.sas.com/offices/NA/canada/downloads/presentations/Calgary/Linear_Regression.pdf

View solution in original post


All Replies
Super User
Posts: 19,770

Re: Excel LOGEST and LINEST estimation equation in SAS

Posted in reply to Kpatel306

What do those functions do?

PS. Please mark questions that are answered as Answered in the forums.

Occasional Contributor
Posts: 14

Re: Excel LOGEST and LINEST estimation equation in SAS

Thanks Reeza, I will do that.

It is LOGEST is Log Estimation and LINES is Linear Estimation - projecting the trend line.

I am somewhat sure that it is possible through Proc Reg, but not sure?

e.g.

if following data I am using to define the equation to estimate the future trend line:

                                               
Period1234567891011
Coll8800054000650006900055000580005900054000530005200051000

Logest will give me following equation:  Coll = Alpha * (Beta ^ Period)

         
LOGEST
BetaAlpha
0.96507173092.48

Linest will give me following equation: Coll =  Alpha + Beta * (Period)

         
LINEST
BetaAlpha
-2318.1873727.27

These equation I can use to forecast the trend.

Thanks,

KP

Solution
‎11-26-2013 11:51 AM
Super User
Posts: 19,770

Re: Excel LOGEST and LINEST estimation equation in SAS

Posted in reply to Kpatel306

Yes proc reg is what you need, and can be used for both.

You'll need to restructure your data though, so that you have 2 variables and 11 observations instead.

Here's an example of uing proc reg for exponential regression and there is an abundance of proc reg samples in the documentation and online.

http://www.sas.com/offices/NA/canada/downloads/presentations/Calgary/Linear_Regression.pdf

Occasional Contributor
Posts: 14

Re: Excel LOGEST and LINEST estimation equation in SAS

Thanks Reeza

🔒 This topic is solved and locked.

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

Discussion stats
  • 4 replies
  • 1023 views
  • 0 likes
  • 2 in conversation