data one; input yr rep trt buac gn; cards; 2012 1 1 23.96 2.0128 2012 1 2 18.55 1.9463 2012 1 3 37.45 1.8887 2012 1 4 43.08 1.72 2012 1 5 54.32 1.9119 2012 1 6 57.85 1.9045 2012 1 7 63.22 1.987 2012 1 8 50.38 2.0194 2012 1 9 49.44 1.8979 2012 1 10 49.20 1.852 2012 1 11 62.95 1.9345 2012 1 12 62.23 2.0563 2012 1 13 61.34 1.9452 2012 1 14 52.85 1.7052 2012 2 1 22.94 1.8323 2012 2 2 28.51 1.8625 2012 2 3 31.36 1.8488 2012 2 4 49.26 1.885 2012 2 5 57.01 1.8559 2012 2 6 60.81 2.1259 2012 2 7 56.56 2.2103 2012 2 8 53.39 1.8556 2012 2 9 55.71 1.8847 2012 2 10 57.79 1.8675 2012 2 11 57.23 1.9048 2012 2 12 63.18 2.0945 2012 2 13 59.13 2.1772 2012 2 14 63.15 2.0302 2012 3 1 27.02 1.8434 2012 3 2 28.27 1.8938 2012 3 3 39.78 1.8627 2012 3 4 47.45 1.7441 2012 3 5 61.44 1.8938 2012 3 6 62.07 1.8328 2012 3 7 62.97 2.0258 2012 3 8 59.45 1.9137 2012 3 9 60.86 1.9667 2012 3 10 52.64 1.8381 2012 3 11 56.36 1.8913 2012 3 12 61.55 1.9022 2012 3 13 64.25 1.906 2012 3 14 53.68 1.8574 2012 4 1 29.34 1.9419 2012 4 2 32.97 1.9488 2012 4 3 32.03 1.7946 2012 4 4 53.80 1.8934 2012 4 5 48.77 1.5818 2012 4 6 61.87 1.8638 2012 4 7 62.15 2.3122 2012 4 8 47.33 1.8298 2012 4 9 53.83 1.7982 2012 4 10 60.89 1.8938 2012 4 11 57.85 1.9946 2012 4 12 58.45 1.887 2012 4 13 60.84 2.0606 2012 4 14 60.46 2.1655 2013 1 1 24.27767176 2.1734 2013 1 2 14.60939783 2.1232 2013 1 3 33.63716813 1.9361 2013 1 4 32.55657227 1.9407 2013 1 5 45.1865304 2.2762 2013 1 6 39.75419631 2.0856 2013 1 7 40.24525992 2.26 2013 1 8 29.24598295 2.4941 2013 1 9 42.26624706 2.1373 2013 1 10 37.75661848 1.9395 2013 1 11 47.66352582 2.0016 2013 1 12 49.06861435 2.2481 2013 1 13 53.78260635 2.1217 2013 1 14 34.27952525 2.0708 2013 2 1 19.4715378 2.0033 2013 2 2 25.95425428 2.028 2013 2 3 27.94378188 1.9935 2013 2 4 35.59195035 2.0938 2013 2 5 41.90404985 2.1218 2013 2 6 37.91080203 2.3868 2013 2 7 39.74833246 2.5086 2013 2 8 33.87629996 2.0749 2013 2 9 39.88474647 2.2331 2013 2 10 46.37583149 2.0595 2013 2 11 37.84861803 2.0879 2013 2 12 36.81822299 2.0664 2013 2 13 45.84736073 2.6253 2013 2 14 38.04668619 2.294 2013 3 1 27.00188694 2.0028 2013 3 2 25.09301025 2.025 2013 3 3 28.17829385 1.9966 2013 3 4 36.22751169 2.0871 2013 3 5 40.66412282 2.3404 2013 3 6 39.20731307 2.2173 2013 3 7 39.41798012 2.3917 2013 3 8 39.23397263 2.3486 2013 3 9 37.64747136 2.2117 2013 3 10 29.96162559 2.1076 2013 3 11 31.78057182 2.2512 2013 3 12 36.3789162 2.1105 2013 3 13 34.93669486 2.3779 2013 3 14 42.51055583 1.9804 2013 4 1 25.81348427 1.9617 2013 4 2 26.38421661 1.9686 2013 4 3 22.45640931 2.0163 2013 4 4 37.74773475 1.9961 2013 4 5 32.47205331 2.1269 2013 4 6 35.52839882 2.1632 2013 4 7 40.13006885 2.3395 2013 4 8 37.4494409 2.0992 2013 4 9 36.40219148 2.0837 2013 4 10 37.56598903 2.2792 2013 4 11 45.3277025 2.139 2013 4 12 44.89498835 1.9917 2013 4 13 40.36022481 2.5024 2013 4 14 40.04052163 2.0841 2014 1 1 30.13545512 1.8589 2014 1 2 21.68158163 1.8205 2014 1 3 34.3375145 1.8732 2014 1 4 28.17988965 2.0661 2014 1 5 24.99393638 2.6146 2014 1 6 24.94822142 2.7432 2014 1 7 25.25199378 2.9065 2014 1 8 20.50395587 2.7465 2014 1 9 27.20184828 2.4618 2014 1 10 24.41035175 2.4244 2014 1 11 28.14123853 2.7592 2014 1 12 25.60134288 2.9146 2014 1 13 28.18519434 2.8867 2014 1 14 26.6835492 2.3515 2014 2 1 29.78074688 2.0198 2014 2 2 33.29831949 1.8684 2014 2 3 32.0129351 1.9268 2014 2 4 28.59327824 2.0623 2014 2 5 26.43778913 2.572 2014 2 6 27.81776783 2.5327 2014 2 7 28.31089216 2.7373 2014 2 8 27.27585421 . 2014 2 9 28.27150178 2.4224 2014 2 10 30.56529808 2.658 2014 2 11 32.07157356 2.6485 2014 2 12 33.57300089 2.3494 2014 2 13 27.03179674 2.6958 2014 2 14 30.26122624 2.8373 2014 3 1 28.89410192 2.8013 2014 3 2 33.01410306 1.7817 2014 3 3 29.15426612 1.8387 2014 3 4 28.678526 2.0703 2014 3 5 25.24981997 2.5686 2014 3 6 29.5458768 2.7455 2014 3 7 32.21082315 2.7622 2014 3 8 30.41174908 2.6518 2014 3 9 29.10433128 2.4417 2014 3 10 30.66626513 2.4987 2014 3 11 32.70807312 2.6965 2014 3 12 30.22749865 2.565 2014 3 13 25.30655896 3.0745 2014 3 14 32.61731963 3.0389 2014 4 1 33.79041346 1.832 2014 4 2 31.1985055 2.0557 2014 4 3 29.79354891 1.9237 2014 4 4 25.93338317 2.1878 2014 4 5 26.85985202 2.3659 2014 4 6 26.83322806 2.7586 2014 4 7 27.17382119 2.8611 2014 4 8 28.13546683 2.4293 2014 4 9 31.31660337 2.3456 2014 4 10 28.87344443 2.5745 2014 4 11 32.63401274 2.6125 2014 4 12 27.76285082 . 2014 4 13 24.11265475 2.961 2014 4 14 37.8508086 2.3618 2015 1 1 21.28178117 2.1013 2015 1 2 12.3609056 2.087 2015 1 3 40.42274412 2.0314 2015 1 4 26.82708909 2.0882 2015 1 5 50.87466387 2.1533 2015 1 6 50.00751924 2.2053 2015 1 7 39.30216102 2.3383 2015 1 8 36.33250856 2.3283 2015 1 9 49.64076296 2.1676 2015 1 10 47.7428716 1.9602 2015 1 11 43.06957131 2.093 2015 1 12 43.06296866 2.153 2015 1 13 34.36973569 2.233 2015 1 14 47.7311134 1.9279 2015 2 1 22.88433337 1.9601 2015 2 2 24.69395532 1.8244 2015 2 3 37.14757082 1.9848 2015 2 4 34.68025933 1.8995 2015 2 5 38.79576977 2.0155 2015 2 6 37.21916057 2.2906 2015 2 7 33.50570879 2.2379 2015 2 8 14.00024007 2.2524 2015 2 9 42.94052085 2.134 2015 2 10 44.13895028 2.1761 2015 2 11 46.24279225 2.0903 2015 2 12 38.71680896 2.1773 2015 2 13 32.77248794 2.2912 2015 2 14 38.82273078 2.1675 2015 3 1 14.61918371 1.9814 2015 3 2 35.14829463 1.9081 2015 3 3 37.23976439 1.9875 2015 3 4 29.93097978 2.1248 2015 3 5 38.26038887 2.3026 2015 3 6 38.66656152 2.3347 2015 3 7 38.01788015 2.3921 2015 3 8 30.47627255 2.403 2015 3 9 59.24651437 2.2553 2015 3 10 41.84519373 2.2157 2015 3 11 41.94684276 2.3268 2015 3 12 44.23168303 2.1607 2015 3 13 31.30745328 2.3711 2015 3 14 29.37541264 2.1117 2015 4 1 26.78909298 1.9313 2015 4 2 41.85601971 1.9527 2015 4 3 21.90370016 2.0552 2015 4 4 39.64286279 1.9116 2015 4 5 28.60002189 2.1084 2015 4 6 47.0622935 2.1913 2015 4 7 49.55126474 2.26 2015 4 8 40.66539676 2.1881 2015 4 9 44.7701509 2.0805 2015 4 10 49.58968174 2.1473 2015 4 11 54.64814808 2.0093 2015 4 12 51.95082362 2.1526 2015 4 13 43.45963825 2.2888 2015 4 14 56.00161601 2.056 2016 1 1 31.48765714 1.9337 2016 1 2 11.34634286 1.9053 2016 1 3 48.28937143 1.8872 2016 1 4 41.90057143 1.7102 2016 1 5 68.84554286 1.7819 2016 1 6 68.22325714 2.109 2016 1 7 78.1176 2.2548 2016 1 8 38.89285714 2.2554 2016 1 9 64.05394286 1.919 2016 1 10 62.60194286 1.934 2016 1 11 77.55754286 1.8604 2016 1 12 77.12194286 2.0576 2016 1 13 79.134 2.2227 2016 1 14 63.3072 1.8235 2016 2 1 23.35645714 1.8087 2016 2 2 22.98308571 1.6376 2016 2 3 40.34485714 1.6608 2016 2 4 35.73994286 2.3099 2016 2 5 47.6256 1.7785 2016 2 6 81.14605714 2.1972 2016 2 7 80.586 2.3527 2016 2 8 48.82868571 2.3906 2016 2 9 76.91451429 2.0157 2016 2 10 76.45817143 1.9308 2016 2 11 72.99411429 2.626 2016 2 12 77.30862857 2.0379 2016 2 13 82.74325714 2.1924 2016 2 14 81.85131429 1.9148 2016 3 1 33.41674286 1.695 2016 3 2 39.99222857 1.6868 2016 3 3 57.43697143 1.7444 2016 3 4 64.80068571 1.7726 2016 3 5 70.7124 1.8374 2016 3 6 74.07274286 2.129 2016 3 7 79.17548571 2.286 2016 3 8 65.94154286 2.2817 2016 3 9 73.20154286 1.9077 2016 3 10 71.31394286 1.8553 2016 3 11 78.57394286 1.8925 2016 3 12 73.49194286 1.753 2016 3 13 78.2628 2.2237 2016 3 14 71.99845714 1.9358 2016 4 1 33.04337143 1.8041 2016 4 2 39.61885714 1.7369 2016 4 3 41.92131429 1.733 2016 4 4 52.16828571 1.6725 2016 4 5 72.72445714 1.8884 2016 4 6 77.49531429 2.1577 2016 4 7 77.41234286 2.1958 2016 4 8 60.65211429 2.2107 2016 4 9 69.05297143 2.077 2016 4 10 76.06405714 1.8831 2016 4 11 62.06262857 1.774 2016 4 12 79.09251429 1.9528 2016 4 13 79.03028571 2.1526 2016 4 14 73.59565714 1.8936 data two; set one; mgha = buac*60*1.12; nuptake = mgha*(gn/100); proc print; proc glm; class yr rep trt; model nuptake mgha = yr rep(yr) trt yr*trt; test h = yr e = rep(yr); means yr trt yr*trt; run; data three; set two; proc sort; by yr; proc glm; by yr; class rep trt; model nuptake mgha = rep trt; means trt; run;