Rounding off values in the SPSS 14.0 output

[ajay atluri]

Hi team,

We are working on SPSS 14 in our office.


We have following syntax for the know there is a function with the follwoing
sample syntax:


*ctab*

*/table (Var_A+ Var_B) [colpct f4.0 ]  by Var_XYZ*

*/comparetest type=prop alpha=0.05 adjust=none origin =column.*


By this custom table we will get an output without any decimal values. But,
if we paste or export the same into excel they decimal values are
displayed.But we would like not to happen that.

 Is there any way which allows us to roundoff the *output* itself when we
are using the custom tables.  The reason is that we would like to save the
values into a separate data file for further analysis purposes.


Syntax is appreciated.....

Thanks and regards,
Ajay Atluri

=====================
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

[Dennis Deck]

Your CTABLE code is displaying the results rounded off (F4.0) but the
underlying decimal values were copied to Excel. Just change the format
in Excel to match (ie to display integers).

Dennis Deck, PhD
RMC Research Corporation
111 SW Columbia Street, Suite 1200
Portland, Oregon 97201-5843
voice: 503-223-8248 x715
voice: 800-788-1887 x715
fax:  [phone]
[hidden email]

-----Original Message-----
From: ajay atluri [mailto:[hidden email]]
Sent: Thursday, April 17, 2008 2:48 AM
Subject: Rounding off values in the SPSS 14.0 output

Hi team,

We are working on SPSS 14 in our office.


We have following syntax for the know there is a function with the
follwoing sample syntax:


*ctab*

*/table (Var_A+ Var_B) [colpct f4.0 ]  by Var_XYZ*

*/comparetest type=prop alpha=0.05 adjust=none origin =column.*


By this custom table we will get an output without any decimal values.
But, if we paste or export the same into excel they decimal values are
displayed.But we would like not to happen that.

 Is there any way which allows us to roundoff the *output* itself when
we are using the custom tables.  The reason is that we would like to
save the values into a separate data file for further analysis purposes.


Syntax is appreciated.....

Thanks and regards,
Ajay Atluri

=====================
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