All,

I have data that looks like below.  For each id there may be more than one
value per day.  I want to select a random value for that day for that id.
The end result would hopefully be a matrix with the id as rows, date as
columns and populated by the random hab value.  Thanks to someone on here
(Jim) I know how to do the matrix, but now realize I need to randomly select
some of my values.  All help is appreciated. jm
id, date, loctype, habtype
  50022 1/25/2006 0 6  50022 1/31/2006 0 6  50022 2/8/2006 0 6  50022
2/13/2006 0 6  50022 2/15/2006 0 6  50022 2/24/2006 0 6  50022 3/2/2006 0 6
50022 3/9/2006 0 6  50022 3/16/2006 0 6  50022 3/24/2006 0 6  50022 4/9/2006
0 3  50022 4/18/2006 0 6  50022 4/27/2006 0 3  50022 5/23/2006 1 3  50022
5/23/2006 1 6  50022 5/24/2006 1 3  50022 5/24/2006 1 3  50022 5/24/2006 1 3
50022 5/24/2006 1 3  50022 5/25/2006 1 3  50022 5/25/2006 1 3  50022
5/25/2006 1 3  50022 5/26/2006 1 5  50022 5/26/2006 1 3  50022 5/27/2006 1 5
50022 5/27/2006 1 3  50022 5/28/2006 1 3  50022 5/29/2006 1 3  50022
5/30/2006 1 5  50022 5/30/2006 1 3  50022 5/31/2006 1 3  50022 5/31/2006 1 3
50022 6/1/2006 1 3  50022 6/2/2006 1 3  50022 6/3/2006 1 3  50022 6/4/2006 1
3  50022 6/5/2006 1 3  50022 6/6/2006 1 5  50022 6/6/2006 1 5  50022
6/6/2006 1 5  50022 6/6/2006 1 3  50022 6/6/2006 1 3  50022 6/7/2006 1 5
50022 6/7/2006 1 3  50022 6/7/2006 1 3  50022 6/7/2006 1 3  50022 6/7/2006 1
3  50022 6/8/2006 1 3  50022 6/8/2006 1 3  50022 6/8/2006 1 3  50022
6/9/2006 1 5  50022 6/10/2006 1 3  50022 6/11/2006 1 5

	[[alternative HTML version deleted]]


