/*This program reads two files that contain the biomass and density of the all plant species in the elevated CO2 x Nitrogen experiment. It reports annual total aboveground biomass for the sedge Schoenoplectus americanus (formerly Scirpus olneyi), the grasses Spartina patens and Distichlis spicata. All data are in grams per m2*/ proc import datafile="S:\Biogeochemistry\GCREW\Archived Data\2-CO2xN\1-Biomass (Derived)\1-CO2xN Sedge Shoot Biomass 2005-2014.XLS" out=Sedge dbms=excel replace; sheet="SCSHOOTS"; proc sort; by year chamber CO2 Nitrogen Treatment; run; proc import datafile="S:\Biogeochemistry\GCREW\Archived Data\2-CO2xN\1-Biomass (Derived)\2-CO2xN Non-Sedge Shoot Biomass 2005-2014.XLS" out=NonSedge dbms=excel replace; sheet="AllNonSedge"; proc sort; by year chamber CO2 Nitrogen Treatment; run; Data MergeData; merge Sedge NonSedge; by year chamber CO2 Nitrogen Treatment; rename SP_Mass=SPbiomass_m2 SP_Density=SPdensity_m2 DI_Mass=DIbiomass_m2 DI_Density=DIdensity_m2 Litter_Mass=Litterbiomass_m2; run; Data AllShoots; retain Year Chamber CO2 Nitrogen Treatment SCbiomass_m2 SCdensity_m2 SPbiomass_m2 SPdensity_m2 DIbiomass_m2 DIdensity_m2 Litterbiomass_m2; set MergeData; run; proc export data=AllShoots outfile='S:\Biogeochemistry\GCREW\Archived Data\2-CO2xN\1-Biomass (Derived)\4-CO2xN Total Shoot Biomass 2005-2014' replace dbms=excel; run;