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?