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