-
Login or Register
- Log in with
use dataset1 joinby HHID using dataset2
* Example generated by -dataex-. To install: ssc install dataex clear input str14 HHID float Parcel_ID long Plot_ID str20 Crop_name long Crop_code double a5bq6a int a5bq6b long a5bq6c double(a5bq6d a5bq7a) int a5bq7b float a5bq7c long(a5bq8 a5bq9) double a5bq10 "1013000204" 21 1 "BANANA" 741 0 . . . . . . . . . "1013000204" 21 1 "Cassava" 630 .5 10 11 80 .5 10 11 20000 5 0 "1013000204" 21 1 "MAIZE" 130 1 20 39 5 0 . . . . . "1013000204" 21 1 "cassava" 630 1 10 11 80 .5 10 11 20000 5 0 "1021000108" 1 1 "Banana food" 741 36 20 68 15 0 . . . . . "1021000108" 1 2 "Beans" 210 24 45 13 45 0 . . . . . "1021000108" 1 2 "Maize" 130 1 20 13 70 0 . . . . . "1021000108" 1 3 "" . . . . . . . . . . . "1021000108" 1 3 "Fallow" 930 . . . . . . . . . . "1021000113" 1 1 "Cabbage" 410 6 20 22 20 3 20 22 7000 6 3000 "1021000113" 1 2 "Other" 890 8 20 22 6 5 20 22 15000 6 2000 "1021000113" 1 3 "Dodo" 460 12 20 22 6 5 20 22 10000 6 2000 "1021000113" 1 4 "Dodo" 460 12 20 22 6 4 20 22 8000 6 2000 "1021000113" 1 5 "Yam" 640 3 20 22 18 0 . . . . . "1021000408" 1 . "" . . . . . . . . . . . "1021000710" 1 1 "Banana food" 741 40 20 68 23 0 . . . . . "1021000807" 1 1 "Coffee all" 810 4 45 13 70 4 45 13 364000 6 0 "1021000807" 1 2 "" 910 . . . . . . . . . . "1021000807" 2 1 "Banana food" 741 65 20 68 16 0 . . . . . "1021000807" 2 1 "Banana food" 741 30 20 67 25 30 20 67 135000 6 0 "1021000807" 2 2 "" 630 . . . . . . . . . . "1021000807" . 2 "" 25 . . . . . . . . . . "102100080803" 1 1 "Banana food" 741 30 20 68 17 0 . . . . . "102100080803" 1 1 "Coffee all" 810 2 45 13 75 2 45 13 120000 2 0 "102100080803" 1 2 "" . . . . . . . . . . . "102100080803" 2 1 "Beans" 210 15 45 1 1 0 . . . . . "102100080803" 2 1 "Maize" 130 1 45 12 50 0 . . . . . "102100080803" 2 2 "Groundnuts" 310 2 42 13 35 0 . . . . . "102100080803" 2 2 "Maize" 130 1 45 13 75 25 45 1 6250 2 0 "102100080803" 21 1 "" . . . . . . . . . . . "102100080803" 21 1 "Maize" 130 1 45 10 100 .5 45 1 12500 2 0 "102100110201" 1 . "" . . . . . . . . . . . "102100110201" 2 1 "" 820 . . . . . . . . . . "102100110201" 2 1 "Coffee all" 810 2 24 11 80 2 44 11 120000 2 0 "102100110201" 2 2 "Cocoa" 820 99999 . . . . . . . . . "102100110201" 3 1 "Cassava" 630 6 20 12 50 6 20 12 60000 2 0 "102100110201" 3 1 "Cassava" 630 2 20 10 100 . . . . . 0 "102100110201" 4 . "" . . . . . . . . . . . "102100110201" . 2 "" 38 . . . . . . . . . . "1021001109" 1 . "" . . . . . . . . . . . "1021001109" 2 1 "Yam" 640 2.5 20 10 100 0 . . . . . "1021001109" 3 1 "" . . . . . . . . . . . "1021001109" 3 1 "Banana food" 741 20 20 67 15 0 . . . . . "1021001109" 3 2 "" . . . . . . . . . . . "1021001109" 3 2 "Cassava" 630 2 20 10 120 0 . . . . . "1021001109" 3 3 "" . . . . . . . . . . . "1021001109" 3 3 "Sweet potatoes" 620 2 20 10 100 0 . . . . . "1021001109" 3 4 "" . . . . . . . . . . . "1021001109" 3 4 "Maize" 130 1 21 10 100 0 . . . . . "1021001304" 1 1 "Banana food" 741 7 20 68 20 0 . . . . . "1021001304" 1 1 "Beans" 210 1 45 20 25 0 . . . . . "1021001304" 1 1 "Beans" 210 20 24 32 .5 0 . . . . . "1021001304" 1 1 "Cassava" 630 3 20 22 17 0 . . . . . "1021001304" 1 2 "Sweet potatoes" 620 .5 20 10 17 0 . . . . . "1021001910" 1 . "" . . . . . . . . . . . "1021002501" 1 . "" . . . . . . . . . . . "1021002610" 1 1 "Banana food" 741 5 20 68 15 0 . . . . . "1021002610" 1 1 "Coffee all" 810 3 44 20 20 0 . . . . . "1021002610" 1 1 "Sweet potatoes" 620 99999 . . . . . . . . . "1021002610" 1 2 "Cassava" 630 1 20 20 25 0 . . . . . "1021002610" 1 2 "Yam" 640 3 20 20 25 2 20 20 20000 4 0 "1021002610" 1 3 "Cassava" 630 99999 . . . . . . . . . "1021002610" 21 1 "Yam" 640 99999 . . . . . . . . . "1021002611" 1 1 "Beans" 210 1.5 23 22 20 0 . . . . . "1021002611" 1 1 "Cassava" 630 99999 . . . . . . . . . "1021002611" 1 1 "Sweet potatoes" 620 99999 . . . . . . . . . "1021002810" 1 1 "Sweet potatoes" 620 3 40 22 15 0 . . . . . "1021002810" 1 2 "Banana food" 741 99999 . . . . . . . . . "1021003309" 21 . "" . . . . . . . . . . . "1033000301" 1 1 "Banana food" 741 15 20 69 5 0 . . . . . "1033000301" 1 1 "Maize" 130 2 45 9 120 0 . . . . . "1033000302" 1 1 "Beans" 210 3 35 20 20 0 . . . . . "1033000302" 1 1 "Maize" 130 7 33 10 100 1.5 45 10 27000 2 0 "1033000302" 1 1 "maize" 130 7 45 10 100 1.5 45 10 27000 2 0 "1033000302" 1 2 "Coffee all" 810 2 24 10 100 2 24 10 70000 2 0 "1033000302" 1 2 "banana" 741 24 20 68 12 2 20 68 8000 2 0 "1033000302" 1 3 "Cassava" 630 2 20 10 100 1 40 10 35000 2 0 "1033000303" 1 1 "Sweet potatoes" 620 0 . . . . . . . . . "1033000303" 1 2 "Cassava" 630 1 20 10 100 0 . . . . . "1033000303" 1 2 "beans" 210 0 . . . . . . . . . "1033000303" 1 3 "Banana food" 741 72 10 68 12 0 . . . . . "1033000303" 1 4 "Beans" 210 2 35 20 20 0 . . . . . "1033000303" 1 4 "Maize" 130 14.5 33 10 100 3 45 10 90000 2 0 "1033000303" 1 4 "maize" 130 5.5 33 10 100 3 45 10 90000 2 0 "1033000303" 2 1 "" . . . . . . . . . . . "1033000303" 2 2 "" . . . . . . . . . . . "1033000303" 2 3 "" . . . . . . . . . . . "1033000303" 2 4 "" . . . . . . . . . . . "1033000304" 1 1 "Banana food" 741 168 69 5 0 0 . . . . . "1033000304" 1 1 "Coffee all" 810 50 20 20 20 50 20 20 200000 2 0 "1033000304" 1 2 "Banana beer" 742 60 20 69 5 0 . . . . . "1033000304" 21 1 "Sweet potatoes" 620 3 20 20 20 0 . . . . . "1033000304" 22 . "" . . . . . . . . . . . "103300030403" 1 1 "Banana food" 741 5 20 69 5 0 . . . . . "103300030403" 1 1 "Coffee all" 810 3 20 10 100 3 20 10 90000 . . "103300030403" 2 1 "Banana food" 741 6 20 69 5 0 . . . . . "103300030403" 21 1 "Beans" 210 1 20 20 20 0 . . . . . "103300030403" 21 1 "Cassava" 630 0 . . . . . . . . . "103300030403" 21 1 "Maize" 130 12 45 10 100 0 . . . . . "1033000305" 1 1 "" . . . . . . . . . . . end label values a5bq9 A5BQ9 label def A5BQ9 2 "Private trader in Local village/market", modify label def A5BQ9 4 "Consumer at market", modify label def A5BQ9 5 "Neighbor/ Relative", modify label def A5BQ9 6 "Other (specify)", modify
joinby HHID Parcel_ID Plot_ID Crop_code using "dataset 2"
Comment