topic Re: reference/proof for a formula used in confidence interval/limit calculation in AUTOREG PROC in SAS Programming

reference/proof for a formula used in confidence interval/limit calculation in AUTOREG PROC

JonathanW — Fri, 12 Apr 2013 16:17:47 GMT

Hi all,

We are using PROC AUTOREG to fit our models, and we need confidence interval/limit for our forecast. There is a formular for that SAS uses for calculation of variable "v" in Section "Predicting Future Series Realizations" in

http://support.sas.com/documentation/cdl/en/etsug/63939/HTML/default/viewer.htm#etsug_autoreg_sect028.htm

I sent a request to SAS support for the reference/proof, but here is the response I got from them:

"I have checked with PROC AUTOREG developer who indicated that first, he does not really have a copy of more detailed derivations than what is currently provided in the documentation. Secondly, there are proprietary reasons that we may not be able to share the derivations with our customers. You may just cite our SAS/ETS documentation as reference for this formula."

The point is that there is no reference in the webpage or SAS online documentation for it. I wonder if any smart/knowledgable guys among you might know the reference/proof, such that I can be sure of what I am using, instead of being given a formula and being told to just use it. Thanks in advance.

Best,

Jonathan

Re: reference/proof for a formula used in confidence interval/limit calculation in AUTOREG PROC

JonathanW — Tue, 23 Apr 2013 14:55:49 GMT

anyone has any idea? thanks.

Re: reference/proof for a formula used in confidence interval/limit calculation in AUTOREG PROC

Reeza — Tue, 23 Apr 2013 15:13:41 GMT

There are two formula's for V, which method were you using?

The explanation under the computational methods didn't seem too unclear to me, but I'd have to verify the math specifically.

SAS/ETS(R) 9.3 User's Guide

Re: reference/proof for a formula used in confidence interval/limit calculation in AUTOREG PROC

JonathanW — Tue, 23 Apr 2013 15:32:49 GMT

thank you for your reply Reeza. the one I am mentioning is the formula for regression with auto-regessive errors:

v=SQRT( z'Vz + s^2 r)

which is in Section "Predicting future series realizations" in

http://support.sas.com/documentation/cdl/en/etsug/63939/HTML/default/viewer.htm#etsug_autoreg_sect028.htm

Also here is what I heard back from SAS:

> I heard back from the development and here are the references he was

> able to locate that was used to derive at the results:

> Baillie, R., 1979, The Asymptotic Mean Squared Error of Multistep

> Prediction from the Regression Model with Autoregressive Errors,

> Journal of the American Statistical Association. Vol. 74, No. 365,

> Mar., 1979,

> 175-184

> Baillie, R., and Bollerslev, T., 1992, Prediction in dynamic models

> with time-dependent conditional variances, Journal of Econometrics,

> 52, 91-113.

Those two papers are

are available on the author's webpage:

https://www.msu.edu/user/baillie/JASA_1979.pdf

https://www.msu.edu/user/baillie/J_Econometrics.1992.pdf

These two papers are helpful, but it's still beyond my capabilities to give a proof of the formula. Hope there could be some experts or smart people that would give a proof for it. thank you again!!

Re: reference/proof for a formula used in confidence interval/limit calculation in AUTOREG PROC

Reeza — Tue, 23 Apr 2013 15:48:31 GMT

I don't have the time or the skills anymore to go through and prove that.

I will say one thing though. For a 'linear regression' the variance of the predictor is a similar formula: http://jackman.stanford.edu/classes/350B/07/predictionforWeb.pdf (see Slide 10).

Which would be enough for me to go with it, but obviously you need to be as well.

Good Luck and hopefully someone else can help more.

Re: reference/proof for a formula used in confidence interval/limit calculation in AUTOREG PROC

JonathanW — Tue, 23 Apr 2013 16:44:53 GMT

Thank you for your quick response Reeza. that formula in your link is for simple regressions without auto-regressive error. the story is quite different if the regression has auto-regressive errors. Thank you again for your effort Reeza, and hope someone else could figure it out...

Re: reference/proof for a formula used in confidence interval/limit calculation in AUTOREG PROC

Rick_SAS — Tue, 23 Apr 2013 17:12:54 GMT

By "proof," do you mean that you want someone to supply a derivation of the formula based on the model assumptions, the properties of the expected value operator, asymptotic properties of distributions, and so forth? Or do you want an explanation of what this formula means (intuitively)?

Re: reference/proof for a formula used in confidence interval/limit calculation in AUTOREG PROC

JonathanW — Tue, 23 Apr 2013 19:23:00 GMT

Hi Rick,

First I want thank you for many great posts in your blog on IML which I, as well as many others, benefit a lot from. We use that formula for the confidence interval of predictions in our model, and we are asked to provide a reference where the formula comes from, or a deriviation if no such reference exists. We actually use regression with auto-regressive errors in many of our models, so we do want to be assured of the correctness of the formula.

thanks,

Jonathan