| Abstract: | Reliable estimates of abundance and survival, gained through mark-recapture studies, are necessary to better understand how to manage and restore lake trout populations in the Great Lakes. Working with a 24-year data set from a mark-recapture study conducted in Lake Superior, we attempted to disclose information on tag shedding by examining recaptures of double-tagged fish. The data set consisted of 64,288 observations on fish which had been marked with one or more tags; a subset of these fish had been marked with two tags at initial capture. Although DATA and PROC statements could be used to obtain some of the information we sought, these statements could not be used to extract a complete set of results from the double-tagging experiments. We therefore used SQL processing to create three tables representing the same information but in a fully normalized relational structure. In addition, we created indices to efficiently examine complex relationships among the individual capture records. This approach allowed us to obtain all the information necessary to estimate tag retention through subsequent modeling. We believe that our success with SQL was due in large part to its ability to simultaneosly scan the same table more than once and to permit consideration of other tables in sub-queries. |
| Genre: | Book chapter |
| ProdID: | 81444 |
| Citation Author: | Fabrizio, Mary C.; Nelson, Scott N. |
| Citation Contributing Office: | Great Lakes Science Center |
| Citation Datum: | |
| Citation Day: | |
| Citation Edition: | |
| Citation Editor: | |
| Citation End Page: | 243 |
| Citation Issue: | |
| Citation Keywords: | |
| Citation Language: | English |
| Citation Larger Work Title: | Client/server computing with the SAS system: tips and techniques |
| Citation LatN: | |
| Citation LatS: | |
| Citation LonE: | |
| Citation LonW: | |
| Citation Month: | |
| Citation No Pagination: | |
| Citation Number Of Pages: | |
| Citation Online Only Flag: | |
| Citation Phsyical Description: | p. 238-243 |
| Citation Projection: | |
| Citation Public Comments: | Also published in: Proceedings of the Nineteenth Annual SAS users Group International ConferenceOut-of-print |
| Citation Publisher: | SAS Institute |
| Citation Series: | |
| Citation Series Code: | |
| Citation Series Number: | |
| Citation Search Results Text: | Find the fish: using PROC SQL to build a relational database; 1995; Book chapter; BOOK; Client/server computing with the SAS system: tips and techniques; Fabrizio, Mary C.; Nelson, Scott N. |
| Citation Start Page: | 238 |
| Citation Volume: | |
| Citation Year: | 1995 |
| Type: | citation/reference |
| Text: | Find the fish: using PROC SQL to build a relational database; 1995; Book chapter; BOOK; Client/server computing with the SAS system: tips and techniques; Fabrizio, Mary C.; Nelson, Scott N. |
| URL (THUMBNAIL): | http://pubs.er.usgs.gov/thumbnails/outside_thumb.jpg |
| Date Other: | Sun, 1 Jan 1995 00:00 -0600 |
| Publisher: | SAS Institute |
