This post has NOT been accepted by the mailing list yet.
I have two datasets, the first has this shape (each word is a column)
Name address phone .. ..
The second one has the following shape
I need a contingency table with for example phone and request.
The people registered in these datasets are present in both datasets, BUT in the first every record is a person, so every person is counted once and is 1 row, in the second every row is a request, so if a person has requested 1 thing this person is present only once, but is the person has requested 3 things, this person we'll be present 3 times and with three rows
I know that to use access could be the solution, but in this moment the computer expert give me data only as .xls/.csv data.
This creates the possibility of two different cross tab, I really need both,
the first has as total count the number of people
The second one has as total count the number of request