Bob Mehew
Well-known member
Hi
Can someone help with what probably is producing a small sorting program. I have an array of 2 column by 2600 plus rows reflecting the age and length of membership of a large sample of BCA?s membership. The data has been sorted by ?age? and then ?years member?. What I am after is a program which will take this data and produce a new array with columns of ?years members? and rows of ?age? and insert at each cell the number of members matching that combination. So for example, I have five rows of data representing six year olds who have joined and have been members for 1, 2, 5, 5 & 7 years respectively. What I am after is an output showing
?- 1 2 3 4 5 6 7 8
5
6 1 1 0 0 2 0 1 0
7
8
At 2600 + rows, I am not going to do it by hand. And my programming has driven me mad since it fails to finish presumably because my loop structure goes off to infinity.
Please PM me if you think you can help.
Can someone help with what probably is producing a small sorting program. I have an array of 2 column by 2600 plus rows reflecting the age and length of membership of a large sample of BCA?s membership. The data has been sorted by ?age? and then ?years member?. What I am after is a program which will take this data and produce a new array with columns of ?years members? and rows of ?age? and insert at each cell the number of members matching that combination. So for example, I have five rows of data representing six year olds who have joined and have been members for 1, 2, 5, 5 & 7 years respectively. What I am after is an output showing
?- 1 2 3 4 5 6 7 8
5
6 1 1 0 0 2 0 1 0
7
8
At 2600 + rows, I am not going to do it by hand. And my programming has driven me mad since it fails to finish presumably because my loop structure goes off to infinity.
Please PM me if you think you can help.