LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (April 2008)Back to main SPSSX-L pageJoin or leave SPSSX-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Wed, 30 Apr 2008 09:21:09 +0200
Reply-To:   =?us-ascii?Q?Jerabek=20Jindrich?= <JindraJerabek@seznam.cz>
Sender:   "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:   =?us-ascii?Q?Jerabek=20Jindrich?= <JindraJerabek@seznam.cz>
Subject:   =?us-ascii?Q?Re=3ANested=20Designs=20=2D=20SPSS?=
Comments:   To: =?us-ascii?Q?Deydre=20Teyhen?= <dteyhen@mac.com>
In-Reply-To:   <050E1C87-038F-49F7-BB73-B18435DD1E2A@mac.com>
Content-Type:   text/plain; charset="iso-8859-2"; format=flowed; delsp=yes

Hello,

Try the AGGREGATE command (MENU/DATA/AGGREGATE), it can split your data into groups by the break variable and compute sums of the groups. Something like this (NOT TESTED) could work: AGGREGATE /OUTFILE=* /BREAK=organization /company_sum = SUM(company).

Warning - replaces current dataset, save your work before runing aggregate.

regards Jindra

> ------------ Původní zpráva ------------ > Od: Deydre Teyhen <dteyhen@mac.com> > Předmět: Nested Designs - SPSS > Datum: 30.4.2008 02:45:07 > ---------------------------------------- > > Ladies and Gentlemen: > > I have hopefully what is a quick question. I have a nested design in > which companies 1 through 5 belong to organization A and 6-10 belong > to organization B....and then A and B belong to organization Z (and so > on). Bottom-line - 3 layers of nesting. > > Each company's data is represented as a row of data in SPSS. But, I > what I would like to be able to do is have a row to represent > organizations A through E and rows to represent organizations T > through Z. > > In excel - you could easily have the sum of rows 1 through 5 be > entered into the row designated for organization A, the sum of rows > 6-10 into the row designated for organization B, etc. > > However, I only know how to add/calculate columns in SPSS and not new > additional rows. > > If anyone has any ideas - it would be greatly appreciated. > > Kindest Regards, > Deydre Teyhen > Associate Professor > US Army-Baylor University > > ===================== > To manage your subscription to SPSSX-L, send a message to > LISTSERV@LISTSERV.UGA.EDU (not to SPSSX-L), with no body text except the > command. To leave the list, send the command > SIGNOFF SPSSX-L > For a list of commands to manage subscriptions, send the command > INFO REFCARD > > >

===================== To manage your subscription to SPSSX-L, send a message to LISTSERV@LISTSERV.UGA.EDU (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD


Back to: Top of message | Previous page | Main SPSSX-L page