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 (February 2008, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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>
Subject:      data manipulation help
Comments: To:
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

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