Analyzing Aggregated Data (ANACOR command)

To analyze aggregated data, such as data from a crosstabulation where cell counts are available but the original raw data are not, you can use the TABLE=ALL option or the WEIGHT command before ANACOR.

Example

To analyze a 3 x 3 table, such as the table that is shown below, you could use these commands:

DATA LIST FREE/ BIRTHORD ANXIETY COUNT.
BEGIN DATA
1 1 48
1 2 27
1 3 22
2 1 33
2 2 20
2 3 39
3 1 29
3 2 42
3 3 47
END DATA.
WEIGHT BY COUNT.
ANACOR TABLE=BIRTHORD (1,3) BY ANXIETY (1,3).
  • The WEIGHT command weights each case by the value of COUNT, as if there are 48 subjects with BIRTHORD=1 and ANXIETY=1, 27 subjects with BIRTHORD=1 and ANXIETY=2, and so on.
  • ANACOR can then be used to analyze the data.
  • If any table cell value equals 0, the WEIGHT command issues a warning, but the ANACOR analysis is done correctly.
  • The table cell values (the WEIGHT values) cannot be negative. WEIGHT changes system-missing values and negative values to 0.
  • For large aggregated tables, you can use the TABLE=ALL option or the transformation language to enter the table “as is.”
Table 1. 3 by 3 table
Birth Order Anxiety High Anxiety Med Anxiety Low
First 48 27 22
Second 33 20 39
Other 29 42 47