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>
Content-Type: text/plain; charset="iso-8859-2"; format=flowed; delsp=yes
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:
/company_sum = SUM(company).
Warning - replaces current dataset, save your work before runing aggregate.
> ------------ Původní zpráva ------------
> Od: Deydre Teyhen <firstname.lastname@example.org>
> 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
For a list of commands to manage subscriptions, send the command