/*This program reads two files that contain the biomass and density of the all plant species in the elevated CO2 x community experiment. It reports annual total aboveground biomass for the sedge Schoenoplectus americanus (formerly Scirpus olneyi), the grasses Spartina patens and Distichlis spicata, and "other" less common species. All data are in grams per m2*/ proc import datafile=" S:\Biogeochemistry\GCREW\Archived Data\1-CO2xCommunity\1-Biomass (Derived)\1-CO2xComm Sedge Shoot Biomass 1987-2013.XLS" out=Sedge dbms=excel replace; sheet="SCSHOOTS"; proc sort; by year community treatment chamber; run; proc import datafile="S:\Biogeochemistry\GCREW\Archived Data\1-CO2xCommunity\1-Biomass (Derived)\2-CO2xComm Non-Sedge Shoot Biomass.XLS" out=NonSedge dbms=excel replace; sheet="AllNonSedge"; proc sort; by year community treatment chamber; run; Data MergeData; merge Sedge NonSedge; by year community treatment chamber; rename SP_Total_Mass=SPbiomass_m2 SP_Count=SPdensity_m2 DI_Total_Mass=DIbiomass_m2 DI_Count=DIdensity_m2 OTHER_Mass=OTHERbiomass_m2 OTHER_Count=OTHERdensity_m2; run; Data AllShoots; retain year community treatment chamber SCbiomass_m2 SCdensity_m2 SPbiomass_m2 SPdensity_m2 DIbiomass_m2 DIdensity_m2 OTHERbiomass_m2 OTHERdensity_m2; set MergeData; run; proc export data=AllShoots outfile='S:\Biogeochemistry\GCREW\Archived Data\1-CO2xCommunity\1-Biomass (Derived)\4-CO2xComm Total Shoot Biomass 1987-2013' replace dbms=excel; run;