Date:         Mon, 11 Feb 2008 12:03:59 -0800
Reply-To:     george <cal.yawn@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         george <cal.yawn@GMAIL.COM>
Organization: http://groups.google.com
Subject:      data manipulation help
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

hi all:

I have data in this format:

id typ1 dt1 dt2 chdt typ2

007 2 12Dec2007 24Dec2007
008 1 01Jan2008 18Jan2008 05Jan2008  2
008 1 01Jan2008 18Jan2008 15Jan2008  3
008 1 01Jan2008 18Jan2008 16Jan2008  1
009 3 12Jan2008 21Jan2008

need it in this format

007 2 12Dec2007  24Dec2007
008 1  01Jan2008  05Jan2008
008 2  05Jan2008 15Jan2008
008 3 15Jan2008  16Jan2008
008 1 16Jan2008  18Jan2008
009 3 12Jan2008  21Jan2008

basically need to create another record instead of having a "chdt" &
"typ2" variable ...only when there is a "chdt" ... dt2 of original
record gets chdt..
dt1 of new record also gets chdt..

hope i am not too confusing...
any help would be welcome..

regards
george