Tabulating variables across record types

[kakinyim]

I need to run a table that uses variables from different record types such as gender in record type A and education level completed in record type B. How can CSPro handle this? The biggest problem is to select the right 'Unit Tallied'. I have tried the working dictionary but is not working.

Someone help me.....

Mutua

[Gregory Martin]

To do this you can either use the working storage dictionary or you can use dictionary relations.

1) Working storage dictionary: In the tab logic you would assign either the sex or education level completed values to a value in the working storage dictionary. For example, if you drag your sex variable to the table, your logic might be something like:

WORKING_STORAGE_EDUCATION = EDUCATION(curocc(RECORD_A));

2) Dictionary relations: This is an easier way to handle this problem. While editing your dictionary, select Edit -> Relations. Then you can create a relationship between record A and record B, linking them by an item or simply by the occurrence number. Then you can drag both variables to the table. See attached for an example of this.

[kakinyim]

Thank you Greg, I have tested the two approaches and all are working.

Long live CSPro.

[telimoye]

Thanks Greg for the file, it is working