Date:         Thu, 24 Apr 1997 10:11:24 -0700
Reply-To:     jarcuri@eastbridge.com
Sender:       "SPSSX(r) Discussion" <SPSSX-L@UGA.CC.UGA.EDU>
From:         Joe Arcuri <jarcuri@EASTBRIDGE.COM>
Subject:      Re: disaggregating data
Comments: To: gsw8@COLUMBIA.EDU
Content-Type: text/plain; charset=us-ascii

Gregg,
it sounds like the easiest way would be with multiple save out commands
and a add files.
 
compute time=1.
save outfile 'time1.sav' /keep=seq1 time1 /rename=(time1=outcome).
compute time=2.
save outfile 'time2.sav' /keep=seq1 time2 /rename=(time2=outcome).
compute time=3.
save outfile 'time3.sav' /keep=seq1 time3 /rename=(time3=outcome).
add files file='time1.sav'
 /file='time2.sav'
 /file='time3.sav'.
 
There may be other ways but this is the first that comes to mind for me.
 
good luck,
Joe Arcuri
 
 
 
Gregg S Weinberg wrote:
>
> I'm wondering if anyone can help me with the following problem I'm having.
> I'm using SPSS for Windows 6.1 and I have a data set in which I have
> multiple observations on a single line for each record e.g
>
> seq1    time1   time2   time3
> 1001    1       0       1
> 1002    1       1       1
>
> and now i want each of the observations to be its own record e.g.
>
> seq1    outcome time
> 1001    1       1
> 1001    0       2
> 1001    1       3
> 1002    1       1
> 1002    1       2
> 1002    1       3
>
> i have looked at the repeating data discussion in the manual but im
> unclear on how to apply this to the already existing spss data set.
>
> Gregg