Include System Missing in Crosstabs

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Include System Missing in Crosstabs

Brian Moore-3
Hi all-

Is there a simple way to get missing to show up as a category in a crosstab?

A sample of what the GUI provides below.

CROSSTABS
  /TABLES=cadd_year  BY datediff_mod_add_coded
  /FORMAT= AVALUE TABLES
  /CELLS= COUNT
  /COUNT ROUND CELL .

Obviously a workaround is to recode the missing values into a code 99 or 999
or whatever.

TIA,

Regards,
Brian
Reply | Threaded
Open this post in threaded view
|

Re: Include System Missing in Crosstabs

Jason Burke
Hi Brian,

You simply need to add the MISSING subcommand, as illustrated below.

HTH,


Jason

CROSSTABS
 /TABLES=cadd_year  BY datediff_mod_add_coded
 /MISSING=INCLUDE
 /FORMAT= AVALUE TABLES
 /CELLS= COUNT
 /COUNT ROUND CELL .


On 10/18/06, Brian Moore <[hidden email]> wrote:

> Hi all-
>
> Is there a simple way to get missing to show up as a category in a crosstab?
>
> A sample of what the GUI provides below.
>
> CROSSTABS
>  /TABLES=cadd_year  BY datediff_mod_add_coded
>  /FORMAT= AVALUE TABLES
>  /CELLS= COUNT
>  /COUNT ROUND CELL .
>
> Obviously a workaround is to recode the missing values into a code 99 or 999
> or whatever.
>
> TIA,
>
> Regards,
> Brian
>