data t1; infile 'd:\osu\lt\502\lah50288.sas'; input rep trt depth ph nh4nx no3nx minn nx orgn no3 ke actn cx melp cec; /* This is the new NH4-N and NO3-N Data Run in July of 1994 */ data txx; input rep 1 trt 2-3 depth 4-5 nh4n no3n; cards; 10201 21.8229 1.097 10202 13.4355 2.696 10203 13.3562 2.8098 10204 11.3551 2.767 10205 8.3612 1.8619 10206 7.7882 2.1964 10207 8.286 1.7527 10208 6.3316 2.0484 10209 6.76 2.766 10210 3.9928 2.2449 10301 18.1974 1.7736 10302 14.5132 3.6047 10303 9.6401 2.3855 10304 9.4627 2.1408 10305 7.2363 2.4396 10306 5.8972 1.8808 10307 5.1062 2.1083 10308 2.9527 1.8881 10309 5.8026 2.1885 10310 13.9322 2.5422 10401 17.8853 1.3647 10402 12.8338 2.7402 10403 13.566 1.9906 10404 15.4916 2.7527 10405 8.7897 1.9394 10406 9.5866 2.8147 10407 14.6759 3.2818 10408 6.2716 2.0409 10409 5.9399 2.9026 10410 3.1022 2.3412 10501 20.4506 1.6156 10502 12.5323 4.4583 10503 15.6761 3.7835 10504 14.3597 2.4961 10505 7.2572 2.0785 10506 7.4274 2.165 10507 4.9686 2.3105 10508 3.5121 2.4341 10509 3.1444 2.3148 10510 3.3358 2.4278 10601 14.9468 1.3614 10602 12.5264 6.2082 10603 10.751 3.6663 10604 8.3103 2.046 10605 7.7768 1.9879 10606 8.4671 1.9313 10607 4.5355 3.5017 10608 4.4621 2.4412 10609 6.629 3.031 10610 8.4456 2.5399 10701 20.2091 1.1279 10702 15.3422 8.3008 10703 10.6307 5.8631 10704 14.5833 4.0443 10705 8.7749 2.3276 10706 8.8832 1.935 10707 6.8561 2.5305 10708 5.4319 1.8708 10709 4.3572 2.3295 10710 5.5811 2.473 20201 7.5998 2.6688 20202 17.9233 4.7853 20203 11.148 5.2476 20204 10.2007 3.0273 20205 9.4848 2.7949 20206 9.7942 3.4678 20207 6.0544 2.3028 20208 5.5223 2.0216 20209 10.2055 7.2887 20210 6.4764 3.0975 20301 12.8228 1.4603 20302 10.2651 3.6637 20303 10.1877 2.6768 20304 10.4215 2.7441 20305 10.7273 2.4823 20306 8.8246 2.4742 20307 4.6452 2.1834 20308 4.0849 2.8669 20309 2.8034 2.0387 20401 15.245 1.8125 20402 13.3466 3.1972 20403 11.9407 4.7331 20404 12.7426 3.8795 20405 10.4038 2.4569 20406 9.2252 2.2465 20407 13.4327 2.4031 20408 8.3482 2.1348 20409 6.5243 1.9412 20410 6.4489 2.0451 20501 17.4653 2.4612 20502 16.9438 6.5078 20503 16.312 3.9457 20504 12.1287 2.8258 20505 11.275 2.3884 20506 8.7985 2.2199 20507 18.7034 2.0905 20508 11.8453 4.857 20509 7.9975 2.5478 20510 13.1177 3.0285 20601 10.806 2.767 20602 20.995 8.5548 20603 11.0341 13.1277 20604 13.2843 7.2999 20605 15.443 3.5642 20606 10.3347 2.3331 20607 11.7213 2.4461 20608 6.8796 3.1255 20609 13.1468 3.0842 20610 6.8173 2.9008 20701 23.2985 1.9922 20702 35.4739 6.9715 20703 18.3026 9.6257 20704 11.6636 6.4278 20705 11.147 6.9212 20706 9.2871 3.7783 20707 7.7421 3.4675 20708 9.131 9.9099 20709 12.2184 12.7233 20710 11.1536 8.4088 30201 21.4282 1.895 30202 12.5619 4.2209 30203 11.8281 4.0668 30204 14.5139 2.7833 30205 6.5 2.5639 30206 13.5157 2.4194 30207 8.8453 2.328 30208 12.4707 2.8678 30209 3.9854 3.2734 30210 5.68 2.2878 30301 24.8163 1.7595 30302 15.7691 5.3298 30303 10.3999 5.3139 30304 10.9375 5.5355 30305 10.0491 2.6723 30306 9.3284 2.3702 30307 4.9655 2.0344 30308 8.4056 2.6885 30309 3.9379 2.4711 30310 4.6068 2.0413 30401 21.3258 1.6808 30402 12.8641 3.8917 30403 8.802 5.3308 30404 13.8017 6.3566 30405 12.5415 3.4938 30406 12.6688 3.1062 30407 8.7043 2.322 30408 11.8068 2.7837 30409 4.2426 3.3128 30410 4.2058 2.5632 30501 26.962 1.6907 30502 14.0227 1.9975 30503 14.0169 3.3604 30504 14.7703 3.7345 30505 7 2 30506 9.3466 2.9431 30507 8.2306 4.4146 30508 5.674 3.3887 30509 4.6363 3.0037 30510 5.177 2.9089 30601 17.3965 1.7206 30602 20.7562 2.0302 30603 9.9732 5.5384 30604 14.2285 3.8338 30605 9.3886 2.4039 30606 6.4061 2.6765 30607 7.4455 3.1232 30608 3.7949 3.1957 30609 3.0903 3.347 30610 2.6457 2.8752 30701 16.0013 1.7115 30702 14.2566 2.3442 30703 10.6995 4.8443 30704 13.0253 5.5784 30705 7.8176 1.9375 30706 6.1272 1.9933 30707 4.9023 2.0334 30708 4.4177 2.5413 30709 12.2184 12.7233 30710 11.1536 8.4088 40201 17.0324 1.5545 40202 20.4688 9.1021 40203 11.56 2.684 40204 9.7175 2.2189 40205 5.9063 2.4781 40206 4.0282 2.574 40207 3.5972 3.1569 40208 2.5928 7.9249 40209 2.5099 3 40210 2.3694 3 40301 19.7512 0.1811 40302 13.5823 2.832 40303 10.9402 4.1031 40304 9.2128 2.6085 40305 6.3212 1.9082 40306 5.4454 1.9418 40307 3.1691 2.1595 40308 3.494 2.2283 40309 2.7643 2.1577 40310 2.7035 2.6211 40401 19.3867 1.5417 40402 18.1462 2.0813 40403 11.9801 3.2373 40404 13.995 3.9577 40405 5.9779 1.8854 40406 7.3892 2.6044 40407 4.8138 2.9307 40408 4.8833 3.9931 40409 2.1066 8.7565 40410 3.3238 11.4016 40501 27.5135 0.956 40502 16.6943 2.9011 40503 10.6823 7.3149 40504 11.6481 5.9149 40505 7.6991 2.8374 40506 5.1386 2.084 40507 4.0827 2.5387 40508 4.6725 2.3412 40509 2.3688 2.6651 40510 8.1975 2.6946 40601 19.3802 1.5272 40602 12.1335 2.1216 40603 11.8409 3.8736 40604 9.8984 2.8327 40605 5.8976 3.1737 40606 5.0217 2.9512 40607 3.771 2.0451 40608 3.7377 2.5273 40609 4.0281 1.8713 40610 4.2756 2.7605 40701 32.4957 29.6738 40702 16.1969 18.2493 40703 11.7243 16.3148 40704 15.2859 7.0477 40705 12.0076 3.2594 40706 13.7662 4.415 40707 8.1219 20.111 40708 7.6724 12.2352 40709 9.8516 4.5765 40710 11.0639 4.163 data t2; input rep 1 trt 2-3 depth 4-5 nh4n no3n; /* This data was rerun (again) in August, 1994 */ cards; 10201 26.7527 4.3837 10202 17.2169 7.0921 10203 18.0787 5.0254 10204 14.3117 5.5571 10205 14.2932 5.7334 10206 12.9184 10.7914 10207 11.5508 2.1602 10208 10.6535 4.4921 10209 8.0945 1.9107 10210 5.0637 5.5314 10301 21.6058 3.3879 10302 18.1572 5.401 10303 13.4123 3.3363 10304 11.93 8.0929 10305 10.0678 3.3746 10306 9.4365 5.165 10307 7.5457 2.2213 10308 5.0339 3.0521 10309 6.2518 2.0813 10310 14.753 3.2829 10401 20.753 1.4951 10402 16.0433 3.2539 10403 14.6002 2.6349 10404 19.1402 4.6044 10405 11.537 2.799 10406 11.7143 4.7469 10407 16.5272 4.1997 10408 8.3322 2.7314 10409 8.1824 4.1587 10410 4.5259 2.7457 10501 25.8977 3.6811 10502 15.5747 6.3149 10503 20.8618 8.1431 10504 18.8362 6.4733 10505 13.9691 3.7032 10506 11.016 4.1517 10507 7.2825 2.4829 10508 6.0727 5.4209 10509 5.2402 2.6205 10510 5.3276 3.0744 10601 18.3729 2.5585 10602 15.5978 8.2017 10603 12.4137 5.1789 10604 10.3301 2.3505 10605 10.7489 4.1257 10606 9.725 3.0175 10607 4.7807 4.1979 10608 3.9433 3.2022 10609 6.8015 4.3109 10610 9.4434 3.8906 10701 24.7934 1.5661 10702 18.2102 11.4004 10703 13.8089 10.044 10704 15.0355 6.3564 10705 13.2012 4.4102 10706 15.1838 8.9301 10707 10.1034 2.7487 10708 8.3471 4.9619 10709 7.5562 4.2536 10710 8.9207 5.7076 20201 5.7889 3.1327 20202 18.5822 5.8789 20203 11.0615 5.3049 20204 8.5763 3.5603 20205 8.4311 4.0349 20206 10.2961 6.6829 20207 5.4045 2.5712 20208 5.4841 2.479 20209 4.0654 2.474 20210 5.4235 3.3365 20301 12.8405 2.098 20302 12.1191 6.554 20303 10.7392 3.7384 20304 11.6306 4.2046 20305 10.2393 3.9151 20306 8.704 2.9098 20307 4.2278 2.3218 20308 4.7986 3.3646 20309 1.9465 2.4139 20310 . . 20401 13.6475 2.0443 20402 12.5914 3.9276 20403 10.5644 4.9536 20404 11.1903 4.0106 20405 8.784 3.073 20406 8.2922 3.8057 20407 11.6918 2.0421 20408 7.4289 2.6439 20409 5.2075 2.5006 20410 5.6626 3.4121 20501 16.8034 3.141 20502 16.2483 6.9918 20503 15.1655 3.7706 20504 11.3601 4.2119 20505 10.2297 2.6404 20506 8.476 3.3163 20507 17.1531 2.6761 20508 9.188 3.5232 20509 8.4026 3.2376 20510 12.8884 5.3926 20601 9.8796 2.9579 20602 14.4328 8.8553 20603 12.914 13.6646 20604 12.1461 7.647 20605 14.2773 3.8024 20606 11.5017 2.9754 20607 11.6747 4.01 20608 7.1475 3.0255 20609 11.9486 3.8318 20610 6.5348 3.3668 20701 20.8981 2.352 20702 33.2838 7.4 20703 16.3612 10.6616 20704 14.8906 7.4352 20705 12.2206 5.8603 20706 10.1466 4.5389 20707 9.6794 4.3134 20708 7.1403 7.946 20709 10.7393 11.0233 20710 13.8951 9.1459 30201 22.1562 1.3802 30202 14.0911 4.544 30203 12.9055 4.1455 30204 14.7958 3.7751 30205 24.2998 3.4058 30206 13.9867 2.9511 30207 8.8875 2.5735 30208 12.3904 3.3095 30209 4.9337 3.0798 30210 5.3861 2.7218 30301 26.2183 2.0577 30302 17.0584 5.673 30303 11.5956 5.5663 30304 10.9766 3.6062 30305 10.0491 2.6723 30306 13.3731 2.9735 30307 10.2829 3.2384 30308 6.9084 2.6084 30309 9.2623 3.5946 30310 7.3794 2.911 30401 4.7308 2.9347 30402 21.686 2.0876 30403 13.7942 3.8559 30404 10.5747 5.917 30405 14.2269 6.7951 30406 13.9158 4.5622 30407 11.4885 2.7209 30408 8.9406 2.6546 30409 12.8468 4.328 30410 5.6324 3.2575 30501 6.1851 3.5129 30502 28.4586 1.9418 30503 17.0887 2.2063 30504 17.0379 3.9112 30505 15.7126 4.8557 30506 15.7151 4.7759 30507 8.0033 4.5466 30508 6.4753 3.8048 30509 4.8863 3.7375 30510 6.358 3.0146 30601 19.469 2.2619 30602 24.1944 3.2251 30603 11.5601 7.9749 30604 15.7182 4.9924 30605 11.4716 3.1964 30606 10.6758 3.5313 30607 7.2119 3.3173 30608 4.9874 3.4576 30609 4.5219 3.8126 30610 4.7951 3.2934 30701 19.2036 2.0125 30702 15.9966 2.8653 30703 12.9486 5.5005 30704 13.23 5.9707 30705 9.0681 2.617 30706 7.6908 2.3065 30707 5.8615 2.6546 30708 5.0819 2.8326 30709 3.3928 2.6711 30710 3.3819 2.8562 40201 18.4536 2.4225 40202 15.7857 4.6378 40203 13.2831 4.1161 40204 9.8665 2.6172 40205 6.3633 2.676 40206 6.1889 2.7515 40207 4.5821 3.4509 40208 4.3864 8.6597 40209 4.9029 13.5566 40210 4.3034 21.4321 40301 21.9594 0.5172 40302 15.5839 3.2929 40303 11.5103 4.3857 40304 9.3242 3.4494 40305 6.2441 2.3472 40306 6.4358 2.8693 40307 4.2256 2.2414 40308 4.5443 2.386 40309 3.6684 2.4963 40310 5.0005 3.2072 40401 21.1658 1.8143 40402 20.2636 2.7502 40403 15.5262 4.7376 40404 15.4783 3.9058 40405 9.0864 3.2191 40406 7.8368 2.7526 40407 5.8096 3.3847 40408 7.3853 4.4086 40409 3.2684 9.4673 40410 4.0198 11.7995 40501 29.3763 1.2134 40502 19.5708 2.9273 40503 12.4851 9.2705 40504 13.4704 5.858 40505 8.6514 3.2186 40506 6.4255 2.7164 40507 5.4671 4.2601 40508 5.7386 2.9761 40509 3.6346 6.8896 40510 9.0672 3.1349 40601 21.5032 2.319 40602 14.1817 2.4938 40603 14.7885 4.6449 40604 13.0473 3.5346 40605 7.6861 3.7006 40606 7.5179 3.4647 40607 6.0545 3.1776 40608 5.5206 3.2209 40609 6.1173 3.4916 40610 5.8458 4.14 40701 33.3247 31.1414 40702 18.4661 18.5898 40703 15.3996 16.3285 40704 17.3463 8.0728 40705 20.7632 11.3805 40706 16.577 4.408 40707 11.3327 22.1149 40708 10.4391 13.547 40709 11.8246 4.9538 40710 9.8423 4.3643 data t2; set t2; /* ------------------------------------------------------------- depth = 1 = (0-6"), depth = 2 = (6-12"), depth = 3 = (12-18") depth = 4 = (18-24"), depth = 5 = (24-36"), depth = 6 = (36-48") depth = 7 = (48-60"), depth = 8 = (60-72"), depth = 9 = (72-84") depth = 10 = (84-96"), depth = 11 = (96-108"), depth = 12 = (108-120") g/cm3 * 62.43 = lb/ft3 lb/ft3 * 43560ft3/ac = lb soil/ac (0-12") (21780ft3/ac 0-6") lb soil/ac * 453.592g/lb = g soil/ac g soil/ac * ug N/g = ug N/ac ug N/ac * 0.000001g/ug = g N/ac g N/ac * 0.002204623 lb/g = lb N/ac Pb*(62.43*21780*453.592*0.000001*0.002204623)* no3n = lb no3n/ac (cancel 453.592 g/lb with 0.002204623 lb/g) Pb*(62.43*21780*0.000001) * no3n = lb no3n/ac (6" total depth) Pb*(1.3597254)*no3n = lb no3n/ac (6" total depth) Pb*(2.7194508)*no3n = lb no3n/ac (12" total depth) --------------------------------------------------------------- */ data t3; input rep 1 trt 2-3 depth 4-5 sample $ 6 c1 n1 c2 n2; cards; 10201A .8803733 7.823037E-02 .8109365 5.505062E-02 10202A .5185395 4.516423E-02 .5022267 .0537414 10203A .4988982 4.910615E-02 .5157999 5.444355E-02 10204A .4805254 4.506144E-02 .5223197 4.582553E-02 10205A .3966736 4.549876E-02 .2246534 .0445575 10206A .2945622 2.982635E-02 .2714848 2.882633E-02 10207A .1738865 2.215241E-02 .1898498 2.863293E-02 10208A .1223375 1.532313E-02 .1344714 1.136582E-02 10209A .167402 1.992981E-02 .1666342 1.926606E-02 10210A 5.455505E-02 1.307884E-02 .0464708 1.023084E-02 10201B .5762025 5.837071E-02 .6175247 5.619696E-02 10202B 1.10154 6.778412E-02 .5760524 6.369717E-02 10203B .5395172 6.104754E-02 .54315 5.818252E-02 10204B .4183209 4.667167E-02 .4925015 5.563991E-02 10205B .3477873 4.028157E-02 .3709929 3.741042E-02 10206B .2123821 2.210947E-02 .2207481 .0224814 10207B .1469581 2.042642E-02 .1431327 1.902059E-02 10208B .1006111 1.341963E-02 8.244843E-02 1.353193E-02 10209B 6.679982E-02 9.793563E-03 4.903523E-02 1.095002E-02 10210B 3.239548E-02 8.528421E-03 2.855251E-02 6.980985E-03 10301A .939094 7.348499E-02 .9946231 7.565824E-02 10302A .9556509 7.979613E-02 .9459565 8.219367E-02 10303A .8299225 7.549072E-02 .8282736 7.338355E-02 10304A .7650177 .0665307 .7902565 6.802512E-02 10305A .6920556 6.329966E-02 .6522447 6.016112E-02 10306A .4493907 4.403146E-02 .3935336 .0390345 10307A .1641187 2.864849E-02 .1524627 .0252585 10308A 7.721147E-02 1.976547E-02 7.594775E-02 2.053456E-02 10309A .4835137 1.075254E-02 .4440107 1.032553E-02 10310A 2.121467E-02 1.544549E-02 2.804599E-02 .0192705 10401A .5811988 5.609923E-02 .6195147 5.099978E-02 10402A .5274373 4.909318E-02 .4882222 4.756696E-02 10403A .4257148 4.135704E-02 .4137894 4.250273E-02 10404A .4414302 5.333313E-02 .4226734 5.251716E-02 10405A .3871228 .0438323 .3250753 3.506485E-02 10406A .1817104 2.332018E-02 .1742456 1.976814E-02 10407A .1231383 1.529282E-02 .1206313 1.832829E-02 10408A 7.382819E-02 1.261909E-02 7.266678E-02 1.285241E-02 10409A 6.103272E-02 1.409689E-02 5.145929E-02 1.480675E-02 10410A 3.843581E-02 8.069998E-03 3.962402E-02 9.014357E-03 10501A .6134337 6.213264E-02 .7398976 7.025087E-02 10502A .5101424 5.899309E-02 .4838755 5.569779E-02 10503A .5096325 6.342918E-02 .5126234 5.054608E-02 10504A .3979794 4.844738E-02 .3714442 4.728249E-02 10505A .3751421 4.467566E-02 .3684558 4.213445E-02 10506A .1926899 2.393265E-02 .1937344 2.550191E-02 10507A 9.041864E-02 1.411649E-02 9.772215E-02 1.348558E-02 10508A 4.367243E-02 1.531649E-02 3.345804E-02 1.167016E-02 10509A 4.196949E-02 1.014615E-02 7.151623E-02 1.610426E-02 10510A 2.197047E-02 1.188102E-02 .0276418 1.161684E-02 10601A .6322386 6.378949E-02 .5750678 5.998595E-02 10602A .5425984 6.029787E-02 .5239851 6.298747E-02 10603A .4627919 5.341494E-02 .510746 4.866143E-02 10604A .4246036 5.323107E-02 .442575 .0405641 10605A .554167 2.583572E-02 .5293197 2.695369E-02 10606A .4100905 1.904915E-02 .4026608 1.555869E-02 10607A .1911681 6.59945E-03 .1839246 1.015409E-02 10608A 6.533909E-02 . 7.269336E-02 . 10609A 9.354576E-02 . .1007005 . 10610A .2117514 . .2545832 . 10701A .7479888 3.545371E-02 .906384 .034162 10702A .8082338 2.251089E-02 .728403 1.939961E-02 10703A .7227523 .0189068 .7239431 2.314576E-02 10704A .5655321 1.797751E-02 .6016918 8.247459E-03 10705A .5222757 4.412398E-03 .5765688 5.505734E-03 10706A .4621047 4.513345E-02 .433266 4.354434E-02 10707A .3450934 3.824131E-02 .3478191 3.796003E-02 10708A .1790944 2.589977E-02 .2066289 3.095558E-02 10709A 6.445193E-02 1.582916E-02 .0746997 1.670945E-02 10710A .1372549 2.384205E-02 .142127 2.195177E-02 20201B .9229714 7.095412E-02 .8934018 7.064475E-02 20202B .7464718 7.562692E-03 .7609314 1.716393E-02 20203B .686446 1.455115E-02 .6206955 6.718174E-03 20204B .7739302 6.258472E-02 .7525992 5.948212E-02 20205B .5213028 3.096173E-03 .5368747 3.333543E-03 20206B .3746112 3.758097E-02 .3746008 3.762321E-02 20207B .1688995 1.737693E-02 .1665715 1.728029E-02 20208B 9.497291E-02 1.370702E-02 .1070115 .0153992 20209B .0720279 1.484757E-02 7.323848E-02 1.138334E-02 20210B 3.924166E-02 1.102844E-02 5.478004E-02 .0113822 20201A .6845099 6.608184E-02 .5119032 5.379312E-02 20202A .53477 6.101766E-02 .5511501 5.459991E-02 20203A .5018458 4.409767E-02 .5320372 4.581489E-02 20204A .2394571 4.148407E-02 .4513592 3.709339E-02 20205A .3621861 3.235094E-02 .3496964 2.904571E-02 20206A .186807 1.621422E-02 .2071457 1.760319E-02 20207A .1233926 1.055808E-02 .1396991 1.077666E-02 20208A 7.017347E-02 4.614297E-03 6.272124E-02 4.706419E-03 20209A 7.023507E-02 6.555981E-03 4.491654E-02 8.490871E-03 20210A 2.845117E-02 9.520333E-03 3.062225E-02 9.793292E-03 20301A .5872893 5.306406E-02 .6088288 5.705583E-02 20302A .50544 4.798369E-02 .4908123 3.724186E-02 20303A .5378977 5.025559E-02 .5490708 5.849722E-02 20304A .4689305 4.706858E-02 .4658695 5.020489E-02 20305A .3489056 4.386081E-02 .3881178 .0445111 20306A .1587907 1.985001E-02 .1497042 3.519157E-02 20307A 8.267658E-02 4.020805E-03 8.245528E-02 5.048367E-03 20308A 7.522897E-02 4.437492E-03 6.900665E-02 9.377035E-03 20309A 3.717017E-02 1.300865E-02 .038745 1.410791E-02 20310A 1.200182E-02 5.540275E-03 1.145298E-02 2.302123E-03 20401A .5923308 6.932022E-02 .5548777 5.703358E-02 20402A .5474481 4.963898E-02 .5684763 4.550896E-02 20403A .5268956 5.666191E-02 .5140361 5.938464E-02 20404A .4173723 3.740585E-02 .4403077 4.936306E-02 20405A .3878385 4.214097E-02 .3994087 4.023249E-02 20406A .2823534 3.388856E-02 .2974164 6.019353E-02 20407A .210754 1.833981E-02 .2083839 2.287375E-02 20408A .1810234 2.178539E-02 .1713887 1.762875E-02 20409A .1495065 1.487819E-02 .1696715 1.829679E-02 20410A .1069551 1.253339E-02 9.686895E-02 1.125262E-02 20501A .5466775 4.993425E-02 .5547454 6.365208E-02 20502A .6285064 5.670048E-02 .6511983 6.617108E-02 20503A .6375437 5.307669E-02 .6152971 4.874848E-02 20504A .5305657 4.768221E-02 .2582358 3.737655E-02 20505A .4178481 .0395325 .4264941 4.794277E-02 20506A .2896627 2.533153E-02 .2628742 2.358952E-02 20507A .1918071 1.811341E-02 .1993408 1.912394E-02 20508A .1684558 1.441645E-02 8.658549E-02 .0140047 20509A 4.074717E-02 9.510163E-03 .0484219 1.272102E-02 20510A 2.802798E-02 3.597625E-02 3.356851E-02 .0514547 20601A .6259589 5.320679E-02 .7295446 6.542894E-02 20602A .6053047 .0579103 .6481595 5.748385E-02 20603A .5498996 5.325002E-02 .5522284 .0526599 20604A .4967287 5.328968E-02 .5196909 7.624702E-02 20605A .4168998 4.141044E-02 .4047948 3.732353E-02 20606A .2133611 2.228635E-02 .2212843 2.167039E-02 20607A 9.477147E-02 1.074216E-02 9.332903E-02 1.346936E-02 20608A 6.999541E-02 .0117909 6.639726E-02 1.220962E-02 20609A .0458854 .0138468 3.574071E-02 1.133568E-02 20610A 2.715323E-02 1.067646E-02 2.500933E-02 9.294854E-03 20701A .5849072 .0650188 .624476 6.367505E-02 20702A .5846524 5.214766E-02 .5645213 .0553317 20703A .5811511 5.973529E-02 .5679861 6.307595E-02 20704A .5125689 5.786242E-02 .495072 5.513928E-02 20705A .380522 4.172344E-02 .3801272 4.062457E-02 20706A .327433 3.902749E-02 .3482941 3.550376E-02 20707A .1642472 1.895311E-02 .1689752 1.859172E-02 20708A 6.258347E-02 1.085564E-02 .1066128 1.146586E-02 20709A 4.325106E-02 1.454507E-02 3.451578E-02 1.377568E-02 20710A 4.054885E-02 1.613581E-02 4.663258E-02 .0151853 20701B .9598255 6.635167E-02 1.21156 8.497769E-02 20702B .828975 .0582884 .8524349 5.727985E-02 20703B .7838352 5.985964E-02 .8106541 6.187713E-02 20704B .6381226 5.108052E-02 .6687264 .0555585 20705B .5163527 4.148515E-02 .490203 4.529982E-02 20706B .3733335 2.525023E-02 .2639946 .0231382 20707B .1107045 1.155733E-02 8.671554E-02 9.842847E-03 20708B 4.859666E-02 6.399905E-03 3.787152E-02 5.250071E-03 20709B . 6.009196E-03 9.876115E-03 7.213657E-03 20710B . 8.502626E-03 4.958794E-03 8.733431E-03 30201A .7191591 .053465 .8414207 5.697513E-02 30202A .7210836 5.314666E-02 .714856 5.606566E-02 30203A .6961283 5.063958E-02 .7116832 5.345977E-02 30204A .5947075 4.742643E-02 .699486 .1014288 30205A .5382972 3.912269E-02 .5325969 3.875302E-02 30206A .3738859 2.977443E-02 .3245545 2.417156E-02 30207A .1685234 1.169235E-02 .2715001 1.895197E-02 30208A 5.003827E-02 7.810974E-03 6.875356E-02 1.090074E-02 30209A 5.584972E-03 7.373216E-03 1.474668E-02 7.077226E-03 30210A 1.737012E-02 9.701866E-03 2.512421E-02 9.688779E-03 30201B .9601064 6.682051E-02 .6070633 5.118091E-02 30202B .6732278 6.746651E-02 .6634124 6.982156E-02 30203B .6105068 5.444914E-02 .6184243 5.656743E-02 30204B .5236815 4.718918E-02 .4935602 5.067942E-02 30205B .3780197 4.066833E-02 .2192618 4.014336E-02 30206B .2078807 2.198938E-02 .2174223 2.346504E-02 30207B .1229129 1.669113E-02 .1305625 .0168078 30208B 9.617323E-02 1.370913E-02 8.695055E-02 1.429386E-02 30209B .1051551 1.153605E-02 5.765548E-02 1.215036E-02 30210B 9.329063E-02 2.534444E-02 3.532953E-02 1.081942E-02 30301A .6163912 6.272384E-02 .5918033 6.128151E-02 30302A .5289581 5.699665E-02 .4947732 6.020414E-02 30303A .4778765 .0538921 .532752 5.378435E-02 30304A .4480256 5.515898E-02 .5035632 5.665273E-02 30305A .3867516 4.836264E-02 .3808971 4.759048E-02 30306A .2201367 3.125884E-02 .2090824 3.058893E-02 30307A .1009935 1.751185E-02 .1250106 2.058618E-02 30308A .110919 .01817 9.371164E-02 1.862511E-02 30309A 3.970911E-02 1.352849E-02 3.591976E-02 8.832505E-03 30310A .0224016 1.101348E-02 2.403625E-02 0.0119268 30401A .7994245 6.217111E-02 .8671511 6.588376E-02 30402A .7887516 6.955104E-02 .8070932 7.344428E-02 30403A .9318773 8.087171E-02 .8047271 7.000355E-02 30404A .7557306 5.741287E-02 .5670304 4.630675E-02 30405A .5026619 3.718814E-02 .5575179 4.430023E-02 30406A .3503883 3.122229E-02 .3218085 3.091502E-02 30407A .1388866 1.479137E-02 .1925072 .0147229 30408A .8126652 .1734367 2.260804 .1581717 30409A .4786474 .1375163 .3130648 .1028472 30410A .206924 .1266397 .4000926 .1470836 30502A .6357593 7.287965E-02 .7516088 8.004011E-02 30503A .5859541 5.999295E-02 .5491153 6.528753E-02 30504A .5237164 5.590589E-02 .5414184 5.771614E-02 30505A .2354546 5.730048E-02 .4893886 5.911918E-02 30506A .7293814 .0819941 .7050724 7.622422E-02 30507A .1190811 .0156478 .1213008 1.800009E-02 30508A 8.211321E-02 .0140383 .0775262 1.505109E-02 30509A .1004012 1.611264E-02 7.119698E-02 1.753595E-02 30510A 8.735017E-02 1.615429E-02 7.695305E-02 1.569657E-02 30601A .6942509 6.608298E-02 .6663733 6.887866E-02 30602A .9771396 8.060405E-02 .9406838 7.766695E-02 30603A .6250036 6.165726E-02 .6666037 6.647749E-02 30604A .5862092 5.333923E-02 .5415166 5.276363E-02 30605A .4159266 4.393827E-02 .2230477 4.196416E-02 30606A .3093044 3.084048E-02 .2693333 2.887888E-02 30607A .1554997 1.818967E-02 .150234 .0170288 30608A .1048735 1.384062E-02 .1069705 1.321735E-02 30609A 4.925786E-02 1.203473E-02 5.015473E-02 1.216683E-02 30610A .1395262 1.424528E-02 7.437122E-02 9.635363E-03 30701A .6589661 6.538527E-02 .6680091 6.499534E-02 30702A .6940489 .0693341 .676285 6.867294E-02 30703A .5788848 6.800251E-02 .6963809 7.277089E-02 30704A .5361938 6.824719E-02 .560783 5.820085E-02 30705A .5166538 5.063445E-02 .4327228 4.866662E-02 30706A .2629436 2.774938E-02 .2483668 2.718673E-02 30707A .1539056 1.699856E-02 .1298358 1.480377E-02 30708A .0785334 .0135579 6.450628E-02 1.351168E-02 30709A 6.549268E-02 9.908094E-03 4.853542E-02 9.697713E-03 30710A 3.263956E-02 9.942343E-03 .0357794 8.738209E-03 30701B .6715531 6.567945E-02 .6179776 5.622536E-02 30702B .5982123 6.476656E-02 .6280671 6.548677E-02 30703B .6101184 6.082897E-02 .6059818 5.837029E-02 30704B .4934269 4.696372E-02 .5575867 5.112696E-02 30705B .4162909 3.921516E-02 .3689437 3.769363E-02 30706B .2276258 2.659116E-02 .2026878 1.029959E-02 30707B .1304675 1.784522E-02 .1183584 .0409806 30708B .1019824 6.764923E-02 .1364224 8.291048E-02 30709B 5.094003E-02 .1309904 6.240705E-02 .2103476 30710B 6.759248E-02 .3607571 5.254145E-02 .8686981 40201A .6111937 6.165199E-02 .5890218 .0681286 40202A .6002815 6.050002E-02 .7310678 5.740946E-02 40203A .6154536 6.787174E-02 .5325987 6.285697E-02 40204A .5104136 .058786 .5349388 .0606418 40205A .4034541 3.817504E-02 .3913454 3.862558E-02 40206A .2551502 2.761447E-02 .2347988 2.583708E-02 40207A .1463576 1.466744E-02 .1756899 1.471667E-02 40208A .1184531 9.930961E-03 .1497657 .0133082 40209A 7.486122E-02 1.050242E-02 .1126788 1.192727E-02 40210A 7.842159E-02 1.231741E-02 4.154274E-02 .0111714 40301A .613851 6.293489E-02 .5810055 5.656073E-02 40302A .6533129 5.609905E-02 .615775 6.201953E-02 40303A .5095224 4.960864E-02 .5631996 5.299389E-02 40304A .4751585 4.739277E-02 .4468578 .0419015 40305A .3266108 2.911022E-02 .2921408 2.919506E-02 40306A .1967263 2.048917E-02 .1823543 2.037666E-02 40307A .1450196 1.548129E-02 .2919065 2.084886E-02 40308A .1386799 1.428585E-02 .1216383 1.503039E-02 40309A 6.049952E-02 9.051131E-03 6.234856E-02 1.037643E-02 40310A 3.610377E-02 9.367082E-03 4.085755E-02 9.504975E-03 40401A .5664501 5.381111E-02 .5126578 4.841435E-02 40402A .6290363 6.008227E-02 .6152481 6.422524E-02 40403A .5322227 5.820195E-02 .5449905 5.966033E-02 40404A .4941849 5.277361E-02 .4776208 4.501532E-02 40405A .3510837 3.090004E-02 .3844984 3.606271E-02 40406A .2549287 2.260389E-02 .2524197 2.553511E-02 40407A .1505167 1.449946E-02 .200467 1.387248E-02 40408A .1711408 1.584265E-02 .1519581 1.352616E-02 40409A 4.451696E-02 8.469965E-03 5.986854E-02 9.939009E-03 40410A 8.879182E-02 1.064561E-02 .1033266 1.474532E-02 40501A .5023472 5.931237E-02 .5395858 7.318067E-02 40502A .5441044 6.694797E-02 .5441434 6.935956E-02 40503A .4471827 5.201795E-02 .4452563 5.361539E-02 40504A .4457041 5.287323E-02 .4367494 5.422009E-02 40505A .1193779 3.595098E-02 .3107636 3.398012E-02 40506A .1990637 2.528263E-02 .2010415 2.278755E-02 40507A .1141215 1.813143E-02 .1477627 1.881978E-02 40508A .1326886 2.003627E-02 .145425 1.868762E-02 40509A 7.515518E-02 1.467911E-02 7.573543E-02 .0152376 40510A 6.596517E-02 1.347453E-02 .5604787 .0665975 40601A .4806722 6.104082E-02 .4298005 5.753287E-02 40602A .524913 5.790624E-02 .5150157 6.361591E-02 40603A .4536427 .0586688 .4471599 5.868504E-02 40604A .4197127 5.622428E-02 .4736902 5.861511E-02 40605A .3374558 3.999154E-02 .3106152 4.633339E-02 40606A .1547793 2.139869E-02 .1757397 1.987188E-02 40607A .1459551 1.616096E-02 .1434472 1.512771E-02 40608A .1119187 1.486142E-02 .1157394 1.343037E-02 40609A .1381637 1.500708E-02 .1358858 1.439048E-02 40610A .1917375 1.631169E-02 .1647065 1.437575E-02 40701A .5802794 7.227489E-02 .6151395 .0736507 40702A .7406177 7.183398E-02 .7291096 6.976417E-02 40703A .6848173 6.820844E-02 .7748923 6.597221E-02 40704A .4960907 4.703618E-02 .4977051 4.521121E-02 40705A .4952401 4.318866E-02 .4268157 3.537009E-02 40706A .2327957 2.038909E-02 .242488 .0177231 40707A .1636491 1.503614E-02 .1343748 .0123042 40708A .1182918 8.923541E-03 9.153147E-02 9.512236E-03 40709A .0533862 9.947915E-03 5.307205E-02 8.512841E-03 40710A 2.133204E-02 6.533738E-03 4.104207E-02 8.324291E-03 40701B .7119768 6.367992E-02 .7153859 .0690717 40702B .7635489 5.322479E-02 .8102181 6.844763E-02 40703B .6562648 6.102213E-02 .6558845 5.826926E-02 40704B .5788359 5.020469E-02 .615584 5.545357E-02 40705B .5359886 .0395487 .4897883 4.083101E-02 40706B .3193177 .0270219 .3322011 2.714619E-02 40707B .1688924 1.781294E-02 .1760101 1.554149E-02 40708B .115784 1.197438E-02 8.479857E-02 1.065869E-02 40709B 5.742683E-02 8.598054E-03 .0669978 7.901371E-03 40710B 6.375282E-02 8.30565E-03 4.451874E-02 6.485862E-03 data t4; set t3; if depth > 9 then delete; if sample = 'B' then delete; c = (c1 + c2)/2; n = (n1 + n2)/2; if depth = 1 then totnkg = n*10000 * 1.60 * 1.3597254 *1.12; if depth = 2 then totnkg = n*10000 * 1.51 * 1.3597254 *1.12; if depth = 3 then totnkg = n*10000 * 1.53 * 1.3597254 *1.12; if depth = 4 then totnkg = n*10000 * 1.73 * 1.3597254 *1.12; if depth = 5 then totnkg = n*10000 * 1.73 * 2.7194508 *1.12; if depth = 6 then totnkg = n*10000 * 1.73 * 2.7194508 *1.12; if depth = 7 then totnkg = n*10000 * 1.73 * 2.7194508 *1.12; if depth = 8 then totnkg = n*10000 * 1.73 * 2.7194508 *1.12; if depth = 9 then totnkg = n*10000 * 1.73 * 2.7194508 *1.12; if depth = 1 then totckg = c*10000 * 1.60 * 1.3597254 *1.12; if depth = 2 then totckg = c*10000 * 1.51 * 1.3597254 *1.12; if depth = 3 then totckg = c*10000 * 1.53 * 1.3597254 *1.12; if depth = 4 then totckg = c*10000 * 1.73 * 1.3597254 *1.12; if depth = 5 then totckg = c*10000 * 1.73 * 2.7194508 *1.12; if depth = 6 then totckg = c*10000 * 1.73 * 2.7194508 *1.12; if depth = 7 then totckg = c*10000 * 1.73 * 2.7194508 *1.12; if depth = 8 then totckg = c*10000 * 1.73 * 2.7194508 *1.12; if depth = 9 then totckg = c*10000 * 1.73 * 2.7194508 *1.12; data t5; set t2; proc sort; by rep trt depth; data t6; set t4; proc sort; by rep trt depth; data t7; merge t5 t6; by rep trt depth; data t8; set t7; if depth > 9 then delete; if depth = 1 then no3lb = no3n * 1.60 * 1.3597254; if depth = 2 then no3lb = no3n * 1.51 * 1.3597254; if depth = 3 then no3lb = no3n * 1.53 * 1.3597254; if depth = 4 then no3lb = no3n * 1.73 * 1.3597254; if depth = 5 then no3lb = no3n * 1.73 * 2.7194508; if depth = 6 then no3lb = no3n * 1.73 * 2.7194508; if depth = 7 then no3lb = no3n * 1.73 * 2.7194508; if depth = 8 then no3lb = no3n * 1.73 * 2.7194508; if depth = 9 then no3lb = no3n * 1.73 * 2.7194508; if depth = 1 then nh4lb = nh4n * 1.60 * 1.3597254; if depth = 2 then nh4lb = nh4n * 1.51 * 1.3597254; if depth = 3 then nh4lb = nh4n * 1.53 * 1.3597254; if depth = 4 then nh4lb = nh4n * 1.73 * 1.3597254; if depth = 5 then nh4lb = nh4n * 1.73 * 2.7194508; if depth = 6 then nh4lb = nh4n * 1.73 * 2.7194508; if depth = 7 then nh4lb = nh4n * 1.73 * 2.7194508; if depth = 8 then nh4lb = nh4n * 1.73 * 2.7194508; if depth = 9 then nh4lb = nh4n * 1.73 * 2.7194508; nh4kg = nh4lb * 1.12; no3kg = no3lb * 1.12; proc print; data t9; set t8; if depth > 9 then delete; proc glm; classes rep trt depth; model no3kg nh4kg totckg totnkg = rep trt rep*trt depth trt*depth; test h = rep trt e = rep*trt; contrast 'nrate_lin' trt -5 -3 -1 1 3 5/e=rep*trt; contrast 'nrate_qua' trt 5 -1 -4 -4 -1 5/e=rep*trt; means depth trt trt*depth; run; data t10; set t9; proc sort; by rep trt; proc transpose data = t10 out = outn prefix = ndepth; by rep trt; var no3kg; run; data outn; set outn; no3kgt = ndepth1 + ndepth2 + ndepth3 + ndepth4 + ndepth5 + ndepth6 + ndepth7 + ndepth8 + ndepth9; proc print data = outn (obs=24); proc sort data = outn; by trt; proc means; by trt; proc transpose data = t10 out = outa prefix = adepth; by rep trt; var nh4kg; run; data outa; set outa; nh4kgt = adepth1 + adepth2 + adepth3 + adepth4 + adepth5 + adepth6 + adepth7 + adepth8 + adepth9; proc print data = outa (obs=24); proc sort data = outa; by trt; proc means; by trt; data tn; set t10; if depth > 4 then delete; proc transpose data = tn out = outt prefix = tdepth; by rep trt; var totnkg; run; data outt; set outt; totnkgt = tdepth1 + tdepth2 + tdepth3 + tdepth4 ; proc print data = outt (obs=24); proc sort data = outt; by trt; proc means; by trt; data tc; set t10; if depth > 4 then delete; proc transpose data = tc out = outc prefix = cdepth; by rep trt; var totckg; run; data outc; set outc; totckgt = cdepth1 + cdepth2 + cdepth3 + cdepth4; proc print data = outc (obs=24); proc sort data = outc; by trt; proc means; by trt; data new1; set outn; proc glm data = new1; classes rep trt; model no3kgt = rep trt rep*trt; means trt rep*trt; run; data new2; set outa; proc glm data = new2; classes rep trt; model nh4kgt = rep trt rep*trt; means trt rep*trt; data new3; set outt; proc glm data = new3; classes rep trt; model totnkgt = rep trt rep*trt; means trt rep*trt; run; data new4; set outc; proc glm data = new4; classes rep trt; model totckgt = rep trt rep*trt; means trt rep*trt; run;