Below is my data column where respondents selected various sources of water.
I would like to generate various dummy vars based on choices made, for example, if sources are Fishing, Vegetable cultivation, Pepper production, then the data should look like:
| Fishing | Vegatable | Pepper |
| 1 | 0 | 1 |
| 0 | 1 | 1 |
| 1 | 1 | 1 |
I tried the code
Code:
tab agricWaterUseDry, gen(new)
I also tried to get dummies and the values are extremely many.
Is there a way out please?
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input str114 agricWaterUsedDry "" "" "" "Vegetable cultivation, Pepper production" "" "" "" "" "" "Watering livestock" "" "" "Nothing" "" "Nothing" "Nothing" "Nothing" "Construct buildings" "Construct buildings" "Construct buildings" "Construct buildings" "Construct buildings" "Construct buildings" "Construct buildings" "Watering livestock, Construct buildings" "Watering livestock, Construct buildings" "Watering livestock, Construct buildings" "Vegetable cultivation, Watering livestock, Construct buildings, Fresh maize production" "" "Watering livestock" "Nothing" "Watering livestock" "Nothing" "Fishing, Watering livestock" "Construct buildings" "Watering livestock" "Nothing" "Nothing" "Watering livestock" "Vegetable cultivation, Fishing, Pepper production, Watering livestock, Construct buildings" "Vegetable cultivation, Pepper production, Watering livestock, Construct buildings" "Fishing, Vegetable cultivation, Construct buildings, Pepper production, Watering livestock" "Vegetable cultivation, Pepper production, Watering livestock, Construct buildings, Fresh maize production" "Fishing, Vegetable cultivation, Construct buildings, Pepper production, Watering livestock" "Vegetable cultivation, Construct buildings, Pepper production, Fresh maize production, Watering livestock" "Vegetable cultivation, Construct buildings, Pepper production" "Vegetable cultivation, Construct buildings, Pepper production" "Vegetable cultivation, Construct buildings" "Vegetable cultivation, Pepper production" "Vegetable cultivation, Pepper production, Construct buildings" "Vegetable cultivation, Construct buildings, Pepper production" "Vegetable cultivation, Pepper production, Construct buildings" "Vegetable cultivation, Pepper production" "Fishing, Vegetable cultivation, Construct buildings, Pepper production" "Vegetable cultivation, Pepper production" "Fishing, Vegetable cultivation, Pepper production" "Vegetable cultivation, Pepper production" "Vegetable cultivation, Pepper production, Construct buildings" "Vegetable cultivation, Construct buildings, Pepper production" "Vegetable cultivation, Pepper production" "Vegetable cultivation, Pepper production, Watering livestock" "Vegetable cultivation, Construct buildings, Pepper production" "Vegetable cultivation, Pepper production" "Fishing, Vegetable cultivation, Pepper production" "Vegetable cultivation, Pepper production" "Vegetable cultivation, Pepper production" "" "Vegetable cultivation, Pepper production" "Vegetable cultivation, Pepper production, Fresh maize production" "Fishing, Vegetable cultivation, Construct buildings, Pepper production, Watering livestock" "" "Vegetable cultivation, Pepper production, Watering livestock, Construct buildings" "Vegetable cultivation, Pepper production, Watering livestock, Construct buildings, Fresh maize production" "Vegetable cultivation, Fishing, Pepper production, Watering livestock, Construct buildings" "Vegetable cultivation, Fishing, Pepper production, Watering livestock, Construct buildings, Fresh maize production" "Vegetable cultivation, Pepper production, Watering livestock" "Vegetable cultivation, Pepper production" "Vegetable cultivation, Pepper production" "Vegetable cultivation, Pepper production" "Vegetable cultivation, Construct buildings, Pepper production" "Vegetable cultivation, Pepper production" "Vegetable cultivation, Pepper production" "Vegetable cultivation, Pepper production" "Vegetable cultivation, Pepper production" "Vegetable cultivation, Pepper production, Watering livestock, Construct buildings, Fresh maize production" "Vegetable cultivation, Construct buildings, Pepper production, Watering livestock" "Vegetable cultivation, Pepper production" "Vegetable cultivation, Construct buildings, Pepper production, Watering livestock" "Fishing, Vegetable cultivation, Construct buildings, Pepper production, Watering livestock" "Vegetable cultivation, Construct buildings, Pepper production, Watering livestock" "Vegetable cultivation, Pepper production" "Vegetable cultivation, Fishing, Pepper production, Watering livestock, Construct buildings" "Vegetable cultivation, Fishing, Pepper production, Watering livestock, Construct buildings" "Vegetable cultivation, Fishing, Pepper production, Watering livestock, Construct buildings, Fresh maize production" "Vegetable cultivation, Pepper production, Watering livestock, Construct buildings, Fresh maize production" "Vegetable cultivation, Pepper production, Watering livestock, Construct buildings, Fresh maize production" "Vegetable cultivation, Pepper production" "Vegetable cultivation, Pepper production" "Vegetable cultivation, Pepper production" "Fishing, Vegetable cultivation, Construct buildings, Pepper production, Watering livestock" end
0 Response to Generate dummy from strings
Post a Comment