Date:         Sun, 7 Dec 2008 23:34:31 -0800
Reply-To:     kondal717@GMAIL.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         kondal717@GMAIL.COM
Organization: http://groups.google.com
Subject:      data magement
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

hi all
i have  following dataset

  var1            var2              var3               var4
  1234
                   >abcd
                     efgh
                     ijk
                                      >a1b2c
                                        3d4e
                                                            >aaaa
                                                              123
4567
                   >kmln
                     opq
                                      >k1m1
                                        p1q2
                                         ab

                                                           >gggg
                                                              134

How get following dataset  based on above  dataset

  var1            var2              var3               var4
  1234          >abcd            >a1b2c          >aaaa
                     efgh               3d4e              123
                     ijk
  4567        >kmln           >k1m1            >gggg
                   opq               p1q2               134
                                       ab


Thanks