Date:         Fri, 15 Aug 2003 09:32:31 -0400
Reply-To:     Don <donmazais@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Don <donmazais@HOTMAIL.COM>
Subject:      Re: shifting variables for selected rows

thanks for your input

I guess i missed very important detail:

only the first empty variables should be shifted

modified example (class 2 & 3):

Class name1 dob1 name2 dob2 name3 dob3 name4 dob4
1     John   123  Josh 456  Scott  568 Gerard  548
2     Karl    .   Ush   56  Hu      .  Adolf   456
3     Mae     .   Sue   .   Matt   845 Jeff     .



Resulting data set would look like:

Class name1 dob1 name2 dob2 name3 dob3 name4 dob4
1     John   123  Josh  456 Scott 568  Gerard  548
2     Ush    456  Hu     .  Adolf 456    .      .
3     Matt   845  Jeff   .   .     .     .      .