Date:         Fri, 4 Nov 2005 12:45:50 -0500
Reply-To:     "Tonkovich, Mike" <Mike.Tonkovich@DNR.STATE.OH.US>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Tonkovich, Mike" <Mike.Tonkovich@DNR.STATE.OH.US>
Subject:      Code to read a text file
Content-Type: text/plain; charset="US-ASCII"

Help Please! I've got the following file sitting in an Excel
spreadsheet.  The file contains 30 fields and 450 records.  Each
"record" contains 5 rows of data.  In the example below, "Adams"

Adams   1977    1978    1979    1980    1981    1982
Fawns           2       1       5       10      33      34
Yearlings       60      63      72      94      119     140
Subadults       24      22      23      36      42      49
Adults          13      13      14      15      15      22

is the county name and "Fawns, Yearlings, Subadults, and Adults" are age
classes.  I would like to create a SAS data set that looks like the
following:

county         fawn     yearling        subadult        adult   year

Adams   2       60              24              13      1977
Adams   1       63              22              13      1978

Etc...

Can anyone provide some suggestions on how I might accomplish this?  I
would really appreciate your help.

Mike

Michael J. Tonkovich, Ph.D.
Wildlife Research Biologist
ODNR, Division of Wildlife
360 E. State St.
Athens, OH  45701
v(740)589.9920 f(740)589.9925
mike.tonkovich@dnr.state.oh.us