Sum of cells

[behnaz shirazi-2]

Hello Dear All,

I have  a 24 variables .One of them is AstrtnT6 which has different values
in the output example
it has 12 and  12 Months .Some of them like AstrtnT13 have "other" and
"Unknown".As long as I need these tables for my automate proccess I need to
have one row for "12" and "12 Months".
Do you have any idea how I can have one row(12+12Months)  instead of 2 rows
..
I got the output through Cro tab command.

AstrtnT6 * distinct Crosstabulation
                        distinct                        Total
                        1.00    2.00    3.00    1.00
AstrtnT6                Count   137     2504    17754   20395
                % within distinct       97.2%   94.5%   95.3%   95.2%
        12      Count   0       0       1       1
                % within distinct       .0%     .0%     .0%     .0%
        12 Months       Count   4       145     868     1017
                % within distinct       2.8%    5.5%    4.7%    4.7%
Total           Count   141     2649    18623   21413
                % within distinct       100.0%  100.0%  100.0%  100.0%


Any hope!
Thank you
Behnaz

_________________________________________________________________
FREE pop-up blocking with the new MSN Toolbar - get it now!
http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/

[Richard Ristow]

I'm not sure I quite understand this, but at 12:04 PM 4/25/2007, behnaz
shirazi wrote:

>I have 24 variables. One of them is AstrtnT6 which has different
>values in the output example. I got the output through Crosstab
>command.

Here is what you posted, somewhat reformatted:

AstrtnT6 * distinct Crosstabulation
                        distinct                 Total
                        1.00    2.00    3.00      1.00
AstrtnT6       Count    137    2504   17754     20395
    % within distinct   97.2%   94.5%   95.3%     95.2%
      12        Count      0       0       1         1
    % within distinct     .0%     .0%     .0%       .0%
      12 Months Count      4     145     868      1017
    % within distinct    2.8%    5.5%    4.7%      4.7%
Total          Count    141    2649   18623     21413
    % within distinct  100.0%  100.0%  100.0%    100.0%

That's regular CROSSTABS output and makes sense, except that there
should be a value for 'AstrtnT6' for the first row, the one with 95.2%
of the values. (The '1.00' under the word 'Total' doesn't make sense,
but that may be from a bug in SPSS 15.)

You asked,

>I need to have one row [combining] "12" and "12 Months".

It appears that 'AstrtnT6' is a string variable, and I'm treating it
that way.

You can use syntax like this (the first RECODE specification isn't
needed):

TEMPORARY.
RECODE AstrtnT6
    ('12 Months' = '12 Months')
    ('12'        = '12 Months').

CROSSTABS
   /TABLES=AstrtnT6  BY distinct
   /FORMAT= AVALUE TABLES
   /CELLS= COUNT COLUMN
   /COUNT ROUND CELL .

[behnaz shirazi-2]

Thank you Richard
Sorry if I am replying so late.Thank you for your help .It is working for
me.


Behnaz

>From: Richard Ristow <[hidden email]>
>Reply-To: Richard Ristow <[hidden email]>
>To: [hidden email]
>Subject: Re: Sum of cells
>Date: Fri, 27 Apr 2007 19:31:07 -0400
>
>I'm not sure I quite understand this, but at 12:04 PM 4/25/2007, behnaz
>shirazi wrote:
>
>>I have 24 variables. One of them is AstrtnT6 which has different
>>values in the output example. I got the output through Crosstab
>>command.
>
>Here is what you posted, somewhat reformatted:
>
>AstrtnT6 * distinct Crosstabulation
>                        distinct                 Total
>                        1.00    2.00    3.00      1.00
>AstrtnT6       Count    137    2504   17754     20395
>    % within distinct   97.2%   94.5%   95.3%     95.2%
>      12        Count      0       0       1         1
>    % within distinct     .0%     .0%     .0%       .0%
>      12 Months Count      4     145     868      1017
>    % within distinct    2.8%    5.5%    4.7%      4.7%
>Total          Count    141    2649   18623     21413
>    % within distinct  100.0%  100.0%  100.0%    100.0%
>
>That's regular CROSSTABS output and makes sense, except that there
>should be a value for 'AstrtnT6' for the first row, the one with 95.2%
>of the values. (The '1.00' under the word 'Total' doesn't make sense,
>but that may be from a bug in SPSS 15.)
>
>You asked,
>
>>I need to have one row [combining] "12" and "12 Months".
>
>It appears that 'AstrtnT6' is a string variable, and I'm treating it
>that way.
>
>You can use syntax like this (the first RECODE specification isn't
>needed):
>
>TEMPORARY.
>RECODE AstrtnT6
>    ('12 Months' = '12 Months')
>    ('12'        = '12 Months').
>
>CROSSTABS
>   /TABLES=AstrtnT6  BY distinct
>   /FORMAT= AVALUE TABLES
>   /CELLS= COUNT COLUMN
>   /COUNT ROUND CELL .

_________________________________________________________________
Don't just search. Find. Check out the new MSN Search!
http://search.msn.com/