Date:         Tue, 26 Sep 2006 08:28:27 +0300
Reply-To:     Martins Liberts <martins.liberts@gmail.com>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Martins Liberts <martins.liberts@gmail.com>
Subject:      Re: restructuring data
Comments: To: "Raffe, Sydelle, SSA" <DRaffe@acgov.org>
In-Reply-To:  <D584AFE160F371489F66B181D6F7387902850401@US001EX04V.user.root.acgov.org>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

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_and_reports/odm/index.cfm
>


--
Martins Liberts
Martins.Liberts@gmail.com