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 (December 2004, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Fri, 17 Dec 2004 09:38:25 -0500
Reply-To:   Jim Groeneveld <jim1stat@YAHOO.CO.UK>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   Jim Groeneveld <jim1stat@YAHOO.CO.UK>
Subject:   Re: reshaping data
Comments:   To: Hayrettin Okut <hokut1@YAHOO.COM>
Content-Type:   text/plain; charset=ISO-8859-1

Hi Hokut,

Sorry, I specified the wrong paths to the macros; they should be:

http://home.hccnet.nl/jim.groeneveld/software/SASmacro/MR2RM.zip http://home.hccnet.nl/jim.groeneveld/software/SASmacro/ChkVar.zip http://home.hccnet.nl/jim.groeneveld/software/SASmacro/PreZeros.zip

Regards - Jim. -- Y. (Jim) Groeneveld, MSc., Biostatistician, Science Team Vitatron B.V., Meander 1051, 6825 MJ Arnhem P.O.Box 5227, 6802 EE Arnhem, the Netherlands Tel: +31/0 26 376 7365, Fax: +31/0 26 376 7305 Jim.Groeneveld_AT_Vitatron.com (replace _AT_ by AT sign) http://www.vitatron.com, http://home.hccnet.nl/jim.groeneveld

On Sun, 12 Dec 2004 02:58:38 -0800, Hayrettin Okut <hokut1@YAHOO.COM> wrote:

>Dear all; > >I have a longitudinal data from 14 periods on 32 individuals. The data file is >listed blow. The variables for each period have been edited in sequence. I need to reshape my data as put each variable of from each period to in a different >column; That is currently data set is; > >data a; > >input no age bt den a b c d e f g; > >cards; > >This data set need be be reformed as ; > >data b; >input no age bt den a1-a14 b1-b14 c1-c14 d1-d14 e1-e14 f1-f14 g1-g14; >cards; >I would be greatly appreciated to get your helps. > > >Best wishes, > >Hokut > >data a; > >input no age bt den a b c d e f g; > >cards; > >21431132 3 1 1 192 35.65 0 . 0 . 280 5 > >21431132 3 1 2 206 37.77 0 . 0 . 370 5 > >21431132 3 1 3 220 39.90 0 2 0 4 120 13 > >21431132 3 1 4 234 41.22 0 5 0 2 124 11 > >21431132 3 1 5 248 42.41 2 5 0 1 210 9 > >21431132 3 1 6 262 43.67 2 5 0 5 247 14 > >21431132 3 1 7 276 44.95 2 8 0 3 196 11 > >21431132 3 1 8 290 47.37 0 6 1 2 82 20 > >21431132 3 1 9 304 50.63 1 2 0 0 255 8 > >21431132 3 1 10 318 53.40 0 3 0 0 140 5 > >21431132 3 1 11 332 55.50 1 5 0 1 285 2 > >21431132 3 1 12 346 57.47 2 4 0 2 . 0 > >21431132 3 1 13 360 59.10 0 1 0 0 454 1 > >. > >. > >. > >. > > > > >_____ > >Do you Yahoo!? >Send holiday email and support a worthy cause. Do good. > > > > > >--------------------------------- >Do you Yahoo!? > The all-new My Yahoo! What will yours do?


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