topic Re: How to save actual, predicted and residual values? in New SAS User https://communities.sas.com/t5/New-SAS-User/How-to-save-actual-predicted-and-residual-values/m-p/593516#M15530 <P>Use the OUTPUT statement of PROC REG.</P> <P>&nbsp;</P> <P>Example here:&nbsp;<A href="https://documentation.sas.com/?cdcId=pgmsascdc&amp;cdcVersion=9.4_3.4&amp;docsetId=statug&amp;docsetTarget=statug_reg_syntax10.htm&amp;locale=en">https://documentation.sas.com/?cdcId=pgmsascdc&amp;cdcVersion=9.4_3.4&amp;docsetId=statug&amp;docsetTarget=statug_reg_syntax10.htm&amp;locale=en</A></P> Wed, 02 Oct 2019 19:25:48 GMT PaigeMiller 2019-10-02T19:25:48Z How to save actual, predicted and residual values? https://communities.sas.com/t5/New-SAS-User/How-to-save-actual-predicted-and-residual-values/m-p/593512#M15529 <P>dear all</P><P>i run&nbsp; regression separatey for each industry and each year in the panel data.&nbsp;</P><P>I have to save the values of actual, predicated and residuals.&nbsp;</P><P>&nbsp;</P><P>the input file for the regression is as follows&nbsp;</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>COMPANY_NAME</TD><TD>YEAR</TD><TD>NIC_CODE</TD><TD>DV</TD><TD>IV_1</TD><TD>IV_2</TD><TD>IV_3</TD></TR><TR><TD>A D F Foods Ltd.</TD><TD>2011</TD><TD>10</TD><TD>0.178526</TD><TD>0.000796</TD><TD>0.881805</TD><TD>0.080548</TD></TR><TR><TD>Agro Tech Foods Ltd.</TD><TD>2011</TD><TD>10</TD><TD>-0.14811</TD><TD>0.000349</TD><TD>2.496768</TD><TD>0.238252</TD></TR><TR><TD>Ajanta Soya Ltd.</TD><TD>2011</TD><TD>10</TD><TD>-0.16364</TD><TD>0.002064</TD><TD>6.225753</TD><TD>1.438506</TD></TR><TR><TD>Andrew Yule &amp; Co. Ltd.</TD><TD>2011</TD><TD>10</TD><TD>0.098988</TD><TD>0.000218</TD><TD>0.548305</TD><TD>0.125093</TD></TR><TR><TD>Arcuttipore Tea Co. Ltd.</TD><TD>2011</TD><TD>10</TD><TD>0.009009</TD><TD>0.007508</TD><TD>0.21997</TD><TD>-0.0045</TD></TR><TR><TD>Assam Company India Ltd.</TD><TD>2011</TD><TD>10</TD><TD>0.021117</TD><TD>9.55E-05</TD><TD>0.211948</TD><TD>-0.00285</TD></TR><TR><TD>Avanti Feeds Ltd.</TD><TD>2011</TD><TD>10</TD><TD>-0.06735</TD><TD>0.000849</TD><TD>1.762528</TD><TD>0.947087</TD></TR><TR><TD>B &amp; A Ltd.</TD><TD>2011</TD><TD>10</TD><TD>0.168481</TD><TD>0.001111</TD><TD>0.835851</TD><TD>0.079853</TD></TR><TR><TD>B C L Industries Ltd.</TD><TD>2011</TD><TD>10</TD><TD>-0.05169</TD><TD>0.000718</TD><TD>3.327997</TD><TD>1.185284</TD></TR><TR><TD>Bajaj Hindusthan Sugar Ltd.</TD><TD>2011</TD><TD>10</TD><TD>0.142209</TD><TD>9E-06</TD><TD>0.443527</TD><TD>0.184995</TD></TR><TR><TD>A D F Foods Ltd.</TD><TD>2012</TD><TD>10</TD><TD>0.04994</TD><TD>0.000631</TD><TD>0.708315</TD><TD>0.008839</TD></TR><TR><TD>Agro Tech Foods Ltd.</TD><TD>2012</TD><TD>10</TD><TD>0.097351</TD><TD>0.000354</TD><TD>2.474027</TD><TD>-0.05294</TD></TR><TR><TD>Ajanta Soya Ltd.</TD><TD>2012</TD><TD>10</TD><TD>0.070818</TD><TD>0.001859</TD><TD>6.869703</TD><TD>1.261896</TD></TR><TR><TD>Andrew Yule &amp; Co. Ltd.</TD><TD>2012</TD><TD>10</TD><TD>0.067042</TD><TD>0.000214</TD><TD>0.622507</TD><TD>0.083985</TD></TR><TR><TD>Arcuttipore Tea Co. Ltd.</TD><TD>2012</TD><TD>10</TD><TD>-0.01475</TD><TD>0.007764</TD><TD>0.196429</TD><TD>-0.03106</TD></TR><TR><TD>Assam Company India Ltd.</TD><TD>2012</TD><TD>10</TD><TD>0.038277</TD><TD>8.29E-05</TD><TD>0.232606</TD><TD>0.048619</TD></TR><TR><TD>Avanti Feeds Ltd.</TD><TD>2012</TD><TD>10</TD><TD>0.3481</TD><TD>0.000691</TD><TD>2.716517</TD><TD>1.282377</TD></TR><TR><TD>B &amp; A Ltd.</TD><TD>2012</TD><TD>10</TD><TD>0.135132</TD><TD>0.001022</TD><TD>0.839415</TD><TD>0.070122</TD></TR><TR><TD>B C L Industries Ltd.</TD><TD>2012</TD><TD>10</TD><TD>-0.04546</TD><TD>0.000559</TD><TD>2.902709</TD><TD>0.313544</TD></TR><TR><TD>Bajaj Hindusthan Sugar Ltd.</TD><TD>2012</TD><TD>10</TD><TD>-0.0457</TD><TD>9.77E-06</TD><TD>0.416821</TD><TD>-0.06456</TD></TR><TR><TD>Associated Alcohols &amp; Breweries Ltd.</TD><TD>2011</TD><TD>11</TD><TD>-0.02965</TD><TD>0.001052</TD><TD>0.954048</TD><TD>0.105889</TD></TR><TR><TD>Belapur Industries Ltd.</TD><TD>2011</TD><TD>11</TD><TD>0.008021</TD><TD>0.013369</TD><TD>0.15508</TD><TD>0.001337</TD></TR><TR><TD>Bio Green Papers Ltd.</TD><TD>2011</TD><TD>11</TD><TD>0.097404</TD><TD>0.002219</TD><TD>0.193033</TD><TD>-0.04038</TD></TR><TR><TD>Chaman Lal Setia Exports Ltd.</TD><TD>2011</TD><TD>11</TD><TD>0.070517</TD><TD>0.001181</TD><TD>1.984408</TD><TD>-0.20872</TD></TR><TR><TD>Elegant Floriculture &amp; Agrotech (India) Ltd.</TD><TD>2011</TD><TD>11</TD><TD>-0.27549</TD><TD>0.006068</TD><TD>0.040049</TD><TD>0.004854</TD></TR><TR><TD>Empee Distilleries Ltd.</TD><TD>2011</TD><TD>11</TD><TD>0.11797</TD><TD>0.000246</TD><TD>0.690689</TD><TD>0.029437</TD></TR><TR><TD>Flex Foods Ltd.</TD><TD>2011</TD><TD>11</TD><TD>0.127556</TD><TD>0.001319</TD><TD>0.605065</TD><TD>0.111727</TD></TR><TR><TD>G M Breweries Ltd.</TD><TD>2011</TD><TD>11</TD><TD>0.290524</TD><TD>0.000868</TD><TD>2.006855</TD><TD>0.103523</TD></TR><TR><TD>Associated Alcohols &amp; Breweries Ltd.</TD><TD>2012</TD><TD>11</TD><TD>0.204466</TD><TD>0.000893</TD><TD>1.236177</TD><TD>0.425726</TD></TR><TR><TD>Belapur Industries Ltd.</TD><TD>2012</TD><TD>11</TD><TD>-0.01664</TD><TD>0.01387</TD><TD>0.178918</TD><TD>0.018031</TD></TR><TR><TD>Chaman Lal Setia Exports Ltd.</TD><TD>2012</TD><TD>11</TD><TD>-0.01903</TD><TD>0.001012</TD><TD>2.201599</TD><TD>0.501366</TD></TR><TR><TD>Elegant Floriculture &amp; Agrotech (India) Ltd.</TD><TD>2012</TD><TD>11</TD><TD>-0.01341</TD><TD>0.004789</TD><TD>0.03113</TD><TD>-0.00048</TD></TR><TR><TD>Empee Distilleries Ltd.</TD><TD>2012</TD><TD>11</TD><TD>0.188802</TD><TD>0.000201</TD><TD>0.935492</TD><TD>0.371738</TD></TR><TR><TD>Flex Foods Ltd.</TD><TD>2012</TD><TD>11</TD><TD>0.103462</TD><TD>0.001342</TD><TD>0.674852</TD><TD>0.059313</TD></TR><TR><TD>G M Breweries Ltd.</TD><TD>2012</TD><TD>11</TD><TD>0.127283</TD><TD>0.000674</TD><TD>1.687218</TD><TD>0.1289</TD></TR><TR><TD>G R Cables Ltd.</TD><TD>2012</TD><TD>11</TD><TD>-0.00445</TD><TD>0.007413</TD><TD>0.006672</TD><TD>0.002965</TD></TR><TR><TD>Gangotri Textiles Ltd.</TD><TD>2012</TD><TD>11</TD><TD>0.028039</TD><TD>0.000203</TD><TD>0.324616</TD><TD>-0.09635</TD></TR><TR><TD>Gujarat Ambuja Exports Ltd.</TD><TD>2012</TD><TD>11</TD><TD>-0.00414</TD><TD>0.0001</TD><TD>2.123077</TD><TD>0.172181</TD></TR><TR><TD>Himalaya Food Intl. Ltd.</TD><TD>2012</TD><TD>11</TD><TD>0.106164</TD><TD>0.00039</TD><TD>0.421771</TD><TD>0.100706</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>i run the following regression code in SAS</P><P>&nbsp;proc reg data=have;&nbsp;</P><P>model&nbsp; DV=IV_1 IV_2 IV_3;</P><P>by NIC_Code&nbsp; year;</P><P>run;</P><P>&nbsp;</P><P>i want to save the required variables from the output in the following format</P><TABLE><TBODY><TR><TD>COMPANY_NAME</TD><TD>YEAR</TD><TD>NIC_CODE</TD><TD>Actual&nbsp;</TD><TD>Predicted</TD><TD>Residual</TD></TR><TR><TD>A D F Foods Ltd.</TD><TD>2011</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Agro Tech Foods Ltd.</TD><TD>2011</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Ajanta Soya Ltd.</TD><TD>2011</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Andrew Yule &amp; Co. Ltd.</TD><TD>2011</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Arcuttipore Tea Co. Ltd.</TD><TD>2011</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Assam Company India Ltd.</TD><TD>2011</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Avanti Feeds Ltd.</TD><TD>2011</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>B &amp; A Ltd.</TD><TD>2011</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>B C L Industries Ltd.</TD><TD>2011</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Bajaj Hindusthan Sugar Ltd.</TD><TD>2011</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>A D F Foods Ltd.</TD><TD>2012</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Agro Tech Foods Ltd.</TD><TD>2012</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Ajanta Soya Ltd.</TD><TD>2012</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Andrew Yule &amp; Co. Ltd.</TD><TD>2012</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Arcuttipore Tea Co. Ltd.</TD><TD>2012</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Assam Company India Ltd.</TD><TD>2012</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Avanti Feeds Ltd.</TD><TD>2012</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>B &amp; A Ltd.</TD><TD>2012</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>B C L Industries Ltd.</TD><TD>2012</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Bajaj Hindusthan Sugar Ltd.</TD><TD>2012</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Associated Alcohols &amp; Breweries Ltd.</TD><TD>2011</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Belapur Industries Ltd.</TD><TD>2011</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Bio Green Papers Ltd.</TD><TD>2011</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Chaman Lal Setia Exports Ltd.</TD><TD>2011</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Elegant Floriculture &amp; Agrotech (India) Ltd.</TD><TD>2011</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Empee Distilleries Ltd.</TD><TD>2011</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Flex Foods Ltd.</TD><TD>2011</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>G M Breweries Ltd.</TD><TD>2011</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Associated Alcohols &amp; Breweries Ltd.</TD><TD>2012</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Belapur Industries Ltd.</TD><TD>2012</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Chaman Lal Setia Exports Ltd.</TD><TD>2012</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Elegant Floriculture &amp; Agrotech (India) Ltd.</TD><TD>2012</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Empee Distilleries Ltd.</TD><TD>2012</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Flex Foods Ltd.</TD><TD>2012</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>G M Breweries Ltd.</TD><TD>2012</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>G R Cables Ltd.</TD><TD>2012</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Gangotri Textiles Ltd.</TD><TD>2012</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Gujarat Ambuja Exports Ltd.</TD><TD>2012</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Himalaya Food Intl. Ltd.</TD><TD>2012</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>please help in writing the SAS code which can generate a separate file the the required variables in the above mentioned format.&nbsp;</P><P>thanks in advance&nbsp;</P><P>&nbsp;</P> Wed, 02 Oct 2019 19:11:45 GMT https://communities.sas.com/t5/New-SAS-User/How-to-save-actual-predicted-and-residual-values/m-p/593512#M15529 srikanthyadav44 2019-10-02T19:11:45Z Re: How to save actual, predicted and residual values? https://communities.sas.com/t5/New-SAS-User/How-to-save-actual-predicted-and-residual-values/m-p/593516#M15530 <P>Use the OUTPUT statement of PROC REG.</P> <P>&nbsp;</P> <P>Example here:&nbsp;<A href="https://documentation.sas.com/?cdcId=pgmsascdc&amp;cdcVersion=9.4_3.4&amp;docsetId=statug&amp;docsetTarget=statug_reg_syntax10.htm&amp;locale=en">https://documentation.sas.com/?cdcId=pgmsascdc&amp;cdcVersion=9.4_3.4&amp;docsetId=statug&amp;docsetTarget=statug_reg_syntax10.htm&amp;locale=en</A></P> Wed, 02 Oct 2019 19:25:48 GMT https://communities.sas.com/t5/New-SAS-User/How-to-save-actual-predicted-and-residual-values/m-p/593516#M15530 PaigeMiller 2019-10-02T19:25:48Z