/*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\0-GCREW Archive\Archived Data\2-CO2xN\1-Biomass (Derived)\ 1-CO2xN Sedge Shoot Biomass 2005-2019.csv" out=Sedge dbms=csv replace; getnames=YES; proc sort; by year chamber CO2 Nitrogen Treatment; run; proc import datafile="S:\Biogeochemistry\GCREW\0-GCREW Archive\Archived Data\2-CO2xN\1-Biomass (Derived)\ 2-CO2xN Non-Sedge Shoot Biomass 2005-2019.csv" out=NonSedge dbms=csv replace; getnames=YES; proc sort; by year chamber CO2 Nitrogen Treatment; run; Data MergeData; merge Sedge NonSedge; by year chamber CO2 Nitrogen Treatment; run; Data AllShoots; retain Year Chamber CO2 Nitrogen Treatment SCmass_m2 SCdensity_m2 SPmass_m2 SPdensity_m2 DImass_m2 DIdensity_m2 LitterMass_m2; set MergeData; run; proc export data=AllShoots outfile='S:\Biogeochemistry\GCREW\0-GCREW Archive\Archived Data\2-CO2xN\1-Biomass (Derived)\ 4-CO2xN Total Shoot Biomass 2005-2019.csv' replace dbms=csv; run;