CROSSTABS

CROSSTABS is available in Statistics Base Edition.

CROSSTABS produces contingency tables showing the joint distribution of two or more variables that have a limited number of distinct values.

General mode:

CROSSTABS [TABLES=]varlist BY varlist [BY...] [/varlist...]

 [/MISSING={TABLE**}] 
           {INCLUDE} 

 [/WRITE[={NONE**}]] 
          {CELLS }

 [/HIDESMALLCOUNTS [COUNT = {5      }] ]
                            {integer}

 [/SHOWDIM = integer]

 [/CELLS = [PROP] [BPROP]

Integer mode :

CROSSTABS VARIABLES=varlist(min,max) [varlist...]

 /TABLES=varlist BY varlist [BY...] [/varlist...]

 [/MISSING={TABLE**}] 
           {INCLUDE}
           {REPORT }

 [/WRITE[={NONE**}]] 
          {CELLS } 
          {ALL   } 

Both modes:

 [/FORMAT= {AVALUE**}  {TABLES**}] 
           {DVALUE  }  {NOTABLES}  

 [/COUNT = [{CELL}] [{ROUND }]
            {CASE  }   {TRUNCATE}
            {ASIS  }

 [/CELLS=[{COUNT**}]  [ROW   ]  [EXPECTED]  [SRESID ]] 
          {NONE   }   [COLUMN]  [RESID   ]  [ASRESID]  
                      [TOTAL ]              [ALL    ] 

 [/STATISTICS=[CHISQ]  [LAMBDA]  [BTAU ] [GAMMA  ]  [ETA    ]] 
              [PHI  ]  [UC    ]  [CTAU ] [D      ]  [CORR   ] 
              [CC   ]  [RISK  ]  [KAPPA] [MCNEMAR]  [CMH(1*)]
              [ALL  ]  [NONE  ] 

 [/METHOD={MC [CIN({99.0 })] [SAMPLES({10000})]}]††
                   {value}            {value}
          {EXACT [TIMER({5    })]              }
                        {value}

 [/BARCHART]

**Default if the subcommand is omitted.

†† The METHOD subcommand is available only if Sampling and Testing is installed (available only on Windows operating systems).

This command reads the active dataset and causes execution of any pending commands. See the topic Command Order for more information.

Syntax for the CROSSTABS command can be generated from the Crosstabs dialog.

Release History

Release 19.0

• HIDESMALLCOUNTS subcommand introduced.
• SHOWDIM subcommand introduced.
• PROP and BPROP keywords introduced on the CELLS subcommand.

Example

CROSSTABS TABLES=FEAR BY SEX
 /CELLS=ROW COLUMN EXPECTED RESIDUALS
 /STATISTICS=CHISQ.