data one; input loc $ rep trt prenrate topnrate topmeth kgha ndvi; cards; lcb 1 1 0 42 1 3411.7 0.573 lcb 1 2 0 42 2 3388.6 0.560 lcb 1 3 0 42 3 4043.5 0.599 lcb 1 4 0 0 4 3324.7 0.635 lcb 1 5 45 51 1 4554.4 0.734 lcb 1 6 45 51 2 4608.8 0.686 lcb 1 7 45 51 3 4345.4 0.692 lcb 1 8 45 0 4 3869.5 0.661 lcb 1 9 90 51 1 4844.6 0.741 lcb 1 10 90 51 2 5677.9 0.783 lcb 1 11 90 51 3 5354.8 0.710 lcb 1 12 90 0 4 4560.0 0.711 lcb 1 13 180 0 4 7836.7 0.802 lcb 2 1 0 42 1 3328.5 0.678 lcb 2 2 0 42 2 4238.0 0.658 lcb 2 3 0 42 3 4112.0 0.661 lcb 2 4 0 0 4 2588.0 0.608 lcb 2 5 45 51 1 4003.0 0.765 lcb 2 6 45 51 2 4166.3 0.737 lcb 2 7 45 51 3 4556.8 0.717 lcb 2 8 45 0 4 4727.2 0.654 lcb 2 9 90 51 1 5232.1 0.683 lcb 2 10 90 51 2 6441.6 0.784 lcb 2 11 90 51 3 5057.2 0.711 lcb 2 12 90 0 4 4813.0 0.658 lcb 2 13 180 0 4 5956.0 0.740 lcb 3 1 0 42 1 3161.3 0.589 lcb 3 2 0 42 2 2824.1 0.711 lcb 3 3 0 42 3 3148.3 0.602 lcb 3 4 0 0 4 4576.6 0.723 lcb 3 5 45 51 1 3055.0 0.783 lcb 3 6 45 51 2 3441.2 0.705 lcb 3 7 45 51 3 3585.9 0.617 lcb 3 8 45 0 4 2999.7 0.721 lcb 3 9 90 51 1 5068.0 0.765 lcb 3 10 90 51 2 4942.8 0.804 lcb 3 11 90 51 3 3812.4 0.683 lcb 3 12 90 0 4 6329.0 0.776 lcb 3 13 180 0 4 5966.4 0.753 hask 1 1 0 19 1 3908.4 . hask 1 2 0 19 2 3824.1 . hask 1 3 0 19 3 4037.5 . hask 1 4 0 0 4 4934.2 . hask 1 5 45 22 1 7670.6 . hask 1 6 45 22 2 5604.9 . hask 1 7 45 22 3 4001.3 . hask 1 8 45 0 4 4635.7 . hask 1 9 90 22 1 6934.0 . hask 1 10 90 22 2 6606.4 . hask 1 11 90 22 3 8348.1 . hask 1 12 90 0 4 5043.4 . hask 1 13 180 0 4 8033.2 . hask 2 1 0 19 1 5375.6 . hask 2 2 0 19 2 3626.5 . hask 2 3 0 19 3 4258.5 . hask 2 4 0 0 4 2852.7 . hask 2 5 45 22 1 6476.9 . hask 2 6 45 22 2 7031.4 . hask 2 7 45 22 3 4800.4 . hask 2 8 45 0 4 6112.5 . hask 2 9 90 22 1 4908.5 . hask 2 10 90 22 2 6978.2 . hask 2 11 90 22 3 6533.0 . hask 2 12 90 0 4 6680.3 . hask 2 13 180 0 4 7827.5 . hask 3 1 0 19 1 4908.5 . hask 3 2 0 19 2 3257.3 . hask 3 3 0 19 3 4556.3 . hask 3 4 0 0 4 3373.3 . hask 3 5 45 22 1 6063.9 . hask 3 6 45 22 2 4967.2 . hask 3 7 45 22 3 6728.9 . hask 3 8 45 0 4 5929.6 . hask 3 9 90 22 1 5239.4 . hask 3 10 90 22 2 6122.7 . hask 3 11 90 22 3 6563.5 . hask 3 12 90 0 4 6116.2 . hask 3 13 180 0 4 5780.7 . data two; set one; if trt = 13 then delete; totalnrate = prenrate+topnrate; proc print; data two; set one; proc sort; by loc; proc glm; by loc; class rep trt; model kgha = rep trt; means trt; run;