Date:         Tue, 26 Sep 2006 09:16:43 -0500
Reply-To:     "Marks, Jim" <Jim.Marks@lodgenet.com>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         "Marks, Jim" <Jim.Marks@lodgenet.com>
Subject:      Re: restructuring data
Content-Type: text/plain; charset="US-ASCII"

You need to recode the case id as a numeric before using flip
(Autorecode can be used if there are text characters).

--jim

-----Original Message-----
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of
Martins Liberts
Sent: Tuesday, September 26, 2006 12:28 AM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: Re: restructuring data

Hi,

Try FLIP command. It is simpler than RESTRUCTURE, but should do what you
want.



On 26/09/06, Raffe, Sydelle, SSA <DRaffe@acgov.org> wrote:
> I think this should be a no-brainer but I'm not having any success.
>
> I'm trying to restructure a data set with only 1 variable in it, a
case id. Instead of 3780 records with different values of caseid, I want
1 record with the values of caseid going across. There would be 1 record
with 3780 case id fields.
>
> I'm using restructure to flip this file (running 11.5.1). The result
is that all the new variables are set to numeric and their values set to
sysmis. I tried defining new vars as string but to no avail.
>
> What do I need to do to come up with 1 record with the different case
numbers running across.  Thanks.
>
> Sydelle Raffe, Alameda County Social Services Agency Information
> Services Division
> e:mail:  draffe@acgov.org
> phone: 510-271-9174     fax: 510-271-9107
> If you have a request for information, please submit an ODM request
> form at:
> https://alamedasocialservices.org/staff/support_services/statistics_an
> d_reports/odm/index.cfm
>


--
Martins Liberts
Martins.Liberts@gmail.com