Date: Fri, 13 Jan 2006 17:05:38 -0800
Reply-To: David Fickbohm <davefickbohm@YAHOO.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: David Fickbohm <davefickbohm@YAHOO.COM>
Subject: trying to output last 8 rows of each month
Content-Type: text/plain; charset=iso-8859-1
People,
I have a file containing data from feb 2003 until the present.
Each day 8 rows are added to the file.
I want to output 8 rows from the last day of each month from feb 2003 until the present.
The data looks like this
date class level count
020603 1 8z 12
020603 1 16z 13
020603 1 9z 15
020603 1 10z 14
020603 2 8z 20
020603 2 12z 31
020603 2 14x 41
020603 2 15z 44
020703 1 8z 12
020703 1 16z 13
020703 1 9z 15
020703 1 10z 14
020703 2 8z 20
020703 2 12z 31
020703 2 14x 41
020703 2 15z 44
more days of data
022803 1 8z 12
022803 1 16z 13
022803 1 9z 15
022803 1 10z 14
022803 2 8z 20
022803 2 12z 31
022803 2 14x 41
022803 2 15z 44
I want the output to look like:
022803 1 16z 13
022803 1 9z 15
022803 1 10z 14
022803 2 8z 20
022803 2 12z 31
022803 2 14x 41
022803 2 15z 44
all ideas will be greatly appreciated.
Thanks
Dave
Dave Fickbohm
Use Technology to the Fullest
1250 45th st suite 200
Emeryville, CA, 94608
510 594 4151 voice
| 
