Hi -- I have data on whether or not farmers plant different kinds of crops; each crop is a dummy variable (yes or no). The crops are not mutually exclusive; farmers can and most do plant more than one. Is there an easy way to make a two-way table that shows, in each cell, the percent of respondents that plant each possible pair of crops. For instance: (these aren't the actual crops):
Apples Pears Oranges Grapes
Apples 100% 25% 35% 60%
Pears 100% 40% 25%
Oranges 100% 40%
Grapes 100%
And, ideally, code also for exporting the table into excel...
Related Posts with making a two-way table for dummy variable overlap frequencies
Missing variables using reshape wide commandHi, This is the command I'm using- reshape wide day_piece, i(farm) j(day_sales) string And this is…
OutliersDear All, I have a quick question, Is it necessary to remove outliers from survey data? Would that…
Trying to run a predicted probabilities plot with a twoway scatterplot with a splineI accidentally created two threads of the same thing …
Combining two panel databasesDear Stata team, I was wondering if anyone could help me with the following: I have a panel databas…
Coefficient interpretation from a GLM regression family(gamma) link(log)Hi all, I am trying to explain some coefficients from a GLM regression with family(gamma) link(log)…
Subscribe to:
Post Comments (Atom)
0 Response to making a two-way table for dummy variable overlap frequencies
Post a Comment