Date: Thu, 3 Sep 1998 14:09:07 -0500
Sender: "SPSSX(r) Discussion" <SPSSX-L@UGA.CC.UGA.EDU>
From: Edward Tverdek <etverdek@SPSS.COM>
Organization: SPSS Inc.
Subject: Re: reorganizing data sets & vectors/arrays
Content-Type: text/plain; charset=us-ascii
I responded to this yesterday but still don't see it posted, so I'm
responding again. Forgive me the the first makes it through and this
I asked our webmaster to post to the SPSS Base FAQ sample jobs which
illustrate both of the procedures that Frank describes. They're
already up; you can find them under the heading "Restructuring the
case base of an SPSS file" at
I hope this helps,
SPSS Technical Support
Frank H. Jurden wrote:
> several listers have posted questions regarding the problem of
> transposing data *by case* in spss. for the uninitiated, this problem
> is one of transforming the "traditional data set" (consisting of a
> single record for each respondent and multple columns for the variables)
> into one in which the respondents are "stacked" (viz., the same
> respondent may occupy multiple rows). so if the original data set
> contains N cases and p variables, the transposed data set will contain N
> x p rows (and some number of columns).
> on occassion, the opposite is required (taking multiple rows for each
> respondent and "stringing them out" across multiple columns.
> althought spss does have a transpose function, it can not be done by
> case (btw, sas does).
> i have faced this problem several times, and it took quite a lot of
> digging and debugging to get the code to work (sorry folks - no menu
> options here!). it involves a combination of the "input program" and
> "loop - end loop" syntax (copies of which i can post if anyone wants).
> i'd like to see spss incorporate this into their FAQ or on their