My dependent variable is expenditure share for wine on trade. When i run the regression, however

"tobit expshare_wine_on log_price_wine_on log_price_beer_on log_price_wine_off log_price_beer_off log_price_spirits_on log_price_spirits_off logincome i.socio_group i.gor_recode i.year i. sexhrp , ll(0)"


it then says the years have been omitted due to collinearity and then gives iteration terms for ages and i have quit the stata at the point where its on interaction term 11,000. Please can someone explain why this is happening

2) how would i then compute the price elasticises from the regression, I believe i have to use the -margins- command in some way but i'm not sure how to do this. Thank you



dataex expshare_wine_on log_price_wine_on log_price_beer_on log_price_wine_off log_price_beer_off log_price_spirits_on log_price_spirits_off logincome socio_group gor_recode year sexhrp

Code:
 * Example generated by -dataex-. To install: ssc install dataex clear input float(expshare_wine_on log_price_wine_on log_price_beer_on log_price_wine_off log_price_beer_off log_price_spirits_on log_price_spirits_off logincome) byte(socio_group gor_recode) int year byte sexhrp           0 .8621745 .21611896 -.6803692 -.7620472  .9290687 -.7203745  6.422159 1 3 2012 1           0 .8621745 .21611896 -.6803692 -.7620472  .9290687 -.7203745   6.40044 6 3 2012 1  .005604915 .8530697  .2070142 -.6894739  -.771152   .919964 -.7294793  7.459103 1 2 2012 2           0 .8621745 .21611896 -.6803692 -.7620472  .9290687 -.7203745  6.775366 1 3 2012 1           0 .8621745 .21611896 -.6803692 -.7620472  .9290687 -.7203745  7.113805 6 3 2012 2           0 .8530697  .2070142 -.6894739  -.771152   .919964 -.7294793  6.569739 6 2 2012 1           0 .8885115 .24245583 -.6540322 -.7357103  .9554057 -.6940376  5.533982 6 4 2012 1           0 .8885115 .24245583 -.6540322 -.7357103  .9554057 -.6940376  7.579028 1 4 2012 1           0 .8621745 .21611896 -.6803692 -.7620472  .9290687 -.7203745  6.593606 3 3 2012 2           0 .8530697  .2070142 -.6894739  -.771152   .919964 -.7294793  5.272487 4 2 2012 1           0 .8621745 .21611896 -.6803692 -.7620472  .9290687 -.7203745  6.609026 1 3 2012 1           0 .8530697  .2070142 -.6894739  -.771152   .919964 -.7294793  5.938198 3 2 2012 2           0 .8621745 .21611896 -.6803692 -.7620472  .9290687 -.7203745  7.337308 2 3 2012 1           0 .8885115 .24245583 -.6540322 -.7357103  .9554057 -.6940376  7.146323 2 4 2012 1  .006608747 .8885115 .24245583 -.6540322 -.7357103  .9554057 -.6940376  5.750647 1 4 2012 1           0 .8500163 .20396078 -.6927273 -.7742054  .9169105 -.7325327  7.203275 1 5 2012 1           0 .8885115 .24245583 -.6540322 -.7357103  .9554057 -.6940376  6.494836 3 4 2012 2  .013427625 .8530697  .2070142 -.6894739  -.771152   .919964 -.7294793  6.484792 1 2 2012 1           0 .8731912 .22713557 -.6693525 -.7510306  .9400854 -.7093579  6.522772 6 6 2012 2           0 .8885115 .24245583 -.6540322 -.7357103  .9554057 -.6940376  6.285625 1 4 2012 1           0 .8530697  .2070142 -.6894739  -.771152   .919964 -.7294793  5.278839 6 2 2012 2           0 .8731912 .22713557 -.6693525 -.7510306  .9400854 -.7093579  5.735572 6 6 2012 1           0 .8621745 .21611896 -.6803692 -.7620472  .9290687 -.7203745  6.332039 6 3 2012 1           0 .8621745 .21611896 -.6803692 -.7620472  .9290687 -.7203745  6.243429 1 3 2012 2   .04080451 .8621745 .21611896 -.6803692 -.7620472  .9290687 -.7203745  7.020963 6 3 2012 1           0 .8885115 .24245583 -.6540322 -.7357103  .9554057 -.6940376  6.001791 1 4 2012 1           0 .8530697  .2070142 -.6894739  -.771152   .919964 -.7294793  4.970105 6 2 2012 2   .05318476 .8621745 .21611896 -.6803692 -.7620472  .9290687 -.7203745   6.24026 6 3 2012 2  .004725324 .8885115 .24245583 -.6540322 -.7357103  .9554057 -.6940376  6.525675 1 4 2012 2           0 .8621745 .21611896 -.6803692 -.7620472  .9290687 -.7203745  5.715316 1 3 2012 2           0 .8530697  .2070142 -.6894739  -.771152   .919964 -.7294793  6.292069 6 2 2012 1 .0021395173 .8621745 .21611896 -.6803692 -.7620472  .9290687 -.7203745  7.579028 2 3 2012 1           0 .8731912 .22713557 -.6693525 -.7510306  .9400854 -.7093579  5.805894 1 6 2012 1           0 .8731912 .22713557 -.6693525 -.7510306  .9400854 -.7093579  6.336164 6 6 2012 2  .005811018 .8530697  .2070142 -.6894739  -.771152   .919964 -.7294793   6.59858 6 2 2012 1   .01420468 .8621745 .21611896 -.6803692 -.7620472  .9290687 -.7203745  7.579028 2 3 2012 1           0 .8530697  .2070142 -.6894739  -.771152   .919964 -.7294793  5.272558 6 2 2012 1           0 .8885115 .24245583 -.6540322 -.7357103  .9554057 -.6940376  5.287823 6 4 2012 2           0 .8885115 .24245583 -.6540322 -.7357103  .9554057 -.6940376  6.228738 1 4 2012 1           0 .8621745 .21611896 -.6803692 -.7620472  .9290687 -.7203745  6.229595 3 3 2012 1           0 .8885115 .24245583 -.6540322 -.7357103  .9554057 -.6940376  6.007731 6 4 2012 2           0 .8731912 .22713557 -.6693525 -.7510306  .9400854 -.7093579  5.877369 6 6 2012 1 .0041208593 .8621745 .21611896 -.6803692 -.7620472  .9290687 -.7203745   6.54662 2 3 2012 2    .0124029 .8621745 .21611896 -.6803692 -.7620472  .9290687 -.7203745  5.966916 1 3 2012 2           0 .8621745 .21611896 -.6803692 -.7620472  .9290687 -.7203745  6.911763 3 3 2012 1           0 .8621745 .21611896 -.6803692 -.7620472  .9290687 -.7203745  6.145001 3 3 2012 1           0 .8621745 .21611896 -.6803692 -.7620472  .9290687 -.7203745  7.579028 1 3 2012 1  .006529902 .8885115 .24245583 -.6540322 -.7357103  .9554057 -.6940376  6.862258 1 4 2012 1           0 .8621745 .21611896 -.6803692 -.7620472  .9290687 -.7203745  5.800377 6 3 2012 2           0 .8885115 .24245583 -.6540322 -.7357103  .9554057 -.6940376  6.824134 1 4 2012 1           0 .8449064  .1988509 -.6976373 -.7793153  .9118007 -.7376425  6.789703 4 7 2012 2           0 .8621745 .21611896 -.6803692 -.7620472  .9290687 -.7203745  6.928361 2 3 2012 2           0 .8885115 .24245583 -.6540322 -.7357103  .9554057 -.6940376  6.399566 6 4 2012 1           0 .8530697  .2070142 -.6894739  -.771152   .919964 -.7294793  6.500343 3 2 2012 1           0 .8530697  .2070142 -.6894739  -.771152   .919964 -.7294793 4.4601445 1 2 2012 2           0 .8621745 .21611896 -.6803692 -.7620472  .9290687 -.7203745  6.617764 3 3 2012 1           0 .8530697  .2070142 -.6894739  -.771152   .919964 -.7294793  5.679811 6 2 2012 1           0 .8885115 .24245583 -.6540322 -.7357103  .9554057 -.6940376  6.867948 6 4 2012 1   .05028144 .8731912 .22713557 -.6693525 -.7510306  .9400854 -.7093579  6.313678 3 6 2012 2           0 .8449064  .1988509 -.6976373 -.7793153  .9118007 -.7376425  6.596409 1 7 2012 2  .017830186 .8885115 .24245583 -.6540322 -.7357103  .9554057 -.6940376  6.492455 1 4 2012 1           0 .8731912 .22713557 -.6693525 -.7510306  .9400854 -.7093579  6.114235 3 6 2012 1           0 .8530697  .2070142 -.6894739  -.771152   .919964 -.7294793  6.092607 6 2 2012 1           0 .9387252 .29266962 -.6038184 -.6854964 1.0056194 -.6438238  6.205401 3 1 2012 1           0 .8530697  .2070142 -.6894739  -.771152   .919964 -.7294793  6.580847 3 2 2012 1           0 .9387252 .29266962 -.6038184 -.6854964 1.0056194 -.6438238  4.314417 1 1 2012 1  .016797012 .8500163 .20396078 -.6927273 -.7742054  .9169105 -.7325327  6.386812 1 5 2012 1           0 .8621745 .21611896 -.6803692 -.7620472  .9290687 -.7203745  5.972129 3 3 2012 1           0 .8621745 .21611896 -.6803692 -.7620472  .9290687 -.7203745  6.175955 6 3 2012 2           0 .8621745 .21611896 -.6803692 -.7620472  .9290687 -.7203745  5.530817 6 3 2012 2           0 .8885115 .24245583 -.6540322 -.7357103  .9554057 -.6940376   6.25011 1 4 2012 2           0 .8621745 .21611896 -.6803692 -.7620472  .9290687 -.7203745  5.958502 6 3 2012 1   .02511486 .8885115 .24245583 -.6540322 -.7357103  .9554057 -.6940376  7.579028 1 4 2012 1           0 .8530697  .2070142 -.6894739  -.771152   .919964 -.7294793  6.898997 1 2 2012 2           0 .8530697  .2070142 -.6894739  -.771152   .919964 -.7294793  5.885359 6 2 2012 2           0 .8500163 .20396078 -.6927273 -.7742054  .9169105 -.7325327  6.709394 6 5 2012 1           0 .8621745 .21611896 -.6803692 -.7620472  .9290687 -.7203745  5.036965 6 3 2012 2           0 .8885115 .24245583 -.6540322 -.7357103  .9554057 -.6940376  6.327079 1 4 2012 2           0 .8621745 .21611896 -.6803692 -.7620472  .9290687 -.7203745  4.998036 6 3 2012 1           0 .9387252 .29266962 -.6038184 -.6854964 1.0056194 -.6438238  6.697083 3 1 2012 1           0 .8621745 .21611896 -.6803692 -.7620472  .9290687 -.7203745  5.011914 6 3 2012 2           0 .8621745 .21611896 -.6803692 -.7620472  .9290687 -.7203745  6.158079 1 3 2012 2           0 .8885115 .24245583 -.6540322 -.7357103  .9554057 -.6940376  7.176102 1 4 2012 1           0 .8621745 .21611896 -.6803692 -.7620472  .9290687 -.7203745  5.896472 6 3 2012 2           0 .8621745 .21611896 -.6803692 -.7620472  .9290687 -.7203745  6.951744 2 3 2012 1           0 .8530697  .2070142 -.6894739  -.771152   .919964 -.7294793  5.197281 3 2 2012 1           0 .8621745 .21611896 -.6803692 -.7620472  .9290687 -.7203745  7.545757 2 3 2012 1           0 .9387252 .29266962 -.6038184 -.6854964 1.0056194 -.6438238  5.673536 6 1 2012 2   .01174157 .9387252 .29266962 -.6038184 -.6854964 1.0056194 -.6438238  6.977282 1 1 2012 2           0 .9387252 .29266962 -.6038184 -.6854964 1.0056194 -.6438238  6.517243 6 1 2012 1  .007315162 .8530697  .2070142 -.6894739  -.771152   .919964 -.7294793  6.570533 1 2 2012 1           0 .8530697  .2070142 -.6894739  -.771152   .919964 -.7294793  6.649363 6 2 2012 2           0 .8530697  .2070142 -.6894739  -.771152   .919964 -.7294793  6.787118 1 2 2012 2           0 .8885115 .24245583 -.6540322 -.7357103  .9554057 -.6940376  7.313854 6 4 2012 1           0 .8621745 .21611896 -.6803692 -.7620472  .9290687 -.7203745  6.104423 6 3 2012 2           0 .8885115 .24245583 -.6540322 -.7357103  .9554057 -.6940376   5.72316 6 4 2012 2           0 .8621745 .21611896 -.6803692 -.7620472  .9290687 -.7203745  5.897319 3 3 2012 2           0 .8621745 .21611896 -.6803692 -.7620472  .9290687 -.7203745  5.243925 6 3 2012 2 .0021459134 .8885115 .24245583 -.6540322 -.7357103  .9554057 -.6940376  7.579028 2 4 2012 1           0 .8530697  .2070142 -.6894739  -.771152   .919964 -.7294793  6.524854 1 2 2012 1 end label values sexhrp SexHRP label def SexHRP 1 "Male", modify label def SexHRP 2 "Female", modify
the log_* variables are related to gor_recode (regions) and year (my dataset includes 6 years and 7 different regions and to create them i used the following code:
Code:
    
 replace p_wine_on = 1.9564 if gor_recode==1 & year==2007 replace p_wine_on = 1.7958 if gor_recode==2 & year==2007 replace p_wine_on = 1.812225 if gor_recode==3 & year==2007 replace p_wine_on = 1.8605875 if gor_recode==4 & year==2007 replace p_wine_on = 1.790325 if gor_recode==5 & year==2007 replace p_wine_on = 1.8323 if gor_recode==6 & year==2007 replace p_wine_on = 1.7812 if gor_recode==7 & year==2007  replace p_wine_on = 2.04752 if gor==1 & year==2008 replace p_wine_on = 1.87944 if gor==2 & year==2008 replace p_wine_on = 1.89663 if gor==3 & year==2008 replace p_wine_on = 1.947245if gor==4 & year==2008 replace p_wine_on = 1.87371 if gor==5 & year==2008 replace p_wine_on = 1.91764 if gor==6 & year==2008 replace p_wine_on = 1.86416 if gor==7 & year==2008  replace p_wine_on = 2.09576 if gor== 1 & year==2009 replace p_wine_on = 1.92372  if gor== 2 & year==2009 replace p_wine_on = 1.941315 if gor== 3 & year==2009 replace p_wine_on = 1.993123 if gor== 4 & year==2009 replace p_wine_on =  1.917855 if gor== 5 & year==2009 replace p_wine_on = 1.96282  if gor== 6 & year==2009 replace p_wine_on = 1.90808 if gor== 7 & year==2009   replace p_wine_on = 2.17616  if gor==1 & year==2010 replace p_wine_on = 1.99752  if gor==2 & year==2010 replace p_wine_on = 2.01579 if gor==3 & year==2010 replace p_wine_on = 2.069585 if gor==4 & year==2010 replace p_wine_on = 1.99143 if gor==5 & year==2010 replace p_wine_on = 2.03812 if gor==6 & year==2010 replace p_wine_on = 1.98128  if gor==7 & year==2010  replace p_wine_on = 2.40128 if gor==1 & year==2011 replace p_wine_on = 2.20416 if gor==2 & year==2011 replace p_wine_on = 2.22432 if gor==3 & year==2011 replace p_wine_on = 2.28368 if gor==4 & year==2011 replace p_wine_on = 2.19744 if gor==5 & year==2011 replace p_wine_on = 2.24896 if gor==6 & year==2011 replace p_wine_on = 2.18624 if gor==7 & year==2011  replace p_wine_on = 2.55672 if gor==1 & year==2012 replace p_wine_on =  2.34684 if gor==2 & year==2012 replace p_wine_on = 2.368305 if gor==3 & year==2012 replace p_wine_on = 2.4315075 if gor==4 & year==2012 replace p_wine_on = 2.339685 if gor==5 & year==2012 replace p_wine_on = 2.39454 if gor==6 & year==2012 replace p_wine_on = 2.32776 if gor==7 & year==2012   BEER ON replace p_beer_on =1.06128 if gor==1 & year==2007 replace p_beer_on = 0.97416 if gor==2 & year==2007 replace p_beer_on = 1.92642 if gor==3 & year==2007 replace p_beer_on = 1.97783 if gor==4 & year==2007 replace p_beer_on = 1.90314 if gor==5 & year==2007 replace p_beer_on = 1.94776 if gor==6 & year==2007 replace p_beer_on = 1.89344 if gor==7 & year==2007  replace p_beer_on =1.10416 if gor==1 & year==2008 replace p_beer_on =1.01352 if gor==2 & year==2008 replace p_beer_on =1.02279 if gor==3 & year==2008 replace p_beer_on =1.050085 if gor==4 & year==2008 replace p_beer_on =1.01043 if gor==5 & year==2008 replace p_beer_on =1.03412 if gor==6 & year==2008 replace p_beer_on =1.00528 if gor==7 & year==2008  replace p_beer_on =1.14704  if gor==1 & year==2009 replace p_beer_on =1.05288 if gor==2 & year==2009 replace p_beer_on =1.06251 if gor==3 & year==2009 replace p_beer_on =1.090865 if gor==4 & year==2009 replace p_beer_on =1.04967 if gor==5 & year==2009 replace p_beer_on =1.07428 if gor==6 & year==2009 replace p_beer_on =1.04432 if gor==7 & year==2009  replace p_beer_on =1.20064 if gor==1 & year==2010 replace p_beer_on =1.10208 if gor==2 & year==2010 replace p_beer_on =1.11216 if gor==3 & year==2010 replace p_beer_on =1.14184 if gor==4 & year==2010 replace p_beer_on =1.09872 if gor==5 & year==2010 replace p_beer_on =1.12448 if gor==6 & year==2010 replace p_beer_on =1.09312 if gor==7 & year==2010  replace p_beer_on =1.27568 if gor==1 & year==2011 replace p_beer_on =1.17096 gor==2 & year==2011 replace p_beer_on =1.18167 if gor==3 & year==2011 replace p_beer_on =1.213205 if gor==4 & year==2011 replace p_beer_on =1.16739 if gor==5 & year==2011 replace p_beer_on =1.19476 if gor==6 & year==2011 replace p_beer_on =1.16144 if gor==7 & year==2011  replace p_beer_on =1.34 if gor==1 & year==2012 replace p_beer_on =1.23 if gor==2 & year==2012 replace p_beer_on =1.24125 if gor==3 & year==2012 replace p_beer_on =1.274375 if gor==4 & year==2012 replace p_beer_on =1.22625 if gor==5 & year==2012 replace p_beer_on =1.255 if gor==6 & year==2012 replace p_beer_on =1.22 if gor==7 & year==2012  SPIRITS ON  replace p_spirits_on =2.07968 if gor==1 & year==2007 replace p_spirits_on =1.90896 if gor==2 & year==2007 replace p_spirits_on =1.92642 if gor==3 & year==2007 replace p_spirits_on =1.97783 if gor==4 & year==2007 replace p_spirits_on =1.90314 if gor==5 & year==2007 replace p_spirits_on =1.94776 if gor==6 & year==2007 replace p_spirits_on =1.89344 if gor==7 & year==2007  replace p_spirits_on =2.17616 if gor==1 & year==2008 replace p_spirits_on =1.99752 if gor==2 & year==2008 replace p_spirits_on =2.01579 if gor==3 & year==2008 replace p_spirits_on =2.069585 if gor==4 & year==2008 replace p_spirits_on =1.99143 if gor==5 & year==2008 replace p_spirits_on =2.03812 if gor==6 & year==2008 replace p_spirits_on =1.98128 if gor==7 & year==2008  replace p_spirits_on =2.29408 if gor==1 & year==2009 replace p_spirits_on =2.10576 if gor==2 & year==2009 replace p_spirits_on =2.12502 if gor==3 & year==2009 replace p_spirits_on =2.18173 if gor==4 & year==2009 replace p_spirits_on =2.09934 if gor==5 & year==2009 replace p_spirits_on =2.14856 if gor==6 & year==2009 replace p_spirits_on =2,08864 if gor==7 & year==2009   replace p_spirits_on =2.3048 if gor==1 & year==2010 replace p_spirits_on =2.1156 if gor==2 & year==2010 replace p_spirits_on =2.13495 if gor==3 & year==2010 replace p_spirits_on =2.191925 if gor==4 & year==2010 replace p_spirits_on =2.10915 if gor==5 & year==2010 replace p_spirits_on =2.1586 if gor==6 & year==2010 replace p_spirits_on =2.0984 if gor==7 & year==2010  replace p_spirits_on =2.50848 if gor==1 & year==2011 replace p_spirits_on =2.30256 if gor==2 & year==2011 replace p_spirits_on =2.32362 if gor==3 & year==2011 replace p_spirits_on =2.38563 if gor==4 & year==2011 replace p_spirits_on =2.29554 if gor==5 & year==2011 replace p_spirits_on =2.34936 if gor==6 & year==2011 replace p_spirits_on =2.28384 if gor==7 & year==2011  replace p_spirits_on =2.7336 if gor==1 & year==2012 replace p_spirits_on =2.5092 if gor==2 & year==2012 replace p_spirits_on =2.53215 if gor==3 & year==2012 replace p_spirits_on =2.599725 if gor==4 & year==2012 replace p_spirits_on =2.50155 if gor==5 & year==2012 replace p_spirits_on =2.5602 if gor==6 & year==2012 replace p_spirits_on =2.4888 if gor==7 & year==2012  CIDER ON  replace p_cider_on =0.90048 if gor==1 & year==2007 replace p_cider_on =0.82656 if gor==2 & year==2007 replace p_cider_on =0.83412 if gor==3 & year==2007 replace p_cider_on =0.85638 if gor==4 & year==2007 replace p_cider_on =0.82404 if gor==5 & year==2007 replace p_cider_on =0.84336 if gor==6 & year==2007 replace p_cider_on =0.81984 if gor==7 & year==2007  replace p_cider_on =0.97552 if gor==1 & year==2008 replace p_cider_on =0.89544 if gor==2 & year==2008 replace p_cider_on =0.90363 if gor==3 & year==2008 replace p_cider_on =0.927745 if gor==4 & year==2008 replace p_cider_on =0.89271 if gor==5 & year==2008 replace p_cider_on =0.91364 if gor==6 & year==2008 replace p_cider_on =0.88816 if gor==7 & year==2008  replace p_cider_on =1.03448 if gor==1 & year==2009 replace p_cider_on =0.94956 if gor==2 & year==2009 replace p_cider_on =0.958245 if gor==3 & year==2009 replace p_cider_on =0.9838175 if gor==4 & year==2009 replace p_cider_on =0.946665 if gor==5 & year==2009 replace p_cider_on =0.96886 if gor==6 & year==2009 replace p_cider_on =0.94184 if gor==7 & year==2009  replace p_cider_on =1.08808 if gor==1 & year==2010 replace p_cider_on =0.99876 if gor==2 & year==2010 replace p_cider_on =1.007895 if gor==3 & year==2010 replace p_cider_on =1.0347925 if gor==4 & year==2010 replace p_cider_on =0.995715 if gor==5 & year==2010 replace p_cider_on =1.01906 if gor==6 & year==2010 replace p_cider_on =0.99064 if gor==7 & year==2010  replace p_cider_on =1.17384 if gor==1 & year==2011 replace p_cider_on =1.07748 if gor==2 & year==2011 replace p_cider_on =1.087335 if gor==3 & year==2011 replace p_cider_on =1.1163525 if gor==4 & year==2011 replace p_cider_on =1.074195 if gor==5 & year==2011 replace p_cider_on =1.09938 if gor==6 & year==2011 replace p_cider_on =1.06872 if gor==7 & year==2011  replace p_cider_on =1.1524 if gor==1 & year==2012 replace p_cider_on =1.0578 if gor==2 & year==2012 replace p_cider_on =1.066475 if gor==3 & year==2012 replace p_cider_on =1.0959625 if gor==4 & year==2012 replace p_cider_on =1.054575 if gor==5 & year==2012 replace p_cider_on =1.0793 if gor==6 & year==2012 replace p_cider_on =1.0492 if gor==7 & year==2012   ALCOPOPS ON replace p_alcopops_on=1.9296 if gor==1 & year==2007 replace p_alcopops_on=1.7712 if gor==2 & year ==2007 replace p_alcopops_on=1.7874 if gor==3 & year ==2007 replace p_alcopops_on=1.8351 if gor==4 & year ==2007 replace p_alcopops_on=1.7658 if gor==5 & year ==2007 replace p_alcopops_on=1.8072 if gor==6 & year ==2007 replace p_alcopops_on=1.7568 if gor==7 & year ==2007  replace p_alcopops_on=2.1976 if gor==1 & year ==2008 replace p_alcopops_on=2.0172 if gor==2 & year ==2008 replace p_alcopops_on=2.03565 if gor==3 & year ==2008 replace p_alcopops_on=2.089975 if gor==4 & year ==2008 replace p_alcopops_on=2.01105 if gor==5 & year ==2008 replace p_alcopops_on=2.0582 if gor==6 & year ==2008 replace p_alcopops_on=2.0008 if gor==7 & year ==2008  replace p_alcopops_on=2.24048 if gor==1 & year ==2009 replace p_alcopops_on=2.05656 if gor==2 & year ==2009 replace p_alcopops_on=2.07537 if gor==3 & year ==2009 replace p_alcopops_on=2.130755 if gor==4 & year ==2009 replace p_alcopops_on=2.05029 if gor==5 & year ==2009 replace p_alcopops_on=2.09836 if gor==6 & year ==2009 replace p_alcopops_on=2.03984 if gor==7 & year ==2009  replace p_alcopops_on=2.27264 if gor==1 & year ==2010 replace p_alcopops_on=2.08608 if gor==2 & year ==2010 replace p_alcopops_on=2.10516 if gor==3 & year ==2010 replace p_alcopops_on=2.16134 if gor==4 & year ==2010 replace p_alcopops_on=2.07972 if gor==5 & year ==2010 replace p_alcopops_on=2.12848 if gor==6 & year ==2010 replace p_alcopops_on=2.06912 if gor==7 & year ==2010  replace p_alcopops_on=2.1976 if gor==1 & year ==2011 replace p_alcopops_on=2.0172 if gor==2 & year ==2011 replace p_alcopops_on=2.03565 if gor==3 & year ==2011 replace p_alcopops_on=2.089975 if gor==4 & year ==2011 replace p_alcopops_on=2.01105 if gor==5 & year ==2011 replace p_alcopops_on=2.0582 if gor==6 & year ==2011 replace p_alcopops_on=2.008 if gor==7 & year ==2011  replace p_alcopops_on=2.22976 if gor==1 & year ==2012 replace p_alcopops_on=2.04672 if gor==2 & year ==2012 replace p_alcopops_on=2.06544 if gor==3 & year ==2012 replace p_alcopops_on=2.12056 if gor==4 & year ==2012 replace p_alcopops_on=2.04048 if gor==5 & year ==2012 replace p_alcopops_on=2.08832 if gor==6 & year ==2012 replace p_alcopops_on=2.03008 if gor==7 & year ==2012  WINE OFF  replace p_wine_off =0.41808 if gor==1 & year==2007 replace p_wine_off =0.38376 if gor==2 & year==2007 replace p_wine_off =0.38727 if gor==3 & year==2007 replace p_wine_off =0.397605 if gor==4 & year==2007 replace p_wine_off =0.38259 if gor==5 & year==2007 replace p_wine_off =0.39156 if gor==6 & year==2007 replace p_wine_off =0.38064 if gor==7 & year==2007  replace p_wine_off=0.43416 if gor==1 & year==2008 replace p_wine_off=0.39852 if gor==2 & year ==2008 replace p_wine_off=0.402165 if gor==3 & year ==2008 replace p_wine_off=0.4128975 if gor==4 & year ==2008 replace p_wine_off=0.397305 if gor==5 & year ==2008 replace p_wine_off=0.40662 if gor==6 & year ==2008 replace p_wine_off=0.39528 if gor==7 & year ==2008  replace p_wine_off= 0.46096 if gor==1 & year ==2009 replace p_wine_off=0.42312 if gor==2 & year ==2009 replace p_wine_off=0.42699 if gor==3 & year ==2009 replace p_wine_off=0.438385 if gor==4 & year ==2009 replace p_wine_off=0.42183 if gor==5 & year ==2009 replace p_wine_off=0.43172 if gor==6 & year ==2009 replace p_wine_off=0.41968 if gor==7 & year ==2009  replace p_wine_off=0.48776 if gor==1 & year ==2010 replace p_wine_off=0.44772 if gor==2 & year ==2010 replace p_wine_off=0.451815 if gor==3 & year ==2010 replace p_wine_off=0.4638725 if gor==4 & year ==2010 replace p_wine_off=0.446355 if gor==5 & year ==2010 replace p_wine_off=0.45682 if gor==6 & year ==2010 replace p_wine_off=0.44408 if gor==7 & year ==2010  replace p_wine_off=0.51456 if gor==1 & year ==2011 replace p_wine_off=0.47232 if gor==2 & year ==2011 replace p_wine_off=0.47664 if gor==3 & year ==2011 replace p_wine_off=0.48936 if gor==4 & year ==2011 replace p_wine_off=0.47088 if gor==5 & year ==2011 replace p_wine_off=0.48192 if gor==6 & year ==2011 replace p_wine_off=0.46848 if gor==7 & year ==2011  replace p_wine_off=0.54672 if gor==1 & year ==2012 replace p_wine_off=0.50184 if gor==2 & year ==2012 replace p_wine_off=0.50643 if gor==3 & year ==2012 replace p_wine_off=0.519945 if gor==4 & year ==2012 replace p_wine_off=0.50021 if gor==5 & year ==2012 replace p_wine_off=0.51204 if gor==6 & year ==2012 replace p_wine_off=0.49776 if gor==7 & year ==2012  BEER OFF  replace p_beer_off=0.40736 if gor==1 & year==2007 replace p_beer_off=0.37392 if gor==2 year==2007 replace p_beer_off=0.37734 if gor==3 & year==2007 replace p_beer_off=0.38741 if gor==4 & year==2007 replace p_beer_off=0.37278 if gor==5 & year==2007 replace p_beer_off=0.38152 if gor==6 & year==2007 replace p_beer_off=0.37088 if gor==7 & year==2007  replace p_beer_off=0.41808 if gor==1 & year==2008 replace p_beer_off=0.38376 if gor==2 & year==2008 replace p_beer_off=0.38727 if gor==3 & year==2008 replace p_beer_off=0.397605 if gor==4 & year==2008 replace p_beer_off=0.38259 if gor==5 & year==2008 replace p_beer_off=0.39156 if gor==6 & year==2008 replace p_beer_off=0.38064 if gor==7 & year==2008  replace p_beer_off=0.43952 if gor==1 & year==2009 replace p_beer_off=0.40344 if gor==2 & year==2009 replace p_beer_off=0.40713 if gor==3 & year==2009 replace p_beer_off=0.417995 if gor==4 & year==2009 replace p_beer_off=0.40221 if gor==5 & year==2009 replace p_beer_off=0.41164 if gor==6 & year==2009 replace p_beer_off=0.40016 if gor==7 & year==2009  replace p_beer_off=0.45024 if gor==1 & year==2010 replace p_beer_off=0.41328 if gor==2 & year==2010 replace p_beer_off=0.41706 if gor==3 & year==2010 replace p_beer_off=0.42819 if gor==4 & year==2010 replace p_beer_off=0.41202 if gor==5 & year==2010 replace p_beer_off=0.42168 if gor==6 & year==2010 replace p_beer_off=0.40992 if gor==7 & year==2010  replace p_beer_off=0.49312 if gor==1 & year==2011 replace p_beer_off=0.45264 if gor==2 & year==2011 replace p_beer_off=0.45678 if gor==3 & year==2011 replace p_beer_off=0.46897 if gor==4 & year==2011 replace p_beer_off=0.45126 if gor==5 & year==2011 replace p_beer_off=0.46184 if gor==6 & year==2011 replace p_beer_off=0.44896 if gor==7 & year==2011  replace p_beer_off=0.50384 if gor==1 & year==2012 replace p_beer_off=0.46248 if gor==2 & year==2012 replace p_beer_off=0.46671 if gor==3 & year==2012 replace p_beer_off=0.479165 if gor==4 & year==2012 replace p_beer_off=0.46107 if gor==5 & year==2012 replace p_beer_off=0.47188 if gor==6 & year==2012 replace p_beer_off=0.45872 if gor==7 & year==2012
NOTE i have done the same for 3 other alcohol types: cider off trade, spirits off trade and alcopops off i originally was typing gor_recode but gor is recoded the same could there be a problem with my codes for prices? I then calculated log_price* by: log_price_wine_on = log(p_wine_on) etc for all alcohol types is there a problem with this? I am just unsure why the years are collinear Thanks