Frequency table - empty cells

[N. Knese]

Hi all,

can anybody tell me how to show empty cells in a frequency table?

Example:
         N
1 red    2500
2 yellow 346
3 blue   0 <----
4 green  1056

Whatever I try SPSS omits category 3 in the table...

Thanks!
Kind regards,
N. Knese

[Mark Webb-3]

Add the following to your CROSSTABS syntax.
/MISSING=INCLUDE
Before /FORMAT



-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of N.
Knese
Sent: 10 September 2007 12:37 PM
To: [hidden email]
Subject: Frequency table - empty cells

Hi all,

can anybody tell me how to show empty cells in a frequency table?

Example:
         N
1 red    2500
2 yellow 346
3 blue   0 <----
4 green  1056

Whatever I try SPSS omits category 3 in the table...

Thanks!
Kind regards,
N. Knese

__________ NOD32 2518 (20070910) Information __________

This message was checked by NOD32 antivirus system.
http://www.eset.com

[N. Knese]

I am not using CROSSTABS, I want to look at one variable each.

Kind regards.

[Peck, Jon]

MISSING=INCLUDE in general just affects the treatment of values defined as user missing.  (FREQUENCIES includes these anyway).

The simplest solution is to do your FREQUENCIES with the CTABLES procedure in the Custom Tables option, which allows empty cells (as defined by value labels) to be included.

Otherwise you have to fake some very small values in the empty cells.

HTH,
Jon Peck

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Mark Webb
Sent: Monday, September 10, 2007 6:19 AM
To: [hidden email]
Subject: Re: [SPSSX-L] Frequency table - empty cells

Add the following to your CROSSTABS syntax.
/MISSING=INCLUDE
Before /FORMAT



-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of N.
Knese
Sent: 10 September 2007 12:37 PM
To: [hidden email]
Subject: Frequency table - empty cells

Hi all,

can anybody tell me how to show empty cells in a frequency table?

Example:
         N
1 red    2500
2 yellow 346
3 blue   0 <----
4 green  1056

Whatever I try SPSS omits category 3 in the table...

Thanks!
Kind regards,
N. Knese

__________ NOD32 2518 (20070910) Information __________

This message was checked by NOD32 antivirus system.
http://www.eset.com

[Marta Garcia-Granero]

Hi N. Knese:

DATA LIST LIST/id(F1) color(A6) n(F8).
BEGIN DATA
1 red    2500
2 yellow  346
3 blue      0
4 green  1056
END DATA.
WEIGHT BY n.

TEMPORARY.
IF (n = 0) n = 0.000001.
FREQUENCIES
  VARIABLES=color.

If your data are not aggregated, then you should aggregate them first
and recode every 0 frequency to 0.000001 (any very low positive value
will do).

> can anybody tell me how to show empty cells in a frequency table?
>
> Example:
>          N
> 1 red    2500
> 2 yellow 346
> 3 blue   0 <----
> 4 green  1056
>
> Whatever I try SPSS omits category 3 in the table...
>
> Thanks!
> Kind regards,
> N. Knese

Best regards,
Marta Garcia-Granero