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 (September 2005)Back to main SPSSX-L pageJoin or leave SPSSX-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Fri, 9 Sep 2005 11:53:57 -0600
Reply-To:     Matthew Pirritano <>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Matthew Pirritano <>
Subject:      Re: Summary Tables
In-Reply-To:  <000001c5b50d$331b32f0$>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

I think I need to describe the tables a bit more.

I'm creating case summaries. Each table is for a school class. Each row is a participant. The columns are their mean scores on various measure. At the bottom of each class's table I would like to have the total mean for each of the columns. The summarize command partially works. But it consistently creates columns that are too narrow and the total means that it produces have too many decimal places. This is annoying because I'm creating many of these tables. Going through and manually editing each is a pain. So the main things I want to be able to do are specify column width and the number of decimals for the TOTAL MEAN at the bottom of each column.

Is there ANY way to do this outside of custom tables which I do not have.

Thanks Matt

Matthew Pirritano, Ph.D. National Science Foundation Post-Doctoral Fellow College of Education Department of Individual, Family & Community Education MSC05 3040 1 University of New Mexico Albuquerque, NM 87131-0001 Telephone (505)277-7115 FAX (505)277-8361

la volta statistics wrote:

>Hi Matt >the code Vishal refers to is for costom tables only, that are part of SPSS >since (I think) version 11. >For formating your numbers in the classic table command use somthing like >the following code snip. > >DATA LIST LIST /Gender YourVar. >BEGIN DATA >1 11 >2 22 >1 33 >2 11 >1 44 >2 55 >1 44 >2 33 >END DATA. > >* with various decimal places in differnt rows. >TABLES > /OBSERVATION= YourVar > /TABLE= YourVar > BY GENDER > /title 'Your title' > /STATISTICS > count(YourVar( F5.0 )'N.') > mean(YourVar(F5.2 )'Mean') > median(YourVar(F5.1 )'Median') > stddev(YourVar(F5.3 )'Standart deviation'). > > >* with five decimal places for each row. >TABLES > /OBSERVATION= YourVar > /TABLE= YourVar > BY GENDER > /title 'Your title' > /STATISTICS > count(YourVar( F8.5 )'N.') > mean(YourVar(F8.5 )'Mean') > median(YourVar(F8.5 )'Median') > stddev(YourVar(F8.5)'Standart deviation'). > > >Hope this helps. >Christian Schmidhauser > >-----Ursprüngliche Nachricht----- >Von: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU]Im Auftrag von >Matthew Pirritano >Gesendet: Freitag, 9. September 2005 00:40 >An: SPSSX-L@LISTSERV.UGA.EDU >Betreff: Re: Summary Tables > > >Vishal, > >That doesn't seem to be working. It doesn't like the bracket. Says >that it is unexpected text. > >I am trying to do this in the summary function. I'm creating a large >number of tables and it would be a great time saver if I didn't have to >go and manually edit all of them. > >Any other ideas? > >Thanks >Matt > >Matthew Pirritano, Ph.D. >National Science Foundation Post-Doctoral Fellow >College of Education >Department of Individual, Family & Community Education >MSC05 3040 >1 University of New Mexico >Albuquerque, NM 87131-0001 >Telephone (505)277-7115 >FAX (505)277-8361 > > > > >Vishal Dave wrote: > > > >>Matt, >> >>You can specify the format of summary variable by adding []. For >>example, summary scale variable v1 can be summarized in the custom table >>with required format as : >> >>/TABLE V1 [MEAN F4.0] BY V2 [C] >> >>Hope this helps, >>Vishal. >> >> >> >>-----Original Message----- >>From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of >>Matthew Pirritano >>Sent: Thursday, September 08, 2005 11:13 AM >>To: SPSSX-L@LISTSERV.UGA.EDU >>Subject: Summary Tables >> >>Hello all! >> >>Is there a way to specify the format of Summary Tables? The summary >>tables are giving me data with more decimal places than I want for some >>information and some columns narrower than I'd like. Is there a way to >>specify this? The summary table syntax doesn't seem to give you the >>ability to specify these formats. >> >>thanks for the help, >> >>matt >> >> >>Matthew Pirritano, Ph.D. >>National Science Foundation Post-Doctoral Fellow >>College of Education >>Department of Individual, Family & Community Education >>MSC05 3040 >>1 University of New Mexico >>Albuquerque, NM 87131-0001 >>Telephone (505)277-7115 >>FAX (505)277-8361 >> >> >> >> > > >

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