data one; input Trial $ REP TRT Mid_NDVI Yield Nuptake; cards; Hen2013 1 1 0.666425 3823.637219 . Hen2013 1 2 0.73316 3288.157692 . Hen2013 1 3 0.7485 3822.314202 . Hen2013 1 4 0.65434 3265.902792 . Hen2013 1 5 . . . Hen2013 1 6 0.76465 3259.745261 . Hen2013 1 7 . . . Hen2013 1 8 0.77109 3576.076148 . Hen2013 1 9 0.641045 3608.477941 . Hen2013 1 10 0.729495 4058.060643 . Hen2013 1 11 0.67348 4336.167897 . Hen2013 1 11 0.660755 4714.779328 . Hen2013 1 12 0.681085 3802.58855 . Hen2013 2 1 0.521935 4573.36317 . Hen2013 2 2 0.644125 4093.00861 . Hen2013 2 3 0.69357 4407.26724 . Hen2013 2 4 0.617795 3640.835727 . Hen2013 2 5 0.547225 3838.31058 . Hen2013 2 6 0.73343 2909.978428 . Hen2013 2 7 0.6717 2200.765014 . Hen2013 2 8 0.581195 5045.869333 . Hen2013 2 9 0.51629 3991.278456 . Hen2013 2 10 0.656575 2786.467292 . Hen2013 2 11 0.527175 3904.828728 . Hen2013 2 11 0.55784 4579.588404 . Hen2013 2 12 0.60907 4817.04433 . Hen2013 3 1 0.581085 3616.274998 . Hen2013 3 2 0.59128 3594.443238 . Hen2013 3 3 0.570895 3794.42308 . Hen2013 3 4 0.445105 3219.214106 . Hen2013 3 5 0.589 3769.548663 . Hen2013 3 6 0.58206 3529.746284 . Hen2013 3 7 0.637335 3097.090304 . Hen2013 3 8 0.63276 3104.808939 . Hen2013 3 9 0.639205 3797.482663 . Hen2013 3 10 0.50868 3568.821274 . Hen2013 3 11 0.49823 3979.523067 . Hen2013 3 11 0.541055 4099.700425 . Hen2013 3 12 0.582945 3938.621241 . e502-wheat 1 1 0.33231 1631.459542 35.45814169 e502-wheat 1 2 0.290265 981.7515338 20.84454857 e502-wheat 1 3 0.362565 2260.417698 43.76394705 e502-wheat 1 4 0.359225 2187.801657 42.45866675 e502-wheat 1 5 0.357565 3036.534843 69.11760609 e502-wheat 1 6 0.39207 2671.481992 55.71642842 e502-wheat 1 7 0.33971 2704.481466 61.12128114 e502-wheat 1 8 0.212585 1965.330054 49.01729689 e502-wheat 1 9 0.35945 2840.291802 60.70555669 e502-wheat 1 10 0.400255 2537.244762 49.20986215 e502-wheat 1 11 0.379365 3202.988935 64.11102653 e502-wheat 1 12 0.36264 3297.410885 74.1290941 e502-wheat 1 13 0.43682 3614.191147 76.68229356 e502-wheat 1 14 0.30847 2303.584097 47.70261947 e502-wheat 2 1 0.35148 1308.48734 26.21292689 e502-wheat 2 2 0.29416 1744.125887 35.370873 e502-wheat 2 3 0.395445 1877.822143 37.43438441 e502-wheat 2 4 0.31605 2391.779064 50.07907003 e502-wheat 2 5 0.319 2815.95215 59.74887271 e502-wheat 2 6 0.285695 2547.605896 60.80625753 e502-wheat 2 7 0.343855 2671.087941 67.0069121 e502-wheat 2 8 0.319795 2276.487357 47.23483618 e502-wheat 2 9 0.31707 2680.254962 59.85277357 e502-wheat 2 10 0.27842 3116.455876 64.18340877 e502-wheat 2 11 0.375305 2543.427132 53.10421509 e502-wheat 2 12 0.34251 2474.184585 51.12655026 e502-wheat 2 13 0.22894 3080.942641 80.88398716 e502-wheat 2 14 0.368805 2556.737312 58.65155394 e502-wheat 3 1 0.383765 1814.526802 36.34134279 e502-wheat 3 2 0.41469 1686.250289 34.14656835 e502-wheat 3 3 0.421185 1893.581346 37.80724516 e502-wheat 3 4 0.35723 2434.488786 50.81021545 e502-wheat 3 5 0.2092 2732.629054 63.95445037 e502-wheat 3 6 0.327995 2634.731439 58.41990019 e502-wheat 3 7 0.22011 2648.888264 63.35346062 e502-wheat 3 8 0.368145 2636.522961 61.92137826 e502-wheat 3 9 0.311705 2529.910075 55.95402113 e502-wheat 3 10 0.31718 2013.421239 42.43486604 e502-wheat 3 11 0.339675 2135.654426 48.07785244 e502-wheat 3 12 0.28324 2444.663169 51.59461617 e502-wheat 3 13 0.47283 2347.745895 55.82704963 e502-wheat 3 14 0.408465 2856.709352 56.574272 e502-wheat 4 1 0.379425 1734.666143 34.02894573 e502-wheat 4 2 0.316575 1773.019356 34.90365904 e502-wheat 4 3 0.395865 1509.070706 30.42739264 e502-wheat 4 4 0.33165 2536.647775 50.63402624 e502-wheat 4 5 0.31132 2182.121982 46.41155244 e502-wheat 4 6 0.30462 2387.508401 51.64658173 e502-wheat 4 7 0.305995 2696.740626 63.09024696 e502-wheat 4 8 0.36191 2516.602428 52.82851817 e502-wheat 4 9 0.318565 2446.227268 50.97203757 e502-wheat 4 10 0.409285 2524.434463 57.53691027 e502-wheat 4 11 0.428395 3046.021608 65.15440219 e502-wheat 4 12 0.30656 3016.943217 60.08845805 e502-wheat 4 13 0.29416 2712.207107 67.87027065 e502-wheat 4 14 0.46953 2690.723054 56.07735916 data two; set one; proc print; proc sort data = two; by trial; proc glm; by trial; class rep trt; model yield mid_ndvi nuptake= rep trt; means trt; run;