<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: PROC Autoreg - how are residuals for first p observations in AR(p) model calculated? in SAS Forecasting and Econometrics</title>
    <link>https://communities.sas.com/t5/SAS-Forecasting-and-Econometrics/PROC-Autoreg-how-are-residuals-for-first-p-observations-in-AR-p/m-p/742281#M4110</link>
    <description>&lt;P&gt;&lt;SPAN&gt;For the first NLAG = observations or the first NLAG = observations after missing values, the formula R = Y - P does not apply. For the first NLAG = observations, some Kalman Filtering technique is involved in obtaining the predicted values and residuals, (though for the first observation, P is set to be equal to PM). The following section of the PROC AUTOREG documentation contains some discussion which may give you some idea of the computation:&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;A href="https://go.documentation.sas.com/doc/en/pgmsascdc/v_011/etsug/etsug_autoreg_details02.htm#etsug.autoreg.compmethods" target="_blank"&gt;https://go.documentation.sas.com/doc/en/pgmsascdc/v_011/etsug/etsug_autoreg_details02.htm#etsug.autoreg.compmethods&lt;/A&gt;&lt;/P&gt;
&lt;P&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Scroll down to Computational Methods--&amp;gt;Data Transformation and the Kalman Filter , the first two paragraphs illustrate how to calculate the L, the Cholesky root of V where σ^2 V is Ω=E((Y-Xβ) (Y-Xβ)^'). So, from the estimation of AR parameters φ ̂_1,…,φ ̂_m, the V ̂ could be constructed (constructing covariance matrix Ω ̂ and V ̂=Ω ̂/σ ̂^2), then find the Cholesky root of V ̂, L ̂ such that V^=L^L^'. The residual r=L ̂^(-1) (Y-Xβ ̂). How to construct the covariance matrix Ω ̂ from AR parameters and σ^2 is illustrated in equation 3.4.36 in page 59 of Hamilton (1994. Time Series Analysis. Princeton University Press, Princeton, N.J.). The first NLAG residuals may only need the first NLAG by NLAG block of L ̂^(-1).&lt;/SPAN&gt;&lt;/P&gt;</description>
    <pubDate>Tue, 18 May 2021 21:23:21 GMT</pubDate>
    <dc:creator>SASCom1</dc:creator>
    <dc:date>2021-05-18T21:23:21Z</dc:date>
    <item>
      <title>PROC Autoreg - how are residuals for first p observations in AR(p) model calculated?</title>
      <link>https://communities.sas.com/t5/SAS-Forecasting-and-Econometrics/PROC-Autoreg-how-are-residuals-for-first-p-observations-in-AR-p/m-p/741868#M4109</link>
      <description>&lt;P&gt;I noticed that there are two types of residuals and predictions calculated:&lt;/P&gt;
&lt;UL&gt;
&lt;LI&gt;Structural Model (first stage OLS to detrend data)&lt;/LI&gt;
&lt;LI&gt;Total Model (= Structural Model + AR Error Model)&lt;/LI&gt;
&lt;/UL&gt;
&lt;P&gt;However when examining the predictions and residuals, they don't seem to add up for the first p observations and wanted to clarify how these are calculated&lt;/P&gt;
&lt;P&gt;For e.g. in the table below, for obs 1, the total prediction is 0, but the total residuals is -136.85 instead of -243.5 (=DURABLES - predict total)&lt;/P&gt;
&lt;TABLE width="673" aria-label="Data Set WORK.AUTOREG_RES"&gt;
&lt;TBODY&gt;
&lt;TR&gt;
&lt;TD width="64"&gt;Obs&lt;/TD&gt;
&lt;TD width="64"&gt;predict_total&lt;/TD&gt;
&lt;TD width="161"&gt;residual_total&lt;/TD&gt;
&lt;TD width="64"&gt;predict_struct&lt;/TD&gt;
&lt;TD width="64"&gt;residual_struct&lt;/TD&gt;
&lt;TD width="64"&gt;DATE&lt;/TD&gt;
&lt;TD width="64"&gt;_TYPE_&lt;/TD&gt;
&lt;TD width="64"&gt;_LEAD_&lt;/TD&gt;
&lt;TD width="64"&gt;DURABLES&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="64"&gt;1&lt;/TD&gt;
&lt;TD width="64"&gt;0&lt;/TD&gt;
&lt;TD&gt;-136.85&lt;/TD&gt;
&lt;TD width="64"&gt;0&lt;/TD&gt;
&lt;TD&gt;-243.5&lt;/TD&gt;
&lt;TD width="64"&gt;Jan-80&lt;/TD&gt;
&lt;TD width="64"&gt;RESIDUAL&lt;/TD&gt;
&lt;TD width="64"&gt;0&lt;/TD&gt;
&lt;TD&gt;-243.5&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="64"&gt;2&lt;/TD&gt;
&lt;TD&gt;-73.87&lt;/TD&gt;
&lt;TD width="161"&gt;5033.78&lt;/TD&gt;
&lt;TD width="64"&gt;0&lt;/TD&gt;
&lt;TD width="64"&gt;8460.6&lt;/TD&gt;
&lt;TD width="64"&gt;Feb-80&lt;/TD&gt;
&lt;TD width="64"&gt;RESIDUAL&lt;/TD&gt;
&lt;TD width="64"&gt;0&lt;/TD&gt;
&lt;TD width="64"&gt;8460.6&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="64"&gt;3&lt;/TD&gt;
&lt;TD width="64"&gt;2642.39&lt;/TD&gt;
&lt;TD width="161"&gt;4439&lt;/TD&gt;
&lt;TD width="64"&gt;0&lt;/TD&gt;
&lt;TD width="64"&gt;10165.7&lt;/TD&gt;
&lt;TD width="64"&gt;Mar-80&lt;/TD&gt;
&lt;TD width="64"&gt;RESIDUAL&lt;/TD&gt;
&lt;TD width="64"&gt;0&lt;/TD&gt;
&lt;TD width="64"&gt;10165.7&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="64"&gt;4&lt;/TD&gt;
&lt;TD width="64"&gt;2282.5&lt;/TD&gt;
&lt;TD width="161"&gt;708.65&lt;/TD&gt;
&lt;TD width="64"&gt;0&lt;/TD&gt;
&lt;TD width="64"&gt;3444.8&lt;/TD&gt;
&lt;TD width="64"&gt;Apr-80&lt;/TD&gt;
&lt;TD width="64"&gt;RESIDUAL&lt;/TD&gt;
&lt;TD width="64"&gt;0&lt;/TD&gt;
&lt;TD width="64"&gt;3444.8&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="64"&gt;5&lt;/TD&gt;
&lt;TD width="64"&gt;2607.48&lt;/TD&gt;
&lt;TD&gt;-1756.04&lt;/TD&gt;
&lt;TD width="64"&gt;0&lt;/TD&gt;
&lt;TD&gt;-233.1&lt;/TD&gt;
&lt;TD width="64"&gt;May-80&lt;/TD&gt;
&lt;TD width="64"&gt;RESIDUAL&lt;/TD&gt;
&lt;TD width="64"&gt;0&lt;/TD&gt;
&lt;TD&gt;-233.1&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="64"&gt;6&lt;/TD&gt;
&lt;TD width="64"&gt;519.1&lt;/TD&gt;
&lt;TD width="161"&gt;1444.32&lt;/TD&gt;
&lt;TD width="64"&gt;0&lt;/TD&gt;
&lt;TD width="64"&gt;2801&lt;/TD&gt;
&lt;TD width="64"&gt;Jun-80&lt;/TD&gt;
&lt;TD width="64"&gt;RESIDUAL&lt;/TD&gt;
&lt;TD width="64"&gt;0&lt;/TD&gt;
&lt;TD width="64"&gt;2801&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="64"&gt;7&lt;/TD&gt;
&lt;TD width="64"&gt;12.12&lt;/TD&gt;
&lt;TD&gt;-5722.97&lt;/TD&gt;
&lt;TD width="64"&gt;0&lt;/TD&gt;
&lt;TD&gt;-7971.9&lt;/TD&gt;
&lt;TD width="64"&gt;Jul-80&lt;/TD&gt;
&lt;TD width="64"&gt;RESIDUAL&lt;/TD&gt;
&lt;TD width="64"&gt;0&lt;/TD&gt;
&lt;TD&gt;-7971.9&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="64"&gt;8&lt;/TD&gt;
&lt;TD width="64"&gt;906.53&lt;/TD&gt;
&lt;TD&gt;-3244.69&lt;/TD&gt;
&lt;TD width="64"&gt;0&lt;/TD&gt;
&lt;TD&gt;-3507.81&lt;/TD&gt;
&lt;TD width="64"&gt;Aug-80&lt;/TD&gt;
&lt;TD width="64"&gt;RESIDUAL&lt;/TD&gt;
&lt;TD width="64"&gt;0&lt;/TD&gt;
&lt;TD&gt;-3507.81&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="64"&gt;9&lt;/TD&gt;
&lt;TD width="64"&gt;3172.29&lt;/TD&gt;
&lt;TD width="161"&gt;3045.45&lt;/TD&gt;
&lt;TD width="64"&gt;0&lt;/TD&gt;
&lt;TD width="64"&gt;7314.29&lt;/TD&gt;
&lt;TD width="64"&gt;Sep-80&lt;/TD&gt;
&lt;TD width="64"&gt;RESIDUAL&lt;/TD&gt;
&lt;TD width="64"&gt;0&lt;/TD&gt;
&lt;TD width="64"&gt;7314.29&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="64"&gt;10&lt;/TD&gt;
&lt;TD width="64"&gt;1505.36&lt;/TD&gt;
&lt;TD width="161"&gt;5866.55&lt;/TD&gt;
&lt;TD width="64"&gt;0&lt;/TD&gt;
&lt;TD width="64"&gt;9482.39&lt;/TD&gt;
&lt;TD width="64"&gt;Oct-80&lt;/TD&gt;
&lt;TD width="64"&gt;RESIDUAL&lt;/TD&gt;
&lt;TD width="64"&gt;0&lt;/TD&gt;
&lt;TD width="64"&gt;9482.39&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="64"&gt;11&lt;/TD&gt;
&lt;TD width="64"&gt;2800.77&lt;/TD&gt;
&lt;TD width="161"&gt;1529.45&lt;/TD&gt;
&lt;TD width="64"&gt;0&lt;/TD&gt;
&lt;TD width="64"&gt;4860.49&lt;/TD&gt;
&lt;TD width="64"&gt;Nov-80&lt;/TD&gt;
&lt;TD width="64"&gt;RESIDUAL&lt;/TD&gt;
&lt;TD width="64"&gt;0&lt;/TD&gt;
&lt;TD width="64"&gt;4860.49&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="64"&gt;12&lt;/TD&gt;
&lt;TD width="64"&gt;2967.3&lt;/TD&gt;
&lt;TD&gt;-625.37&lt;/TD&gt;
&lt;TD width="64"&gt;0&lt;/TD&gt;
&lt;TD width="64"&gt;2138.59&lt;/TD&gt;
&lt;TD width="64"&gt;Dec-80&lt;/TD&gt;
&lt;TD width="64"&gt;RESIDUAL&lt;/TD&gt;
&lt;TD width="64"&gt;0&lt;/TD&gt;
&lt;TD width="64"&gt;2138.59&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="64"&gt;13&lt;/TD&gt;
&lt;TD&gt;-3093.05&lt;/TD&gt;
&lt;TD width="161"&gt;161.77&lt;/TD&gt;
&lt;TD width="64"&gt;0&lt;/TD&gt;
&lt;TD&gt;-2898.31&lt;/TD&gt;
&lt;TD width="64"&gt;Jan-81&lt;/TD&gt;
&lt;TD width="64"&gt;RESIDUAL&lt;/TD&gt;
&lt;TD width="64"&gt;0&lt;/TD&gt;
&lt;TD&gt;-2898.31&lt;/TD&gt;
&lt;/TR&gt;
&lt;/TBODY&gt;
&lt;/TABLE&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Code to generate this was from following:&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;PRE&gt;&lt;CODE class=" language-sas"&gt;proc forecast data=sashelp.usecon interval=month
              method=stepar nlags = 0 trend=2 lead=0
              out=out outresid outfull outest=est;
   id date;
   var durables;
   where date &amp;gt;= '1jan80'd;
run;

proc sql;
CREATE TABLE resid AS
SELECT *, 0 AS zer FROM out
WHERE _TYPE_ = 'RESIDUAL';
run;

proc autoreg data=resid;
   model durables = zer/ noint nlag=(1 6 10 12 13) method=yw;
   output out = autoreg_res pm = predict_struct p = predict_total rm = residual_struct r = residual_total;
run;&lt;/CODE&gt;&lt;/PRE&gt;</description>
      <pubDate>Mon, 17 May 2021 14:19:49 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Forecasting-and-Econometrics/PROC-Autoreg-how-are-residuals-for-first-p-observations-in-AR-p/m-p/741868#M4109</guid>
      <dc:creator>promo_at_work</dc:creator>
      <dc:date>2021-05-17T14:19:49Z</dc:date>
    </item>
    <item>
      <title>Re: PROC Autoreg - how are residuals for first p observations in AR(p) model calculated?</title>
      <link>https://communities.sas.com/t5/SAS-Forecasting-and-Econometrics/PROC-Autoreg-how-are-residuals-for-first-p-observations-in-AR-p/m-p/742281#M4110</link>
      <description>&lt;P&gt;&lt;SPAN&gt;For the first NLAG = observations or the first NLAG = observations after missing values, the formula R = Y - P does not apply. For the first NLAG = observations, some Kalman Filtering technique is involved in obtaining the predicted values and residuals, (though for the first observation, P is set to be equal to PM). The following section of the PROC AUTOREG documentation contains some discussion which may give you some idea of the computation:&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;A href="https://go.documentation.sas.com/doc/en/pgmsascdc/v_011/etsug/etsug_autoreg_details02.htm#etsug.autoreg.compmethods" target="_blank"&gt;https://go.documentation.sas.com/doc/en/pgmsascdc/v_011/etsug/etsug_autoreg_details02.htm#etsug.autoreg.compmethods&lt;/A&gt;&lt;/P&gt;
&lt;P&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Scroll down to Computational Methods--&amp;gt;Data Transformation and the Kalman Filter , the first two paragraphs illustrate how to calculate the L, the Cholesky root of V where σ^2 V is Ω=E((Y-Xβ) (Y-Xβ)^'). So, from the estimation of AR parameters φ ̂_1,…,φ ̂_m, the V ̂ could be constructed (constructing covariance matrix Ω ̂ and V ̂=Ω ̂/σ ̂^2), then find the Cholesky root of V ̂, L ̂ such that V^=L^L^'. The residual r=L ̂^(-1) (Y-Xβ ̂). How to construct the covariance matrix Ω ̂ from AR parameters and σ^2 is illustrated in equation 3.4.36 in page 59 of Hamilton (1994. Time Series Analysis. Princeton University Press, Princeton, N.J.). The first NLAG residuals may only need the first NLAG by NLAG block of L ̂^(-1).&lt;/SPAN&gt;&lt;/P&gt;</description>
      <pubDate>Tue, 18 May 2021 21:23:21 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Forecasting-and-Econometrics/PROC-Autoreg-how-are-residuals-for-first-p-observations-in-AR-p/m-p/742281#M4110</guid>
      <dc:creator>SASCom1</dc:creator>
      <dc:date>2021-05-18T21:23:21Z</dc:date>
    </item>
  </channel>
</rss>

