**Date:** Mon, 14 Mar 2011 04:11:42 -0400
**Reply-To:** Bill Behrens <mngorgeman@GMAIL.COM>
**Sender:** "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
**From:** Bill Behrens <mngorgeman@GMAIL.COM>
**Subject:** Unbalanced files
Hi All,

I have been thinking about this problem for some time but couldn't come up
with an easier solution. I have the following data example:

1 1 5000
2 4 6000
3 8 7000
4 11 4000
5
6
7
8
9
10
11
12
13

So first column can be thought of as ID column. Second column is random
numbers from the first column, sorted. I need the following

1 5000
2 5000
3 5000
4 6000
5 6000
6 6000
7 6000
8 7000
9 7000
10 7000
11 4000
12 4000
13 4000

In other words the numbers on the third column needs to be repeated until
the next row number on the second column. I can repeat the second column
the way I want but I can't put the numbers from third column and repeat
them. Any help would be greatly appreciated.

Bill