*Program extracts data used in final MRB7 TN and TP SPARROW models;
LIBNAME DIR_D1    'E:\SPARROW\RF1_report\nawqa_archiving\data1_files';
data DIR_D1.data1mod_final;
set DIR_D1.data1mod;
keep 
/*Network Data*/
hydseq mrb_id fnode tnode frac headflag MRB7_ERF1_NUM HUC
STRAHLER MEANQ MEANV RCHSLOPE RCHTOT LENGTH DEMTAREA DEMIAREA
RCHTYPE TERMFLAG PNAME RFRICTION RDEPTH PNMCD HLOAD FADRAIN
FADRAIN_PERCENT rhload drainden station_id staid_num station_name 
LAT lon AREA LOAD_A_00600 LOAD_A_00665
/*Nitrogen Landscape Data*/
boundary_n canbasin atdep_load ps_n_02_all farm_n total_manure_n nlcd_devel_km2
west_nlcd_forest_km2 east_nlcd_forest_km2 ALDER_M2 
/*Phosphorus Landscape Data*/
boundary_p ps_p_02_all total_ag_p natural_p_load
/*Delivery Data*/
HLR_HUMTPSI2_PCT ln_prec_eff_cm ln_soil_permave;
run;