|
Dear list,
I use SPSS 15. I noticed that I often select tables in my SPSS output to decrease the decimal places from 3 to 2. It would be nice if I could just tell SPSS in advance that I would like two decimal places rather than three. Is this a setting (as in, using syntax like 'SET DEFAULTDECIMALPLACESINTABLES 2'), or would this require more complicated procedures (Python)? Thank you in advance and kind regards, Gjalt-Jorn Peters ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (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 |
|
Decimal formatting depends upon a number of different factors:
1) the statistic being displayed 2) the format of the variable being summarized. 3) the specific table 4) some procedures provide explicit control over decimal places. CTABLES, TABLES, and REPORT provide explicit control. SPSS produces thousands of different table types. Please be specific about which tables from which procedures provide too many decimal positions for your needs. -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Peters Gj (PSYCHOLOGY) Sent: Thursday, October 16, 2008 8:42 AM To: [hidden email] Subject: Default number of decimal places in SPSS tables Dear list, I use SPSS 15. I noticed that I often select tables in my SPSS output to decrease the decimal places from 3 to 2. It would be nice if I could just tell SPSS in advance that I would like two decimal places rather than three. Is this a setting (as in, using syntax like 'SET DEFAULTDECIMALPLACESINTABLES 2'), or would this require more complicated procedures (Python)? Thank you in advance and kind regards, Gjalt-Jorn Peters ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (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 [hidden email] (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 |
|
Dear ViAnn & list,
Thank you for your swift reply! Although this 'problem' (let's call it a minor inconvenience) is not related to any table in specific, at the moment, I'm mainly working with correlation tables (including descriptives) and linear regression analyses output. So, the statistics I am looking at now are r's, means, standard deviations (for the correlations and descriptives), beta's, R^2's, R^2 changes, and F's (for the regression analyses). All variables I use as input have the default FORMAT (i.e. width 8, decimals 2). So, it looks like there's no easy way out. Ah well. I can do a bit more clicking then :-) Kind regards, Gjalt-Jorn -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of ViAnn Beadle Sent: donderdag 16 oktober 2008 16:57 To: [hidden email] Subject: Re: Default number of decimal places in SPSS tables Decimal formatting depends upon a number of different factors: 1) the statistic being displayed 2) the format of the variable being summarized. 3) the specific table 4) some procedures provide explicit control over decimal places. CTABLES, TABLES, and REPORT provide explicit control. SPSS produces thousands of different table types. Please be specific about which tables from which procedures provide too many decimal positions for your needs. -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Peters Gj (PSYCHOLOGY) Sent: Thursday, October 16, 2008 8:42 AM To: [hidden email] Subject: Default number of decimal places in SPSS tables Dear list, I use SPSS 15. I noticed that I often select tables in my SPSS output to decrease the decimal places from 3 to 2. It would be nice if I could just tell SPSS in advance that I would like two decimal places rather than three. Is this a setting (as in, using syntax like 'SET DEFAULTDECIMALPLACESINTABLES 2'), or would this require more complicated procedures (Python)? Thank you in advance and kind regards, Gjalt-Jorn Peters ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (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 [hidden email] (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 [hidden email] (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 |
|
There is an easy way around this. From the GUI (point and click menu):
Data Define variable properties (choose the variable(s) you need changed) Type Width (change if needed) Decimals (change to the number you need) Neda -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Peters Gj (PSYCHOLOGY) Sent: Thursday, October 16, 2008 11:07 AM To: [hidden email] Subject: Re: Default number of decimal places in SPSS tables Dear ViAnn & list, Thank you for your swift reply! Although this 'problem' (let's call it a minor inconvenience) is not related to any table in specific, at the moment, I'm mainly working with correlation tables (including descriptives) and linear regression analyses output. So, the statistics I am looking at now are r's, means, standard deviations (for the correlations and descriptives), beta's, R^2's, R^2 changes, and F's (for the regression analyses). All variables I use as input have the default FORMAT (i.e. width 8, decimals 2). So, it looks like there's no easy way out. Ah well. I can do a bit more clicking then :-) Kind regards, Gjalt-Jorn -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of ViAnn Beadle Sent: donderdag 16 oktober 2008 16:57 To: [hidden email] Subject: Re: Default number of decimal places in SPSS tables Decimal formatting depends upon a number of different factors: 1) the statistic being displayed 2) the format of the variable being summarized. 3) the specific table 4) some procedures provide explicit control over decimal places. CTABLES, TABLES, and REPORT provide explicit control. SPSS produces thousands of different table types. Please be specific about which tables from which procedures provide too many decimal positions for your needs. -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Peters Gj (PSYCHOLOGY) Sent: Thursday, October 16, 2008 8:42 AM To: [hidden email] Subject: Default number of decimal places in SPSS tables Dear list, I use SPSS 15. I noticed that I often select tables in my SPSS output to decrease the decimal places from 3 to 2. It would be nice if I could just tell SPSS in advance that I would like two decimal places rather than three. Is this a setting (as in, using syntax like 'SET DEFAULTDECIMALPLACESINTABLES 2'), or would this require more complicated procedures (Python)? Thank you in advance and kind regards, Gjalt-Jorn Peters ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (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 [hidden email] (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 [hidden email] (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 [hidden email] (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 |
|
In reply to this post by Peters Gj (PSYCHOLOGY)
As ViAnn has pointed out, the actual format in a pivot table cell depends on the type of statistic and, in some cases, the format of the underlying variable.
With version 15 or earlier, you could write a SaxBasic autoscript to change the cell decimals for a specific type of table. With version 16, you could write a general, base Basic or Python autoscript to change the cell decimals for any table (taking into account the type, if desired). With version 17, you could use the SPSS MODIFY TABLES extension command, specifying the customstylefunctions.SetTwoDecimalPlaces function. You can select the table types, particular columns and various other things. HTH, Jon Peck -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Peters Gj (PSYCHOLOGY) Sent: Thursday, October 16, 2008 8:42 AM To: [hidden email] Subject: [SPSSX-L] Default number of decimal places in SPSS tables Dear list, I use SPSS 15. I noticed that I often select tables in my SPSS output to decrease the decimal places from 3 to 2. It would be nice if I could just tell SPSS in advance that I would like two decimal places rather than three. Is this a setting (as in, using syntax like 'SET DEFAULTDECIMALPLACESINTABLES 2'), or would this require more complicated procedures (Python)? Thank you in advance and kind regards, Gjalt-Jorn Peters ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (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 [hidden email] (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 |
|
Alternatively, unless you really have variables with F8.2, you could set
your default to F8 to get fewer decimals most places or f8.3 etc to get more in most places. Or you could use a FORMATS statement. Art Kendall Social Research Consultants Peck, Jon wrote: > As ViAnn has pointed out, the actual format in a pivot table cell depends on the type of statistic and, in some cases, the format of the underlying variable. > > With version 15 or earlier, you could write a SaxBasic autoscript to change the cell decimals for a specific type of table. > > With version 16, you could write a general, base Basic or Python autoscript to change the cell decimals for any table (taking into account the type, if desired). > > With version 17, you could use the SPSS MODIFY TABLES extension command, specifying the customstylefunctions.SetTwoDecimalPlaces function. You can select the table types, particular columns and various other things. > > HTH, > Jon Peck > > -----Original Message----- > From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Peters Gj (PSYCHOLOGY) > Sent: Thursday, October 16, 2008 8:42 AM > To: [hidden email] > Subject: [SPSSX-L] Default number of decimal places in SPSS tables > > Dear list, > > I use SPSS 15. I noticed that I often select tables in my SPSS output to > decrease the decimal places from 3 to 2. It would be nice if I could > just tell SPSS in advance that I would like two decimal places rather > than three. Is this a setting (as in, using syntax like 'SET > DEFAULTDECIMALPLACESINTABLES 2'), or would this require more complicated > procedures (Python)? > Thank you in advance and kind regards, > > Gjalt-Jorn Peters > > ===================== > To manage your subscription to SPSSX-L, send a message to > [hidden email] (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 > [hidden email] (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 [hidden email] (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
Art Kendall
Social Research Consultants |
|
Dear Art, Jon, & list,
Thank you for your replies. I learned a lot, but I don't think the easy (or rather, quick and dirty :-)) solution I had hoped for exists . . . Even for F1.0 variables, the correlations I get have three decimals, so this would have to be done the hard way, and no matter how much I would want to learn to master that way, it will have to wait a bit for now. I will just have to do a bit more clicking :-) Thank you for your replies everybody! Have a good weekend, kind regards, Gjalt-Jorn -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Art Kendall Sent: donderdag 16 oktober 2008 22:27 To: [hidden email] Subject: Re: Default number of decimal places in SPSS tables Alternatively, unless you really have variables with F8.2, you could set your default to F8 to get fewer decimals most places or f8.3 etc to get more in most places. Or you could use a FORMATS statement. Art Kendall Social Research Consultants Peck, Jon wrote: > As ViAnn has pointed out, the actual format in a pivot table cell depends on the type of statistic and, in some cases, the format of the underlying variable. > > With version 15 or earlier, you could write a SaxBasic autoscript to change the cell decimals for a specific type of table. > > With version 16, you could write a general, base Basic or Python autoscript to change the cell decimals for any table (taking into account the type, if desired). > > With version 17, you could use the SPSS MODIFY TABLES extension command, specifying the customstylefunctions.SetTwoDecimalPlaces function. You can select the table types, particular columns and various other things. > > HTH, > Jon Peck > > -----Original Message----- > From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Peters Gj (PSYCHOLOGY) > Sent: Thursday, October 16, 2008 8:42 AM > To: [hidden email] > Subject: [SPSSX-L] Default number of decimal places in SPSS tables > > Dear list, > > I use SPSS 15. I noticed that I often select tables in my SPSS output to > decrease the decimal places from 3 to 2. It would be nice if I could > just tell SPSS in advance that I would like two decimal places rather > than three. Is this a setting (as in, using syntax like 'SET > DEFAULTDECIMALPLACESINTABLES 2'), or would this require more complicated > procedures (Python)? > Thank you in advance and kind regards, > > Gjalt-Jorn Peters > > ===================== > To manage your subscription to SPSSX-L, send a message to > [hidden email] (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 > [hidden email] (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 [hidden email] (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 [hidden email] (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 |
|
If you change the formats the f1.0 to f1 it will still reduce the number
of fields where editing decimal places is necessary. However, CTABLES will give you control over the format of output. Using Table Looks can help with the appearance of tables. I don't recall whether LOOKS include setting decimal places but since you can control column widths, you might be able to make the cell too narrow to allow decimal point and decimals. Art Peters Gj (PSYCHOLOGY) wrote: > Dear Art, Jon, & list, > > Thank you for your replies. > > I learned a lot, but I don't think the easy (or rather, quick and dirty > :-)) solution I had hoped for exists . . . Even for F1.0 variables, the > correlations I get have three decimals, so this would have to be done > the hard way, and no matter how much I would want to learn to master > that way, it will have to wait a bit for now. I will just have to do a > bit more clicking :-) > > Thank you for your replies everybody! > > Have a good weekend, kind regards, > > Gjalt-Jorn > > -----Original Message----- > From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of > Art Kendall > Sent: donderdag 16 oktober 2008 22:27 > To: [hidden email] > Subject: Re: Default number of decimal places in SPSS tables > > Alternatively, unless you really have variables with F8.2, you could set > your default to F8 to get fewer decimals most places or f8.3 etc to get > more in most places. > > Or you could use a FORMATS statement. > > Art Kendall > Social Research Consultants > > Peck, Jon wrote: > >> As ViAnn has pointed out, the actual format in a pivot table cell >> > depends on the type of statistic and, in some cases, the format of the > underlying variable. > >> With version 15 or earlier, you could write a SaxBasic autoscript to >> > change the cell decimals for a specific type of table. > >> With version 16, you could write a general, base Basic or Python >> > autoscript to change the cell decimals for any table (taking into > account the type, if desired). > >> With version 17, you could use the SPSS MODIFY TABLES extension >> > command, specifying the customstylefunctions.SetTwoDecimalPlaces > function. You can select the table types, particular columns and > various other things. > >> HTH, >> Jon Peck >> >> -----Original Message----- >> From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf >> > Of Peters Gj (PSYCHOLOGY) > >> Sent: Thursday, October 16, 2008 8:42 AM >> To: [hidden email] >> Subject: [SPSSX-L] Default number of decimal places in SPSS tables >> >> Dear list, >> >> I use SPSS 15. I noticed that I often select tables in my SPSS output >> > to > >> decrease the decimal places from 3 to 2. It would be nice if I could >> just tell SPSS in advance that I would like two decimal places rather >> than three. Is this a setting (as in, using syntax like 'SET >> DEFAULTDECIMALPLACESINTABLES 2'), or would this require more >> > complicated > >> procedures (Python)? >> Thank you in advance and kind regards, >> >> Gjalt-Jorn Peters >> >> ===================== >> To manage your subscription to SPSSX-L, send a message to >> [hidden email] (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 >> [hidden email] (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 > [hidden email] (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 > [hidden email] (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 [hidden email] (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
Art Kendall
Social Research Consultants |
|
In reply to this post by Peters Gj (PSYCHOLOGY)
Another way might be to use OMS to select the coefficients you need and get
them into a new .sav-file. This new .sav-file can then be exported or saved as an .xls-file. In Excel it is then quite easy to adjust the number of decimals. S.Lemola Am 17.10.2008 11:48 Uhr schrieb "Peters Gj (PSYCHOLOGY)" unter <[hidden email]>: > Dear Art, Jon, & list, > > Thank you for your replies. > > I learned a lot, but I don't think the easy (or rather, quick and dirty > :-)) solution I had hoped for exists . . . Even for F1.0 variables, the > correlations I get have three decimals, so this would have to be done > the hard way, and no matter how much I would want to learn to master > that way, it will have to wait a bit for now. I will just have to do a > bit more clicking :-) > > Thank you for your replies everybody! > > Have a good weekend, kind regards, > > Gjalt-Jorn > > -----Original Message----- > From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of > Art Kendall > Sent: donderdag 16 oktober 2008 22:27 > To: [hidden email] > Subject: Re: Default number of decimal places in SPSS tables > > Alternatively, unless you really have variables with F8.2, you could set > your default to F8 to get fewer decimals most places or f8.3 etc to get > more in most places. > > Or you could use a FORMATS statement. > > Art Kendall > Social Research Consultants > > Peck, Jon wrote: >> As ViAnn has pointed out, the actual format in a pivot table cell > depends on the type of statistic and, in some cases, the format of the > underlying variable. >> >> With version 15 or earlier, you could write a SaxBasic autoscript to > change the cell decimals for a specific type of table. >> >> With version 16, you could write a general, base Basic or Python > autoscript to change the cell decimals for any table (taking into > account the type, if desired). >> >> With version 17, you could use the SPSS MODIFY TABLES extension > command, specifying the customstylefunctions.SetTwoDecimalPlaces > function. You can select the table types, particular columns and > various other things. >> >> HTH, >> Jon Peck >> >> -----Original Message----- >> From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf > Of Peters Gj (PSYCHOLOGY) >> Sent: Thursday, October 16, 2008 8:42 AM >> To: [hidden email] >> Subject: [SPSSX-L] Default number of decimal places in SPSS tables >> >> Dear list, >> >> I use SPSS 15. I noticed that I often select tables in my SPSS output > to >> decrease the decimal places from 3 to 2. It would be nice if I could >> just tell SPSS in advance that I would like two decimal places rather >> than three. Is this a setting (as in, using syntax like 'SET >> DEFAULTDECIMALPLACESINTABLES 2'), or would this require more > complicated >> procedures (Python)? >> Thank you in advance and kind regards, >> >> Gjalt-Jorn Peters >> >> ===================== >> To manage your subscription to SPSSX-L, send a message to >> [hidden email] (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 >> [hidden email] (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 > [hidden email] (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 > [hidden email] (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 [hidden email] (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 |
| Free forum by Nabble | Edit this page |
