Document ID: EPA-HQ-OW-2008-0465-1904
Agency: epa
Document Type: Supporting & Related Material
Title: 
Posted Date: 2009-12-09T05:00Z

ReadMe “TSS, TN, and TP Summary Stats_Final Rule.sas” 

Author: Abt Associates, Inc.

Date November 19, 2009

This document describes the input files, output files, and steps taken
in the SAS program “SS, TN, and TP Summary Stats_Final Rule.sas”
(DCN 6-7703)

PLEASE REMOVE THE DCN X-XXX PART FROM THE FILE NAMES PRIOR TO RUNNING
ANY PROGRAMS

Input Files:

The following files are outputted from the SAS program “Krinsky and
Robb Sensitivity Analysis WTP by Reach Including WQ Calcs_Final
Rule.sas” (DCN 6-7907)

TSS_TN_TP_base.sas7bdat  (DCN 6-7913)

TSS_TN_TP_option_1.sas7bdat  (DCN 6-7914)

TSS_TN_TP_option_2.sas7bdat  (DCN 6-7915)

TSS_TN_TP_option_3.sas7bdat  (DCN 6-7916)

TSS_TN_TP_option_4.sas7bdat  (DCN 6-7917)

TSS_TN_TP_option_5.sas7bdat  (DCN 6-7918)

Est_base.sas7bdat  (DCN 6-7919)

Est_option_1.sas7bdat  (DCN 6-7920)

Est_option_2.sas7bdat  (DCN 6-7921)

Est_option_3.sas7bdat  (DCN 6-7922)

Est_option_4.sas7bdat  (DCN 6-7923)

Est_option_5.sas7bdat  (DCN 6-7924)

The following file is extracted from the Access Database “WQI
Data.mdb”

 “NLCD.xls” (DCN6-7701) 

The following file is extracted from the SPARROW input file “Sept 28
loads for SPARROW.xls” (DCN X-XXX)

“Reaches with loadings 092909.xls” (DCN6-7702)

Output File:

TSS Sum Stats 19NOV09.xls (DCN6-7704)

File Information:

TSS, TP, and TN concentrations are imported for all RF1 reaches in the
analysis from the following files, where Option 5 is the hypothetical no
discharge scenario:

TSS_TN_TP_base.sas7bdat  (DCN 6-7913)

TSS_TN_TP_option_1.sas7bdat  (DCN 6-7914)

TSS_TN_TP_option_2.sas7bdat  (DCN 6-7915)

TSS_TN_TP_option_3.sas7bdat  (DCN 6-7916)

TSS_TN_TP_option_4.sas7bdat  (DCN 6-7917)

TSS_TN_TP_option_5.sas7bdat  (DCN 6-7918)

A dataset containing TSS, TN, or TP concentrations under all options is
created.  These datasets are then merged with the data from “Reaches
with loadings 092909.xls (DCN 6-7702)” to identify the reaches with
direct construction sediment discharges.  Data from “NLCD.xls” is
then brought in to identify the top 1 percent, 10 percent, and 25
percent of reaches developed land during the period of 1992-2001.  The
program then calculates regional and national summary statistics for
TSS, TN, and TP concentrations under the baseline, all options, and the
hypothetical no discharge scenario.  The total number of miles with
reductions in TSS concentrations is calculated for all RF1 reaches in
the analysis, reaches with direct construction loading, and the top 1
percent, 10 percent, and 25 percent of reaches at both the national and
regional level.  

The following input files contain data for all estuarine reaches in the
analysis

Est_base.sas7bdat  (DCN 6-7919)

Est_option_1.sas7bdat  (DCN 6-7920)

Est_option_2.sas7bdat  (DCN 6-7921)

Est_option_3.sas7bdat  (DCN 6-7922)

Est_option_4.sas7bdat  (DCN 6-7923)

Est_option_5.sas7bdat  (DCN 6-7924)

Summary statics are calculated for TSS concentrations under the
baseline, all options, and the hypothetical no discharge scenario for
estuaries only.  The total number of estuarine miles with TSS reductions
is also calculated at a national level under each option,  

 PAGE   

 PAGE   2