CELLS Subcommand (MATRIX DATA command)

CELLS specifies the number of within-cells records in the data. The only valid specification for CELLS is a single integer, which indicates the number of sets of within-cells information that MATRIX DATA must read.

  • CELLS is required when there are factors in the data and ROWTYPE_ is implicit.
  • If CELLS is used when ROWTYPE_ is specified on VARIABLES, MATRIX DATA issues a warning and ignores the CELLS subcommand.

Example

MATRIX DATA VARIABLES=F1 VAR1 TO VAR3 /FACTORS=F1 /CELLS=2
  /CONTENTS=(MEAN SD N) CORR.
BEGIN DATA
1  5  4  3
1  3  2  1
1  9  9  9
2  8  7  6
2  6  7  8
2  9  9  9
   1
  .6  1
  .7 .8  1
END DATA.
  • The specification for CELLS is 2 because the factor variable F1 has two values (1 and 2) and there are therefore two sets of within-cells information.
  • If there were two factor variables, F1 and F2, and each had two values, 1 and 2, CELLS would equal 4 to account for all four possible factor combinations (assuming all that 4 combinations are present in the data).