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