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
Reshape long to wideHi all, I need advice on how to change the dataset which is in the form of table with 6 rows * 3 co…
Collect regression results in a loopI am trying to run a loop of regressions, save coefficient estimates, and use saved results as a dta…
Mauchly's test of sphericityI need help please. After running a one way repeated measure ANOVA for my data, I got a result whic…
adding the country -specific time trends as controlhello and good day to all, I am using the local projection method for my thesis, (panel data ) , I d…
Reference category in fixed effects regressionHi Statalist, Please consider the following example: Code: *model 1* areg score shock##c.treatmen…
Subscribe to:
Post Comments (Atom)
0 Response to making a two-way table for dummy variable overlap frequencies
Post a Comment