I have two datasets, the first has this shape (each word is a column)
Name address phone .. ..
The second one has the following shape
Name request
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. ??
I now 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