EPA-600/4-76-057
November 1976
Environmental Monitoring Series
FORMAT FOR ACQUIRING RAPID DATA
ANALYSIS CAPABILITIES OF
STORET DATA:
Manipulation of National Eutrophication
Survey Water Quality Data
Environmental Monitoring and Support Laboratory
Office of Research and Development
U.S. Environmental Protection Agency
Las Vegas, Nevada 89114
-------
RESEARCH REPORTING SERIES
Research reports of the Office of Research and Development, U.S. Environmental
Protection Agency, have been grouped into five series. These five broad
categories were established to facilitate further development and application of
environmental technology. Elimination of traditional grouping was consciously
planned to foster technology transfer and a maximum interface in related fields.
The five series are:
1. Environmental Health Effects Research
2. Environmental Protection Technology
3. Ecological Research
4. Environmental Monitoring
5. Socioeconomic Environmental Studies
This report has been assigned to the ENVIRONMENTAL MONITORING series.
This series describes research conducted to develop new or improved methods
and instrumentation for the identification and quantification of environmental
pollutants at the lowest conceivably significant concentrations. It also includes
studies to determine the ambient concentrations of pollutants in the environment
and/or the variance of pollutants as a function of time or meteorological factors.
This document is available to the public through the National Technical Informa-
tion Service, Springfield, Virginia 22161.
-------
EPA-600/4-76-057
November 1976
FORMAT FOR ACQUIRING RAPID DATA
ANALYSIS CAPABILITIES OF STORET DATA:
Manipulation of National Eutrophication
Survey Water Quality Data
by
J. D. Bliss
Monitoring Operations Division
M. J. Friedland and J. Hodson
Office of Program Management and Support
Environmental Monitoring and Support Laboratory
Las Vegas, Nevada 89114
U.S. ENVIRONMENTAL PROTECTION AGENCY
OFFICE OF RESEARCH AND DEVELOPMENT
ENVIRONMENTAL MONITORING AND SUPPORT LABORATORY
LAS VEGAS, NEVADA 89114
-------
DISCLAIMER
This report has been reviewed by the Environmental Monitoring and
Support Laboratory-Las Vegas, U.S. Environmental Protection Agency, and
approved for publication. Mention of trade names or commercial products
does not constitute endorsement or recommendation for use.
n
-------
CONTENTS
Page
Introduction 1
Conclusions and Recommendations 2
Purpose 2
Historical Background 3
Program Summary 3
Concept of Data Analysis 4
"STORET.TO.WYLBUR" 5
A Word About SAS 7
References 8
Bibliography 8
Appendix 9
iii
-------
INTRODUCTION
The National Eutrophication Survey was initiated in 1972 in response
to an Administration commitment to investigate the nationwide threat of
accelerated eutrophication to freshwater lakes and reservoirs.
The Survey was designed to develop, in conjunction with State
environmental agencies, information on nutrient sources, concentrations,
and impact on selected freshwater lakes as a basis for formulating
comprehensive and coordinated national, regional, and State management
practices relating to point source discharge reduction and nonpoint
source pollution in lake watersheds.
As a principal participating staff of the National Eutrophication
Survey.* the Environmental Monitoring and Support Laboratory-Las Vegas1
Water and Land Quality Branch of the Monitoring Operations Division has
collected water quality data from more than 800 selected lakes
throughout the contiguous United States. To date, the Survey has
yielded more than two million data points.
Analyses of these water quality data address problems unique to
lakes and not amenable to those computer programs available in the U.S.
Environmental Protection Agency's STORET (STOrage and RETrieval) system.
Consequently, a job control language package, "STORET.TO.WYLBUR,"
was developed to convert raw data in STORET to a standardized format for
statistical evaluation and manipulation of Survey data.
. "STORET.TO.WYLBUR" has proven to .be a very effective means for
acquiring rapid data analysis capabilities of STORET data and may be
implemented with facility by both experienced and relatively
inexperienced computer programmers. ,
*The Special Studies Branch, Criteria and Assessment Division, Con/all is
Environmental Research Laboratory, Corvallis, Oregon is also a principal
participating staff of this project. The Corvallis laboratory was
primarily responsible for the collection of municipal sewage treatment
plant and tributary water quality .data (USEPA 1975).
-------
CONCLUSIONS AND RECOMMENDATIONS
The "STORET.TO.WYLBUR" program has satisfied the Water and Land
Quality Branch's additional requirements and is easily used by most
computer personnel. This data analysis scheme may well be ideal for
general use. It is recommended that the program be added as another
program option internal to the Agency's STORET system and the supporting
documentation be generated to assist those wishing to use this computer
program.
PURPOSE
The purpose of this report is to demonstrate a system for a STORET
user to acquire rapid and flexible data analysis capabilities with
minimal effort. The data management scheme outlined is for the use of
organizations which have, or will have, a data base in STORET and
require programming options beyond those available in STORET.
The following definitions of terms may be helpful to enhance the
reader's comprehension:
STORET (STOrage and RETrieval): a central computer-oriented system
used by the Agency to categorize, store, and retrieve water quality
data.
PGM=RET: a STORET program command calling for a variety of
retrieval programs internal to STORET.
MORE File: an assigned name for a disk file created by PGM=RET
retrieval which contains condensed IBM (International Business
Machines) hexadecimal output (USEPA 1974, Volume 2, Chapter 10,
Section M).
WYLBUR: an assigned name for a text "editor" and remote job entry
facility available through OSI (Optimum Systems Incorporated).
EDIT: a format compatible with the WYLBUR text-editing system
available through OSI.
SAS (Statistical Analysis System) and BIOMED (Biomedical Statistical
Computer Programs): two software packages which allow convenient
implementation of various statistical techniques.
-------
The procedures involved in implementing this scheme were designed to
enable users with various levels of systems expertise to use them. To
best operate this system, a user must understand the mechanics of
conducting STORET retrievals, particularly P6M=RET, its associated
options, and the more common WYLBUR editing commands. The ability to
tailor the raw data retrievals from STORET will help appreciably in
preparing data for further analysis.
HISTORICAL BACKGROUND
In early 1974, the only computer operation within the Water and Land
Quality Branch consisted of STORET (lake) data retrievals via a remote
terminal (WYLBUR). Because the data processing and analytical
requirements were not satisfied by the program options internal to the
STORET system, a serious need to convert the raw data in STORET to some
other accessible form was recognized.
The Branch alerted the Laboratory's data services staff (Data
Services Branch, Office of Program Management and Support) to this
problem and requested their assistance. As a result, a job control
language (JCL) package, "STORET.TO.WYLBUR," was written. This program
contains the appropriate IBM JCL and FORTRAN (FORmula and TRANslation, a
computer language) programming (Fried!and 1974) for conversion of the
PGM=RET output, or raw data retrieval of STORET, into an acceptable
input form for use with so-called packaged programs (e.g., SAS, BIOMED)
or user-created programs.
After a short training course on SAS, Branch personnel were able to
make data evaluations. Within about 3 months, the same personnel could
handle most analytical requirements with ease. Using "STORET.TO.WYLBUR"
in conjunction with SAS has proven to be a powerful and highly flexible
tool for data analysis.
PROGRAM SUMMARY
Initially, STORET retrieval data are transferred into a MORE File by
PGM=RET. "STORET.TO.WYLBUR" accesses this file and converts it to
standard card-images and then into EDIT format. Data are then
accessible to the WYLBUR user for input into mathematical packages such
as SAS, BIOMED, etc., and subsequently are easily analyzed (or merged
with other data files) in accordance with the unique requirements of a
given research program. Both novice and expert users are able to use
this data handling method successfully.
-------
CONCEPT OF DATA ANALYSIS
Generally, data analysis operations within the Branch are divided
into three primary areas of involvement, as shown in Figure 1. These
areas are:
(1) STORET - used primarily as a data storage facility. Except for
transfer of raw data in the "STORET.TO.WYLBUR" operation,
minimal use is made of the programs internal to STORET.
(2) "STORET.TO.WYLBUR" - converts data into EDIT format from the
MORE File generated by the STORET raw data retrieval. The
stylized output format is compatible with packaged programming
or user-created programming.
(3) SAS - used for its extensive ability to manipulate and analyze
data (equivalent to FORTRAN) and to perform numerous
statistical procedures which generate plots, implement
regression analyses, etc.
Other operations include merging or concatenation of other files
(block 4.) with the STORET data (block 1,). SAS can also generate data
cards to be used in other programs (block 5.).
1.
STORET
OUTPUT \
(STANDARD PGM\ (MORE FILE)
OPTIONS) \
STORET.TO.WYLBUR
OTHER FILES -
BIOLOGICAL, ETC.
(EDIT)
(MERGING/
/CONCATENATION)
(EDIT)
3
SAS
(CARDS)
\
FORTRAN. BIOMED,
ETC. PROGRAMS
DATA MANIPULATION
SORTING
PRINTING
STATISTICAL
, ANALYSIS
OUTPUT'
Figure 1. Output flow diagram demonstrating data processing logic,
4
-------
"STORET.TO.WYLBUR"
USING "STORET.TO.WYLBUR"
The necessary changes for setting up a job are located in three areas
of the JCL package, as shown in Figure 2.
1. //IIIWY JOB (AAAA,BIN,01,01,01),' STR-TO-WYL1,MSGLEVEL=(1,1)
2. // EXEC WQDIST
3. //DIST.CARDFD DD *
4. PGM RET,PURP=104/EPA,A 11EPALES,MORE=4,RMT 35,B P,
5. S=380000,S=380499,
6. P=671,P=665,
7. T=77777702,
8. PRT=NO,
9. // EXEC FORTGLG PARM='NOMAP'
10. //LKED.SYSIN DD DSN=CNA805. RWT.RDSTOR,
11. // UNIT=3330,VOL=SER=TS0004,DISP=SHR
12. //GO.FT15F001 DD DSN=&FCF,DISP=(OLD,DELETE)
13. //GO.FT12F001 DD DSN=&LAKFIL,DISP=(NEW,PASS),UNIT=SYSDA,
14. // SPACE=(TRK,(25,10)),DCB=(RECFM=FB,LRECL=80,BLKSIZE=1680)
15. //GO.SYSIN DD *
16. 02 NUMBER OF PARAMETERS RETRIEVED IN 1-2 (1-50)
17. // EXEC EDSCARDS,NAME='CNA805.RWT.DATA.SET1,DISK=TS0001,TYPE=OLD
18. //CARDS DD DSN=&LAKFIL,DISP=OLD
Figure 2. Listing of "STORET.TO.WYLBUR"
On Line 1 is the job card which must be adjusted to comply with the
initials and account of each user (see OSI 1973, p. 2-1). The second
segment to be changed is Lines 4-8, the STORET retrieval coding for the
data that are to be converted. If "PRT=NO" (a STORET program command
meaning "do not print") is not included, STORET raw data printout will
also be generated. On Line 16, the number of parameters found in the
STORET coding is given. Line 17 identifies the disk file where the
converted data are written and the file name.
Disk and data set name (Line 17) must be adjusted to fit individual
requirements as shown below:
17 //EXEC EDSCARDS, NAME='CNAA.BBB.CCC',DISK=TSOXXX,TYPE=OLD
where AAA = Account No.
BBB = Initials
CCC = Data Set Name
XXX = Volume Used
-------
Since the file type is old, a dummy file with the file name assigned
by the user should be saved on the disk pack indicated. A copy of the
program entitled "&CNA805.RWT.STORET.TO.WYLBUR" is currently available
to interested persons on TS0001 (one of 16 on-line disk packs currently
available through OSI).
"STORET.TO.WYLBUR" OUTPUT
The output of "STORET.TO.WYLBUR" written onto a disk pack follows
the format shown in Figure 3.
0.170
0.161
0.160
0.155
0.279
0.260
0.245
0.243
0.239
0.283
0.000
0.000
0.000
0.000
0.000
(O
M
co
cu
4->
«o
O
.c 3
o. cr
O
-------
(3) Minimal knowledge of IBM JCL is required. The
"STORET.TO.WYLBUR" program is ideal for users who have neither
time nor long-term requirements to learn the intricacies of IBM
JCL.
DISADVANTAGES
(1) Parameter order must be clearly determined on the data file
created, or gross errors may occur in subsequent analyses.
(2) Large "STORET.TO.WYLBUR" data files are expensive to manipulate
using the WYLBUR editor.
A WORD ABOUT SAS
SAS is the principal software package used by the Branch, and its
capabilities can be clearly stated. First of all, SAS is a unified
system of data manipulation, editing, and statistical analysis
(Service 1972). Programming and assignment statements are designed to
enable the user to effectively modify data prior to final analysis and
display.
Statistical analysis, plotting, and sorting can usually be
implemented using only several lines of coding associated with
"PROCEDURE" statements. Subsetting, concatenation, and data-set merging
have proven to be invaluable tools in data manipulation available in
SAS. In fact, SAS has been used extensively to merge water quality
information originating in STORET with biological information to create
needed data files.
SAS may also be used to process information with the subsequent
output passed from the system into card format for input into other
software packages or user-written programming.
A sample SAS program built around a data file created by
"STORET.TO.WYLBUR" is shown in the Appendix. The output of the program
is also included.
-------
REFERENCES
Fried!and, M. J. 1974. A Method for Improving User Access to STORET.
Proceedings No. 1, ADP Workshop, Office of Research and Development,
U.S. Environmental Protection Agency. Bethany College, October 2.
pp. 37-45.
Optimum Systems Incorporated. 1973. User's Manual. Bethesda, Maryland.
Service, Jolayne. 1972. A User's Guide to the Statistical Analysis
System. (Based on Statistical Analysis System Manual prepared by
A. J. Barr and J. H. Goodnight). Student Supply Stores, North
Carolina State University, Raleigh, North Carolina.
U.S. Environmental Protection Agency. 1974. Handbook - Water Quality
Control Information System - STORET. Volume 2, Chapter 10, Section M.
Washington, D.C.
1975. National Eutrophication Survey Methods 1973-1976.
National Eutrophication Survey Working Paper No. 175. National
Environmental Research Center, Las Vegas, Nevada, and Pacific
Northwest Environmental Research Laboratory, Corvallis, Oregon.
BIBLIOGRAPHY
Perkins, Carroll G. 1974. A Guide to the Supplementary Procedure
Library for the Statistical Analysis System. North Carolina State
University, Raleigh, North Carolina.
U.S. Environmental Protection Agency. 1974. Handbook - Water Quality
Control Information System - STORET. Volumes 1, 2, and 3.
Washington, D.C.
1975. User's Manual for EPA Scientific Applications Software.
Washington, D.C.
-------
APPENDIX
"STORET.TO.WYLBUR" - A SAMPLE RUN
1. The program (&CNA805.RWT.STORET.TO.WYLBUR ON TS0001) ran:
//RWTWY JOB (A805,BIN,01,01,01), 'STR-TO-WYL,MSGLEVEL=(1,1)
// EXEC WQDIST
//DIST.CARDFD DD *
PGM RET,PRUP=104/EPA,A 11EPALES,MORE=4,RMT 35, B P,
S=380000,S=380499,
P=671,P=665,
1=77777702,
PRT=NO,
// EXEC FORTGLG,PARM='NOMAP'
//LKED.SYSIN DD DSN=CNA805.RWT.RDSTOR,
// UNIT=3330,VOL=SER=TS0004,DISP=SHR
//GO.FT15F001 DD DSN=&FCF,DISP=(OLD,DELETE)
//GO.FT12F001 DD DSN=&LAKFIL,DISP=(NEW,PASS),UNIT=SYSDA,
// SPACE=(TRK,(25,10)),DCB=(REDFM=FB,LRECL=80,BLKSIZE=1680)
//GO.SYSIN DD *
02 NUMBER OF PARAMETERS RETRIEVED IN 1-2 (1-50)
// EXEC EDSCARDS,NAME=CNA805.RWT.DATA.SET1,DISK=TS0002,TYPE=OLD
//CARDS DD DSN=&LAKFIL,DISP=OLD
2. Segment of data set written (note that the data set is a standard
WYLBUR File and is accessed into working memory by the "USE" command)
Data Set Name: DATA.SET
Location: TS0002
0.170
0.161
0.160
0.155
0.279
0.277
0.307
0.274
0.220
0.204
0.193
0.260
0.245
0.243
0.239
0.283
0.292
0.326
0.318
0.275
0.245
0.245
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
. 0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.00038010174
0.00038010174
0.00038010174
0.00038010174
0.00038010174
0.00038010174
0.00038010174
0.00038010174
0.00038010174
0.00038010174
0.00038010174
01
51
430 920
430 920
430 920 151
430 920 231
7171120
7171120
7171120 151
7171120 201
9171410 01
9171410 151
9171410 271
01
51
-------
3.
The SAS program below is built around the preceding data
set. Check the external copy command in the OSI Manual
for rapid combining methods of pre-existing programming
and data files.
//RWT JOB (A805,45,1,1),'SAS RUN1,MSGLEVEL=(0,0)
// EXEC SAS
//SAS.SYSIN DD *
TITLE 'ORTHOPHOSPHATE VS TOTAL PHOSPHORUS FOR SELECTED LAKES';
DATA RAW;
INPUT PORTHO 1-10 PT 11-20;
CARDS;
0.170 0.260 0.000
0.161 0.245 0.000
0.160 0.243 0.000
0.155 0.239 0.000
0.279 0.283 0.000
0.277 0.292
0.307
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.00038010174
0.00038010174
0.00038010174
0.00038010174
0.00038010174
0.00038010174
0.00038010174
01
51
430 920
430 920
430 920 151
430 920 231
7171120
7171120
01
51
7171120 151
0.193 0.245 0.000 0.000 0.000 0.00038010174
0.147 0.261 0.000 0.000 0.000 0.00038010274
0.138 0.247 0.000 0.000 0.000 0.00038010274
0.273 0.377 0.000 0.000 0.000 0.00038010274
0.280 0.314 0.000 0.000 0.000 0.00038010274
0.281 0.319 0.000 0.000 0.000 0.00038010274
0.088 0.224 0.000 0.000 0.000 0.00038010274
9171410 271
430 945 01
430 945 81
7171030 01
7171030 51
7171030 171
9171455 01
PROCEDURE PRINT;
PROCEDURE PLOT;
PROCEDURE CORR;
PROCEDURE REGR; MODEL PROTHO=PT;
/*
4. Following are illustrations of the output generated by the
preceding program. The results of the commands PROCEDURE
PRINT;, PROCEDURE PLOT;, PROCEDURE CORR;, PROCEDURE REGR;
MODEL PROTHO=PT;, can be fetched using "FETCH XXX DDN=
FT03F001" where XXX is the job number. This output
demonstrates the capabilities of the SAS "PROCEDURE"
statements and was a modified program exampled (Service 1972).
10
-------
ORTHOPHOSPHATE VS TOTAL PHOSPHORUS FOR SELECTED LAKES
TITLE 'OrtTHOPHOSPHATE VS TOTAL PHOSPHORUS FOR SELECTED LAKES'!
DATA RAW!
INPUT PORTHO 1-10 PT 11-20!
CARDS
106 OBSERVATIONS IN DATA SET RAM 2 VARIABLES
PROCEDURE PNINT!
ORTHOPHOSPHATE VS TOTAL PHOSPHORUS FOR SELECTED LAKES
OBS
POHTHO
PT
1
2
3
4
5
6
7
a
9
10
11
12
13
14
15
16
17
IB
19
20
21
22
23
.170
.161
.160
.155
.279
.277
.307
.27*
.?20
.204
.193
.147
.138
.273
.230
.281
.088
.097
.119
.117
.119
.304
.317
.260
.245
.243
.239
.283
.292
.326
.318
.275
.245
.245
.261
.247
.377
.314
.319
.224
.216
.237
.237
.236
.*77
.412
-------
PLOTJ
0.33000000
0.24000000
0. 16000000
o.oaoooooo
0.00000000
ORTriOPHQSPHATE VS TOTAL PHOSPHORUS FOR SELECTED LAKES
PLOT OF POPTHO vs PT
A A
A A AAAAA
BAA
A
AAA
A AAABA A
ABEA A9D AACB A AA A
AA A SA A
A A
A
A A AA
A
A
A A
AA
A
A
B C A
A A
-0.02500000 D.07SOOOOO
: A = i oss % B = 2 OBS ETC.
0.1TSOOOOO
0.27500000
PT
OPTHOPHOSPMATE VS TOTAL PHOSPHORUS FOR SELECTED LAK>ES
0.37500000 0.*7SOOOOO
i:lB THURSDAY. OCTOBER 9. 1975
-------
ORTHO
T
N
106
106
OKTHOPHOSPHATE vs TOTAL PHOSPHORUS FOR SELECTED LAKES
SUM MEAN MIN VALUE MAX VALUE CORRECTED SS STANDARD DfV
10.99700000 0.10374528 0.00600000 '0.31700000 1.08141012 0.101*8470
19.64900000 0.18536792 0.04100000 0.47700000 1.27834065 0.11033690
10*
ORTHO
PORTHO
l.oonooo
0.0000
0.921752
0.0001
ORTHOPHOSPHATE VS TOTAL PHOSPHORUS FOR SELECTED LAKES
CORRELATION COEFFICIENTS / PROB > IK I UNDER HOS RHO = 0
PT
0.921752
0.0001
1.000000
0.0000
ORTHOPHOSPHATE VS TOTAL PHOSPHORUS FOR SELECTED LAKES
THURSDAY. OCTOBER 9. 1*75
PROCEDURE REGHI MODEL POKTrtO»PTI
PHOC REGR 8 ORTHOPHOSPHATE VS TOTAL PHOSPHORUS FOR SELECTED LAKES
DATA SET 8 MAW NUMBER OF VARIABLES * 2 NUMBER OF CLASSES * 0
VARIABLES 8 PORTHO HT
»»******»***»***
ORTHOPHOSPHATE VS TOTAL PHOSPHORUS FOR SELECTED LAKES
ANALYSIS OF VARIANCE TABLE . REGRESSION COEFFICIENTS . AND STATISTICS OF FIT FOR DEPENDENT VARIABLE PORTHO
SOURCE OF
REGRESSION 1
ERROR 104
CORRECTED TOTAL 105
SUM OF SOUANES
0.91879534
0.14261479
1.0H141012
SEQUENTIAL SS
0.91879534
T FOR H08B>0
-7.0S762
24.24075
OPTHOPHOSPHATE VS TOTAL PHOSPHORUS FOR SELECTED LAKES
SOURCE
PT
SOURCE
INTERCEPT
FT
OF
1
B VALUES
-0.05340699
0.84778571
MEAN SQUARE F VALUE PHOB > f
0.91879534 587.61393 0.0001
0.00156360
F VALUE
587.61393
PROB > F
0.0001
PWOB > ITI
0.0001
0.0001
PARTIAL SS
0.91879534
STO ERR B
0.00753525
0.03497358
R-SOUARE C.V.
0.84962709 3ft. 11492 %
STD OEV PORTHO MEAN
0.03954243
F VALUE
587.61393
STD B VALUES
0.0
0.92175218
0.103/5
PROB > F
0.0001
19!IB THURSDAY. OCTOBER 9. 1975
-------
TECHNICAL REPORT DATA
(Please read Instructions on the reverse before completing)
REPORT NO.
EPA-600/4-76-057
3. RECIPIENT'S ACCESSIOWNO.
.TITLE AND SUBTITLE
FORMAT FOR ACQUIRING RAPID DATA ANALYSIS CAPABILITIES
OF STORET DATA: Manipulation of National Eutrophica-
tion Survey Water Quality Data
5. REPORT DATE
November 1976
6. PERFORMING ORGANIZATION CODE
7. AUTHOR(S)
J. D. Bliss, M. J. Friedland, J. Hodson
8. PERFORMING ORGANIZATION REPORT NO.
9. PERFORMING ORG\NIZATION NAME AND ADDRESS
Environmental Monitoring and Support Laboratory
Office of Research and Development
U.S. Environmental Protection Agency
Las Vegas, Nevada 89114
10. PROGRAM ELEMENT NO.
1BA608
11. CONTRACT/GRANT NO.
12. SPONSORING AGENCY NAME AND ADDRESS
same as above
13. TYPE OF REPORT AND PERIOD COVERED
Interim 1972 - 1976
14. SPONSORING AGENCY CODE
EPA-ORD, Office of Health
Ecological Effects
and
15. SUPPLEMENTARY NOTES
16. ABSTRACT
As an integral part of the National Eutrophication Survey, a program initiated
in 1972 in response to an Administration commitment to investigate the threat of
accelerated eutrophication to freshwater lakes and reservoirs, the Water and Land
Quality Branch, Monitoring Operations Division, Environmental Monitoring and Support
Laboratory-Las Vegas, has collected water quality information from selected lakes
throughout the contiguous United States. Water quality data are categorized and
stored using a U.S. Environmental Protection Agency central computer-oriented system,
STORET (STOrage and RETrieval).
The data processing and analytical requirements of the Branch were not met by
the program options internal to the STORET system. A need for raw data conversions
in STORET to some other accessible form was recognized. With the cooperation of the
Data Services Branch, Office of Program Management and Support of the same laboratory
a job control language package, "STORET.TO.WYLBUR." was written for conversion of
raw data in STORET into a standardized format for statistical evaluation and manipu-
lation of Survey data. This data analysis scheme may be ideal for general use as
another program option internal to the STORET system.
17.
KEY WORDS AND DOCUMENT ANALYSIS
DESCRIPTORS
b.lDENTIFIERS/OPEN ENDED TERMS
COSATI Field/Group
Data processing
Computer systems programs
Programming languages
'Data retrieval
Water quality
National Eutrophication
Survey
STORET
WYLBUR
Data Manipulation
05B
08H
09B
13B
8. DISTRIBUTION STATEMENT
RELEASE TO PUBLIC
19. SECURITY CLASS (ThisReport)
UNCLASSIFIED
21. NO. OF PAGES
20
20. SECURITY CLASS (Thispage)
UNCLASSIFIED
22. PRICE
EPA Form 2220-1 (9-73)
790- 039-1977
------- |