Menu location: Data_Grouping_Detabulate.
This a function to expand a two way table of counts into a column indicator variable and a row indicator variable, i.e. to deconstruct a table back into individual level data. This is the opposite of crosstabs or the tabulate function.
Example
Given the following table:
|
|
reaction:0 |
reaction:1 |
reaction:2 |
|
sex:0 |
2 |
2 |
1 |
|
sex:1 |
1 |
1 |
3 |
You can use the Data_Grouping_Detabulate menu item on the two by three table of counts to get back to individual level data with each row representing the classification of a subject as follows:
|
Row Classifier |
Column Classifier |
|
0 |
0 |
|
1 |
1 |
|
1 |
2 |
|
0 |
2 |
|
1 |
2 |
|
0 |
1 |
|
0 |
0 |
|
0 |
1 |
|
1 |
2 |
|
1 |
0 |