topic writing residuals to an excel file in SAS Forecasting and Econometrics https://communities.sas.com/t5/SAS-Forecasting-and-Econometrics/writing-residuals-to-an-excel-file/m-p/89161#M458 <HTML><HEAD></HEAD><BODY><P>I need to fit a AR(1) model to the attached data set and out put the RESIDUALS to an excel file for plotting.</P><P>Can some one help me with this writing residuals to an excel file step please?</P></BODY></HTML> Mon, 03 Dec 2012 21:26:07 GMT malakaext 2012-12-03T21:26:07Z writing residuals to an excel file https://communities.sas.com/t5/SAS-Forecasting-and-Econometrics/writing-residuals-to-an-excel-file/m-p/89161#M458 <HTML><HEAD></HEAD><BODY><P>I need to fit a AR(1) model to the attached data set and out put the RESIDUALS to an excel file for plotting.</P><P>Can some one help me with this writing residuals to an excel file step please?</P></BODY></HTML> Mon, 03 Dec 2012 21:26:07 GMT https://communities.sas.com/t5/SAS-Forecasting-and-Econometrics/writing-residuals-to-an-excel-file/m-p/89161#M458 malakaext 2012-12-03T21:26:07Z Re: writing residuals to an excel file https://communities.sas.com/t5/SAS-Forecasting-and-Econometrics/writing-residuals-to-an-excel-file/m-p/89162#M459 <HTML><HEAD></HEAD><BODY><P>data have;</P><P>input ar;</P><P>i=_n_;</P><P>cards;</P><P>-1.703233141</P><P>-1.703850657</P><P>0.091440462</P><P>0.022882462</P><P>-0.224949807</P><P>1.367217146</P><P>2.512797936</P><P>0.669231031</P><P>-0.150223471</P><P>0.759437408</P><P>0.435890183</P><P>0.242421635</P><P>0.766223353</P><P>0.673573325</P><P>0.589709362</P><P>0.619025926</P><P>-0.731962503</P><P>-0.669309886</P><P>-0.277606805</P><P>-0.093268198</P><P>0.04727051</P><P>0.282256656</P><P>-1.015885861</P><P>-0.962834737</P><P>0.612218648</P><P>1.357896244</P><P>0.589988689</P><P>0.637063037</P><P>0.974907176</P><P>1.004179541</P><P>0.589961515</P><P>1.547349773</P><P>1.730216041</P><P>-0.861477052</P><P>-2.626268836</P><P>-1.779317662</P><P>0.061755533</P><P>1.534604015</P><P>0.526923035</P><P>1.614684892</P><P>0.173828311</P><P>0.488559228</P><P>0.719774332</P><P>-0.191777895</P><P>-1.771017794</P><P>-0.058856223</P><P>0.679685944</P><P>3.269724873</P><P>1.091529825</P><P>0.971006867</P><P>-0.107460208</P><P>0.293076027</P><P>0.370636623</P><P>0.533093946</P><P>0.391928966</P><P>-0.492171644</P><P>0.839278575</P><P>-0.425762518</P><P>-1.207455241</P><P>-1.54961444</P><P>-1.641561189</P><P>-0.27123277</P><P>-0.397213342</P><P>0.724231229</P><P>-0.157298162</P><P>1.066291385</P><P>1.128867801</P><P>1.609255864</P><P>0.086916055</P><P>-0.115766379</P><P>0.537818057</P><P>-0.343593782</P><P>-2.467415689</P><P>-2.173708286</P><P>0.072657043</P><P>-0.375419903</P><P>0.338660815</P><P>1.011734183</P><P>-0.158013934</P><P>0.239575285</P><P>-2.583980999</P><P>-2.846387638</P><P>-0.603616568</P><P>-0.497500862</P><P>0.297922</P><P>-0.015076177</P><P>0.150838215</P><P>-0.115385963</P><P>-1.732796511</P><P>-1.592980786</P><P>-1.401058263</P><P>-0.969909419</P><P>-0.163289582</P><P>0.762052852</P><P>-1.585677285</P><P>-1.418407659</P><P>-1.243692625</P><P>0.622140761</P><P>0.485028199</P><P>0.933575088</P><P>0.788277596</P><P>0.069538939</P><P>0.235537624</P><P>-0.736203794</P><P>0.318672947</P><P>1.017047843</P><P>0.933484359</P><P>0.741096717</P><P>1.714004131</P><P>1.739542595</P><P>-0.033124656</P><P>-0.173701443</P><P>0.440641251</P><P>0.643783836</P><P>0.457639771</P><P>-0.620456893</P><P>-1.37360193</P><P>-0.95579669</P><P>-0.277869925</P><P>0.751280471</P><P>-0.062705563</P><P>-0.688951776</P><P>1.60764724</P><P>0.568455209</P><P>-0.373085754</P><P>-0.942035048</P><P>-0.081296576</P><P>-1.647495371</P><P>0.173496866</P><P>2.966331223</P><P>2.245816685</P><P>2.100557048</P><P>-1.077766643</P><P>-1.161580974</P><P>-0.93895674</P><P>1.022260341</P><P>1.237106891</P><P>0.839522745</P><P>0.205026862</P><P>0.630623776</P><P>0.531449234</P><P>-0.714343268</P><P>-1.355814622</P><P>0.548880834</P><P>0.267590847</P><P>-1.014296508</P><P>-0.098426097</P><P>-0.491855559</P><P>1.225178831</P><P>0.470209127</P><P>0.699238472</P><P>0.5724062</P><P>0.029438365</P><P>-0.482742156</P><P>-0.723112385</P><P>0.989385252</P><P>0.989329295</P><P>-0.578363002</P><P>1.321796813</P><P>-0.874560301</P><P>-0.631065408</P><P>-1.529170029</P><P>-2.681906783</P><P>-0.119903064</P><P>0.004533811</P><P>0.730458562</P><P>0.578137122</P><P>0.236370805</P><P>-2.079182525</P><P>-0.071340718</P><P>-0.303920122</P><P>0.613980152</P><P>1.371999419</P><P>-0.814722568</P><P>-1.848830753</P><P>-0.130395496</P><P>-0.509307917</P><P>-0.393216756</P><P>-1.421626376</P><P>-1.260456909</P><P>1.717350204</P><P>-0.061588567</P><P>1.576699575</P><P>0.158695843</P><P>0.673967143</P><P>-0.01453695</P><P>-0.4530414</P><P>-0.88008168</P><P>-0.474358787</P><P>-1.648059003</P><P>-0.904919194</P><P>-0.5591077</P><P>0.733474439</P><P>0.940235238</P><P>-0.212510383</P><P>-0.656917914</P><P>0.371847888</P><P>-0.844212576</P><P>0.333547821</P><P>1.619507802</P><P>0.369515674</P><P>0.804317214</P><P>0.89894827</P><P>0.77951859</P><P>0.981110897</P><P>0.314118497</P><P>-1.051161227</P><P>-2.210462871</P><P>-0.657069879</P><P>1.492717871</P><P>1.553498307</P><P>-1.024299473</P><P>-2.197860477</P><P>-0.925403182</P><P>-0.583727976</P><P>-0.976836244</P><P>-2.19909525</P><P>-0.725045734</P><P>-1.776861852</P><P>1.627229106</P><P>2.361392176</P><P>1.397083255</P><P>0.192149392</P><P>-0.552117478</P><P>-0.598968735</P><P>-1.23673472</P><P>-0.602974611</P><P>0.787100327</P><P>0.536302509</P><P>-1.008315127</P><P>0.084224151</P><P>-1.167576987</P><P>-0.405077966</P><P>-1.203027374</P><P>-1.378858106</P><P>-1.698293468</P><P>-2.093450717</P><P>-1.1818349</P><P>-1.247048078</P><P>-3.544954943</P><P>-1.092977498</P><P>-1.298717529</P><P>0.906210929</P><P>0.800989891</P><P>2.236083499</P><P>-0.362437186</P><P>0.422974814</P><P>0.588826273</P><P>-0.336866824</P><P>1.204007401</P><P>0.677138821</P><P>-1.331655364</P><P>-2.241190093</P><P>0.184259721</P><P>1.930920361</P><P>2.311793146</P><P>1.109200185</P><P>-0.791974638</P><P>-1.08564213</P><P>1.607991439</P><P>1.011779543</P><P>-0.094338971</P><P>-1.928330832</P><P>-3.106928547</P><P>-0.091950645</P><P>1.495767441</P><P>1.683371251</P><P>2.346405952</P><P>1.89038747</P><P>-0.46201662</P><P>-0.542984672</P><P>0.602729159</P><P>0.36527735</P><P>1.262175791</P><P>0.162724826</P><P>-2.066036176</P><P>0.243493142</P><P>1.731903261</P><P>-0.415348157</P><P>-0.389712366</P><P>0.007746851</P><P>-0.268180566</P><P>-0.464236965</P><P>-1.806022722</P><P>-1.310659139</P><P>0.391443028</P><P>0.55421646</P><P>0.464512184</P><P>-0.431567189</P><P>-1.541712974</P><P>-1.406008525</P><P>-2.755092752</P><P>-2.200624179</P><P>-1.43483199</P><P>0.704004341</P><P>0.185227002</P><P>0.939864088</P><P>0.232468301</P><P>-0.773638109</P><P>1.113680641</P><P>0.705881922</P><P>-0.714587966</P><P>-2.015997007</P><P>-0.807841071</P><P>-0.552233873</P><P>-0.805833024</P><P>-1.050298585</P><P>2.041769753</P><P>3.492041813</P><P>0.166761303</P><P>0.302023916</P><P>-1.568907022</P><P>-1.774899356</P><P>-2.006743891</P><P>-2.083914682</P><P>0.321201287</P><P>-0.005636432</P><P>-0.444885535</P><P>-0.906073134</P><P>1.158743314</P><P>1.194715332</P><P>0.777231062</P><P>-1.625914092</P><P>-2.959616502</P><P>-1.547453664</P><P>0.237328828</P><P>-0.061896927</P><P>-1.014056666</P><P>-0.59835862</P><P>-1.77473216</P><P>-1.461187464</P><P>-0.312216045</P><P>-1.371742185</P><P>-0.148572264</P><P>-0.501180413</P><P>0.173015441</P><P>-0.062940728</P><P>1.320793115</P><P>1.617685141</P><P>0.413626948</P><P>-0.304411351</P><P>-0.120355904</P><P>0.965082051</P><P>0.009849071</P><P>2.026863315</P><P>1.646435429</P><P>-0.380605304</P><P>-0.165769236</P><P>0.60243475</P><P>0.70210055</P><P>-0.585501567</P><P>-0.663213955</P><P>-0.557129177</P><P>-0.468884536</P><P>-0.442566792</P><P>0.485117227</P><P>-1.253108375</P><P>1.404758252</P><P>0.129529169</P><P>-0.999482169</P><P>0.529962734</P><P>-0.182542511</P><P>0.500887528</P><P>1.050330058</P><P>3.047949942</P><P>1.846735789</P><P>0.438194217</P><P>0.774039271</P><P>2.380831831</P><P>0.714461788</P><P>-0.991705441</P><P>-1.812732618</P><P>-0.31411008</P><P>-0.64944534</P><P>-1.258499416</P><P>-0.915516218</P><P>-0.271856335</P><P>-1.911122908</P><P>-1.291926834</P><P>-1.767002829</P><P>-0.391157141</P><P>-1.024920688</P><P>-2.589483443</P><P>0.198653089</P><P>0.448796084</P><P>-1.392323862</P><P>-0.880774034</P><P>0.104594641</P><P>0.824904778</P><P>0.479992249</P><P>-0.085901242</P><P>0.91284545</P><P>-0.770693108</P><P>1.506673497</P><P>-1.179183132</P><P>-0.999483257</P><P>0.104652556</P><P>0.200867468</P><P>-0.419183962</P><P>1.493706233</P><P>0.790044333</P><P>0.376065424</P><P>1.399303856</P><P>0.587585705</P><P>-0.44743918</P><P>-0.454349503</P><P>-0.275231988</P><P>-1.241886252</P><P>-0.54750486</P><P>-0.282745587</P><P>1.22568246</P><P>-1.497636619</P><P>-1.32345921</P><P>-0.742289702</P><P>-2.699060814</P><P>-1.051398766</P><P>-1.410396453</P><P>-0.921759574</P><P>0.500252211</P><P>-0.810993728</P><P>-0.348990116</P><P>1.368846573</P><P>-0.133754853</P><P>2.271797928</P><P>0.694942069</P><P>0.337811568</P><P>-0.499364258</P><P>-0.12218939</P><P>-0.261627236</P><P>0.806883033</P><P>-0.209998381</P><P>0.831548748</P><P>0.317192399</P><P>-0.151603793</P><P>0.229057983</P><P>1.544714194</P><P>0.705456536</P><P>0.554796121</P><P>-0.164542602</P><P>1.340979979</P><P>0.27013942</P><P>-1.635102833</P><P>-0.571436879</P><P>-1.829335436</P><P>0.286513495</P><P>0.060524518</P><P>0.283567358</P><P>1.545713755</P><P>0.419145283</P><P>0.631324685</P><P>-0.771673491</P><P>0.360090947</P><P>-0.550902449</P><P>-0.791437388</P><P>-1.114134223</P><P>0.426264571</P><P>-0.300942025</P><P>1.28479551</P><P>-0.201906968</P><P>-2.1698603</P><P>-0.763315024</P><P>0.561826226</P><P>-0.233745234</P><P>-0.093263909</P><P>-0.048754834</P><P>-1.202850944</P><P>-2.780207782</P><P>-1.773726667</P><P>-1.169196279</P><P>-1.926808303</P><P>0.798141217</P><P>-1.916343444</P><P>-2.435401211</P><P>-1.525288907</P><P>-0.494366929</P><P>0.647918229</P><P>0.73818663</P><P>-0.08780999</P><P>0.494788154</P><P>2.442941919</P><P>0.839549054</P><P>-1.272061449</P><P>0.904141233</P><P>-1.904132959</P><P>-1.729758415</P><P>-1.776267913</P><P>-2.169291806</P><P>-2.297256362</P><P>-0.53306235</P><P>0.490982244</P><P>0.791824657</P><P>1.459281082</P><P>-0.054616456</P><P>-0.359706556</P><P>-0.144130081</P><P>-0.923044826</P><P>-2.523280678</P><P>-2.882883854</P><P>-1.786493173</P><P>-0.111820397</P><P>0.84120808</P><P>1.53546941</P><P>-0.483527434</P><P>-0.489710706</P><P>1.703309964</P><P>0.945793987</P><P>0.424951757</P><P>-0.778086661</P><P>0.507712855</P><P>-0.427705531</P><P>1.023315002</P><P>2.142572142</P><P>1.351279261</P><P>0.747828058</P><P>0.177526009</P><P>0.077684339</P><P>0.29094858</P><P>0.093171908</P><P>0.219146046</P><P>1.18602888</P><P>0.449315792</P><P>0.911844076</P><P>2.523371914</P><P>0.82965641</P><P>-0.212184145</P><P>0.265989756</P><P>-1.576975336</P><P>-1.262854119</P><P>-1.0576732</P><P>0.032535466</P><P>-0.806127533</P><P>1.087518257</P><P>-0.390026142</P><P>0.23994921</P><P>0.642031813</P><P>-0.092846882</P><P>-0.022142393</P><P>1.435825384</P><P>0.377281555</P><P>-0.676019356</P><P>0.647964027</P><P>-0.459169595</P><P>-2.258486877</P><P>-3.846413176</P><P>-1.03565261</P><P>-2.139354005</P><P>-3.097029764</P><P>-2.857969316</P><P>-2.802317572</P><P>-0.605923201</P><P>-0.572358519</P><P>-0.854400952</P><P>-1.276206431</P><P>-1.616642367</P><P>-1.805612612</P><P>-0.821497021</P><P>0.430490664</P><P>1.444210812</P><P>0.512463713</P><P>0.432976074</P><P>-0.004116495</P><P>1.446708412</P><P>0.006330164</P><P>0.294152112</P><P>0.523739919</P><P>0.791703034</P><P>0.347739544</P><P>-0.579369455</P><P>0.131745396</P><P>-0.601044398</P><P>-1.575871606</P><P>-1.0625899</P><P>-0.441181866</P><P>0.569096116</P><P>-0.268895279</P><P>-0.704016338</P><P>0.857445835</P><P>-0.303369363</P><P>0.249254948</P><P>0.853137327</P><P>2.018482976</P><P>0.326340389</P><P>0.603675756</P><P>-2.032820315</P><P>-1.318561645</P><P>-1.070525997</P><P>-0.613038816</P><P>-2.315693533</P><P>-0.319707816</P><P>-0.455340316</P><P>0.477791853</P><P>-0.222339285</P><P>-0.591105311</P><P>-1.477556892</P><P>-1.116388942</P><P>0.781269276</P><P>-0.413368571</P><P>0.323735684</P><P>-1.016287902</P><P>0.787329476</P><P>0.009812545</P><P>2.627247402</P><P>1.624402027</P><P>0.875536815</P><P>0.198283053</P><P>-1.02804807</P><P>1.177035215</P><P>3.279408104</P><P>2.637042077</P><P>1.004018397</P><P>0.413187336</P><P>-0.322618191</P><P>-0.102609688</P><P>-0.066468288</P><P>0.670523431</P><P>1.732973963</P><P>1.43457463</P><P>1.258553795</P><P>0.566980784</P><P>1.295704521</P><P>1.008934004</P><P>2.124811289</P><P>-0.353772447</P><P>-0.224305266</P><P>1.903396872</P><P>1.020991231</P><P>2.745426738</P><P>1.866075475</P><P>0.912030299</P><P>0.546062698</P><P>-0.465859546</P><P>-2.615649423</P><P>-0.333521219</P><P>-0.161382514</P><P>-1.25793969</P><P>-1.600986607</P><P>1.218107365</P><P>0.994386829</P><P>-0.03749181</P><P>2.780473543</P><P>2.348185251</P><P>3.396985106</P><P>1.265746757</P><P>-0.592893626</P><P>0.68208655</P><P>0.817035399</P><P>0.228205488</P><P>0.199610576</P><P>-0.787236225</P><P>0.516510758</P><P>0.074959376</P><P>0.551352643</P><P>0.858844294</P><P>-0.54286223</P><P>-1.8812778</P><P>-0.609824488</P><P>-0.90353558</P><P>-0.800512887</P><P>-0.046958199</P><P>-0.708947799</P><P>-1.808564699</P><P>-1.498610564</P><P>-0.141525712</P><P>-0.702017354</P><P>0.136052747</P><P>-0.651297207</P><P>0.00725727</P><P>-0.446444564</P><P>0.128742257</P><P>-0.202727822</P><P>-1.080402149</P><P>-0.258480456</P><P>0.779876286</P><P>0.526460757</P><P>1.937161438</P><P>0.444082486</P><P>-1.789071415</P><P>-0.061286455</P><P>0.314832954</P><P>1.91249016</P><P>0.946714999</P><P>-0.337655897</P><P>-0.77658777</P><P>0.38667357</P><P>-0.308544342</P><P>-0.752366159</P><P>1.323908431</P><P>0.532311542</P><P>0.187344601</P><P>-0.748438977</P><P>-1.119948885</P><P>0.657197252</P><P>1.706374653</P><P>0.850581557</P><P>1.276079066</P><P>0.463038209</P><P>0.143438031</P><P>-0.211696496</P><P>-0.307528028</P><P>1.025338791</P><P>0.322346751</P><P>-2.446036742</P><P>-2.835372424</P><P>-1.692434656</P><P>-2.372605056</P><P>-1.581154377</P><P>-0.114131448</P><P>-0.254987871</P><P>-1.727749693</P><P>-2.220071323</P><P>0.171576056</P><P>-0.601633671</P><P>0.003036179</P><P>0.167370514</P><P>-1.403631277</P><P>-0.424156178</P><P>0.407621063</P><P>-0.019708837</P><P>-0.020534277</P><P>-1.055446499</P><P>-1.903050417</P><P>0.05588195</P><P>0.472787452</P><P>0.25333176</P><P>0.460258792</P><P>0.176142292</P><P>-1.901514346</P><P>0.895017423</P><P>-1.311799499</P><P>-1.534454147</P><P>-0.568706536</P><P>0.027726273</P><P>0.078868101</P><P>-0.36176327</P><P>-0.212113731</P><P>0.891889134</P><P>-0.654241962</P><P>-0.772683008</P><P>-2.151932437</P><P>-1.073949767</P><P>-2.213492052</P><P>-0.787207651</P><P>-0.546355251</P><P>-0.01664553</P><P>-0.359662154</P><P>-0.289378286</P><P>-1.42351752</P><P>-2.729965572</P><P>-1.572265449</P><P>0.0633524</P><P>-1.078185336</P><P>-1.625986028</P><P>-2.121553082</P><P>-1.25899818</P><P>0.368285546</P><P>2.154017322</P><P>-0.006309629</P><P>1.00871734</P><P>1.881835254</P><P>0.79666723</P><P>1.272574065</P><P>0.421689863</P><P>0.227800011</P><P>1.680619044</P><P>1.694901826</P><P>-0.642635177</P><P>-1.802705932</P><P>-1.170164634</P><P>-2.339469297</P><P>-1.896363617</P><P>1.411603907</P><P>1.349879621</P><P>-0.813043952</P><P>-2.518939354</P><P>-2.128260717</P><P>-1.073169423</P><P>0.086409574</P><P>1.171839549</P><P>0.122476732</P><P>-0.658564067</P><P>-0.381597911</P><P>-0.883972548</P><P>-0.265679028</P><P>-1.347483667</P><P>-0.302503272</P><P>0.502296744</P><P>1.213052769</P><P>2.356581793</P><P>0.684726023</P><P>0.230133972</P><P>0.028201738</P><P>0.345406328</P><P>0.510971281</P><P>-0.523218249</P><P>1.008925405</P><P>1.634181192</P><P>1.699309674</P><P>1.20360065</P><P>1.76302193</P><P>-0.354031663</P><P>1.531969991</P><P>0.348317166</P><P>-1.370224157</P><P>-1.566432533</P><P>-0.497490709</P><P>1.400243671</P><P>1.961763668</P><P>1.048566542</P><P>0.60150767</P><P>0.316668128</P><P>0.211187799</P><P>1.013126244</P><P>3.278861747</P><P>0.222995251</P><P>0.076025269</P><P>-0.879239314</P><P>-0.532042965</P><P>-0.112867199</P><P>-1.105592151</P><P>0.268047884</P><P>0.548791714</P><P>0.658795958</P><P>-0.84636307</P><P>-1.868203866</P><P>0.512840297</P><P>-0.214583369</P><P>0.732722162</P><P>-0.076786357</P><P>-0.724437049</P><P>-0.611197495</P><P>0.259804052</P><P>-0.433211778</P><P>-2.09587017</P><P>-0.178208642</P><P>0.163117194</P><P>-1.350474758</P><P>-1.657902624</P><P>-0.532721429</P><P>-0.353796282</P><P>-0.335818986</P><P>-1.419651667</P><P>-1.011340271</P><P>-0.344794941</P><P>0.274774603</P><P>-0.451610732</P><P>-0.47018028</P><P>-0.08677203</P><P>-0.797121628</P><P>-0.125112035</P><P>1.258875426</P><P>2.288296555</P><P>0.600061715</P><P>0.341394655</P><P>1.398991813</P><P>2.413507929</P><P>0.627215886</P><P>0.106964459</P><P>-1.566159674</P><P>-0.737681701</P><P>-1.879033497</P><P>-2.731023466</P><P>-1.910367649</P><P>-1.212584476</P><P>-2.605262345</P><P>-1.123155746</P><P>1.680149826</P><P>2.623306503</P><P>1.733784681</P><P>1.682015602</P><P>0.178976589</P><P>0.828821229</P><P>-0.131652061</P><P>-2.398287506</P><P>-1.887145279</P><P>-1.591108562</P><P>-0.60114794</P><P>-1.268214397</P><P>-0.723626093</P><P>-0.727599428</P><P>-0.692625639</P><P>-0.229393052</P><P>-2.215957108</P><P>-1.617688747</P><P>0.841156825</P><P>-0.239381631</P><P>-2.403720702</P><P>-1.345598957</P><P>-0.100882014</P><P>0.31246694</P><P>0.159834357</P><P>0.528263873</P><P>-0.272162148</P><P>0.908264948</P><P>-0.713042299</P><P>-0.146195476</P><P>-1.247922326</P><P>-1.132410857</P><P>-0.531058382</P><P>-0.729990239</P><P>-1.422574028</P><P>2.028460338</P><P>0.739759149</P><P>-0.143274668</P><P>0.051202795</P><P>-0.006169156</P><P>0.364017203</P><P>-0.636566657</P><P>0.875010843</P><P>-0.680184452</P><P>0.821683149</P><P>0.155056631</P><P>-0.080160643</P><P>-0.988727654</P><P>0.486830123</P><P>1.890638186</P><P>1.017438622</P><P>-0.723179744</P><P>-1.38879166</P><P>1.008877003</P><P>1.041034374</P><P>-1.30116503</P><P>-0.87181454</P><P>0.999164831</P><P>-0.081475743</P><P>0.161428186</P><P>-0.16825921</P><P>1.596978276</P><P>1.388488299</P><P>-0.856242014</P><P>0.242278146</P><P>-0.281505643</P><P>0.887655405</P><P>1.642655771</P><P>1.238461556</P><P>-0.747157397</P><P>-0.557633869</P><P>-0.011679166</P><P>0.069909113</P><P>-0.811212607</P><P>-1.065810433</P><P>-0.859770578</P><P>-1.631517634</P><P>-1.923401419</P><P>-0.655575151</P><P>-2.33294895</P><P>-0.575916946</P><P>-0.125594946</P><P>-0.252088319</P><P>-1.164765568</P><P>-0.539233534</P><P>1.726405418</P><P>-0.181177025</P><P>2.603062891</P><P>2.111718656</P><P>1.329988036</P><P>-0.024842977</P><P>-0.278186805</P><P>-0.207653587</P><P>-0.164695566</P><P>-3.396457823</P><P>-3.500308469</P><P>-2.149867681</P><P>-0.976943982</P><P>-1.243429489</P><P>0.075316396</P><P>1.062966307</P><P>0.323823434</P><P>0.84395791</P><P>1.129555031</P><P>1.228139926</P><P>1.243521791</P><P>0.113778895</P><P>0.714317526</P><P>0.566813465</P><P>-0.734423548</P><P>1.697551258</P><P>2.111181943</P><P>1.628494325</P><P>-0.08886197</P><P>2.229940274</P><P>1.095423802</P><P>-1.269850982</P><P>0.212139503</P><P>0.813363764</P><P>2.074538017</P><P>-0.379978441</P><P>0.582723039</P><P>1.007738264</P><P>-1.343523263</P><P>-1.281435722</P><P>-1.709919199</P><P>-2.221110283</P><P>-0.357830805</P><P>-0.957889455</P><P>-0.828228651</P><P>-2.21342328</P><P>-1.741858015</P><P>-0.4136128</P><P>1.152547859</P><P>0.767231874</P><P>;</P><P>run;</P><P>proc arima data=work.have plot=residual(smooth);</P><P>&nbsp;&nbsp;&nbsp;&nbsp; identify var=AR nlag=1 noprint;</P><P>&nbsp;&nbsp;&nbsp;&nbsp; estimate p=1;</P><P>&nbsp;&nbsp;&nbsp;&nbsp; forecast id=I interval=1 align=BEGINNING lead=0 alpha=0.05&nbsp; out=want;</P><P>quit;</P><P></P><P>Once you created WANT you can export it to EXCEL in many different ways - the easiest might be to right click the data set in the explorer window:</P><P><IMG alt="Export.JPG" class="jive-image" src="https://communities.sas.com/legacyfs/online/2800_Export.JPG" /></P><P>Thanks,</P><P>Udo</P></BODY></HTML> Tue, 04 Dec 2012 16:56:45 GMT https://communities.sas.com/t5/SAS-Forecasting-and-Econometrics/writing-residuals-to-an-excel-file/m-p/89162#M459 udo_sas 2012-12-04T16:56:45Z Re: writing residuals to an excel file https://communities.sas.com/t5/SAS-Forecasting-and-Econometrics/writing-residuals-to-an-excel-file/m-p/89163#M460 <HTML><HEAD></HEAD><BODY><P>You could also use PROC GPLOT and skip Excel</P></BODY></HTML> Tue, 04 Dec 2012 17:02:03 GMT https://communities.sas.com/t5/SAS-Forecasting-and-Econometrics/writing-residuals-to-an-excel-file/m-p/89163#M460 PaigeMiller 2012-12-04T17:02:03Z Re: writing residuals to an excel file https://communities.sas.com/t5/SAS-Forecasting-and-Econometrics/writing-residuals-to-an-excel-file/m-p/89164#M461 <HTML><HEAD></HEAD><BODY><P>Very true - in fact ARIMA does create the plot you are looking for out-of-the-box:</P><P>proc arima data=work.have <STRONG>plot=residual(smooth)</STRONG>;</P></BODY></HTML> Tue, 04 Dec 2012 18:05:31 GMT https://communities.sas.com/t5/SAS-Forecasting-and-Econometrics/writing-residuals-to-an-excel-file/m-p/89164#M461 udo_sas 2012-12-04T18:05:31Z