company_name year NIC Y X1 X2 A D F Foods Ltd. 2011 10 0.18 0.88 0.08 Adani Wilmar Ltd. 2011 10 0.29 4.08 1.16 Agro Tech Foods Ltd. 2011 10 0.44 2.50 0.24 Ajanta Soya Ltd. 2011 10 0.17 6.23 1.44 Ambar Protein Inds. Ltd. 2011 10 0.17 7.12 1.53 Andrew Yule & Co. Ltd. 2011 10 0.14 0.54 0.12 Arcuttipore Tea Co. Ltd. 2011 10 0.05 0.22 0.00 Avanti Feeds Ltd. 2011 10 0.15 1.76 0.95 Associated Alcohols & Breweries Ltd. 2011 11 0.13 0.95 0.11 Devyani International Ltd. 2011 11 0.37 1.44 -0.04 Eco Friendly Food Processing Park Ltd. 2011 11 0.01 0.11 0.02 Elegant Floriculture & Agrotech (India) Ltd. 2011 11 0.02 0.04 0.00 Flex Foods Ltd. 2011 11 0.15 0.61 0.11 G M Breweries Ltd. 2011 11 3.89 2.01 0.10 G R M Overseas Ltd. 2011 11 0.13 1.61 -1.00 Naturite Agro Products Ltd. 2011 11 0.19 1.26 1.13 Orient Beverages Ltd. 2011 11 0.14 0.39 0.12 S I P Industries Ltd. 2011 11 0.11 0.21 -0.05 Sinnar Bidi Udyog Ltd. 2011 11 0.07 0.92 0.13 Tarai Foods Ltd. 2011 11 0.10 0.22 -0.22 A D F Foods Ltd. 2012 10 0.17 0.71 0.01 Adani Wilmar Ltd. 2012 10 0.19 3.70 1.08 Agro Tech Foods Ltd. 2012 10 0.40 2.47 -0.05 Ajanta Soya Ltd. 2012 10 0.17 6.87 1.26 Andrew Yule & Co. Ltd. 2012 10 0.16 0.62 0.08 Arcuttipore Tea Co. Ltd. 2012 10 0.07 0.20 -0.03 Avanti Feeds Ltd. 2012 10 0.23 2.72 1.28 Associated Alcohols & Breweries Ltd. 2012 11 0.13 1.24 0.43 Devyani International Ltd. 2012 11 0.42 1.50 0.36 Eco Friendly Food Processing Park Ltd. 2012 11 0.01 0.43 0.34 Elegant Floriculture & Agrotech (India) Ltd. 2012 11 0.01 0.03 0.00 Flex Foods Ltd. 2012 11 0.20 0.67 0.06 G M Breweries Ltd. 2012 11 4.26 1.69 0.13 Naturite Agro Products Ltd. 2012 11 0.09 0.88 0.14 S D F Industries Ltd. 2012 11 0.32 0.69 -0.07 S I P Industries Ltd. 2012 11 0.17 0.14 -0.21 Saptarishi Agro Inds. Ltd. 2012 11 0.03 0.00 -0.41 Sinnar Bidi Udyog Ltd. 2012 11 0.08 0.35 -0.55 Tarai Foods Ltd. 2012 11 0.10 0.22 -0.05 i have updated the my data illustration to get more clarity on my query in the above table, in the year 2011, the companies under "NIC 10" are only 8 . so, i would like to exclude in running the regression. in the same year, companies "under NIC 11" are 12,, so i would like to include these companies in running the regression and so on . i have to run the regression for every year and for each NIC code separately(yearwise-NIC code wise) i am using this code presently, as requesting to suggest the change to this code to achieve my above discussed objective in running the regression PROC REG DATA=have; MODEL Y=X1 X2 X3; by YEAR NIC; output out=estimated p=predicted r=residual; run;
... View more
