```Date: Wed, 30 Apr 2008 09:21:09 +0200 Reply-To: =?us-ascii?Q?Jerabek=20Jindrich?= Sender: "SPSSX(r) Discussion" From: =?us-ascii?Q?Jerabek=20Jindrich?= Subject: =?us-ascii?Q?Re=3ANested=20Designs=20=2D=20SPSS?= Comments: To: =?us-ascii?Q?Deydre=20Teyhen?= 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 > 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