Date: Mon, 14 Apr 1997 09:39:20 -0500
Reply-To: Yuxian Jiang <joan.jiang.10@ND.EDU>
Sender: "SPSSX(r) Discussion" <SPSSX-L@UGA.CC.UGA.EDU>
From: Yuxian Jiang <joan.jiang.10@ND.EDU>
Subject: Re: transforming data file
Content-Type: text/plain; charset="us-ascii"
The file 'out' is saved on your diskette. You may use 'Find File' to find
it. It is a tex file. You could do all kinds of things you would do to a
text file such as importing it into Excel. --Joan
>I had posted a question on how to change a data file from individuls
>to families, or rearranging multiple records into one record. Several
>people responded, showing how to use vectors and aggregates. Many
>thanks to you!
>However, in using spss for windows, I run into a problem in that
>after I do the aggregates, nothing seems to happen. That is, I
>seem to still see the original data set, untransformed, and I dont
>know where the new transformed data set is. One person did say to
>use 'write', but even with that, I don't seem to be able to access
>the transformed data set. I am not too familiar with spss for windows,
>so I guess there is something more I should be doing to get to this
>transformed data set. What?
>In general, I read in the data set, do some computes, then the
>aggregate. In one example (part shown below), I write an outfile,
>but then how do I get to the outfile?
>nys dept of health
>VECTOR VPID(9A3) VFID(9A4) VOTH(9A4).
> /VPID1 TO VPID9=MAX(VPID1 TO VPID9)
> /VFID1 TO VFID9=MAX(VFID1 TO VFID9)
> /VOTH1 TO VOTH9=MAX(VOTH1 TO VOTH9).
> /VPID1 VFID1 VOTH1 VPID2 VFID2 VOTH2 VPID3 VFID3 VOTH3
> VPID4 VFID4 VOTH4 VPID5 VFID5 VOTH5 VPID6 VFID6 VOTH6
> VPID7 VFID7 VOTH7 VPID8 VFID8 VOTH8 VPID9 VFID9 VOTH9.