LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (March 2011, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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


Back to: Top of message | Previous page | Main SAS-L page