## Excel LOGEST and LINEST estimation equation in SAS

Solved
Occasional Contributor
Posts: 14

# 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: 23,758

## 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

All Replies
Super User
Posts: 23,758

## 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:

 Period 1 2 3 4 5 6 7 8 9 10 11 Coll 88000 54000 65000 69000 55000 58000 59000 54000 53000 52000 51000

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

 LOGEST Beta Alpha 0.965071 73092.48

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

 LINEST Beta Alpha -2318.18 73727.27

These equation I can use to forecast the trend.

Thanks,

KP

Solution
‎11-26-2013 11:51 AM
Super User
Posts: 23,758

## 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
• 1195 views
• 0 likes
• 2 in conversation