Date:         Wed, 13 Dec 2000 16:10:37 -0800
Reply-To:     Vivian Calderon <Vivian.Calderon@UCOP.EDU>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Vivian Calderon <Vivian.Calderon@UCOP.EDU>
Subject:      Fwd: Re: data structure transformation
Content-Type: text/plain; charset="us-ascii"; format=flowed

Dear List Helpers,

I have multiple records and a single variable, ethnicity.

id      ethnicity
1       A
1       C
1       F
2       D
2       E
3       A
4       A
4       B
5       C
5       D
5       E
5       F

I need to restructure the file so that I have single records with each
ethnicity option as a new variable.
like this:

id      ethA    ethB    ethC    ethD    ethE    ethF
1       A               C                       F
2                               D       E
3       A
4       A       B
5                       C       D       E       F


Any help will be greatly appreciated, this issue comes up a lot.

Thanks.
Vivian