Dear Stata list,
I have household level 24 hours food consumption data (by Menu) including ingredients in one data set.
In another data set, for the same household, I also have individual level food consumption data only by Menu (no ingredients )
How can I match two data sets to find out individual level ingredients consumed by each person.
Below example data sets are given. I also do not know why example data sets are not working (very sorry about that)
Household level data:
clear
input double hh_id int Menu_1 int ingre_1 int ingre_2 int ingre_3 int ingre_4 int ingre_5
1 "Salt"
1 "Rice/Jao" "Fine Rice"
1 "Jhol curry" "Lau Shak" "Koi" "Potato" "Turmeric"
1 "Bhuna curry" "Potato" "Onion" "Garloic" "Coriander"
1 "Supari"
1 "Betel Leaf"
2 "Rice/Jao"
2 "Bhuna corry" "Water gourd" "Tengra" "Onion" "Green chilli"
2 "Salt"
end
Individual level data:
input double hh_id double Person_id double age int Menu_2
1 1 . "Salt"
1 1 57 "Rice/Jao"
1 1 . "Bhuna curry"
1 2 50 "Rice/Jao"
1 2 . "Bhuna curry"
1 2 . "Jhol curry"
2 1 . "Salt"
2 1 51 "Rice/Jao"
2 1 . "Bhuna curry"
end
Any support would highly appreciated !
Thank you so much!
Related Posts with Matching households food consumption with individual
Meta Analysis for one group - no control group.Hi all, I am conducting a systematic review and meta analysis that will investigate health-related …
Help with getting percentilesHi all, My problem is the following: I have a sheet with product categories, and each category has i…
HP filter panel dataHello, I am PhD student and I am new to stata. I am trying to create an hp trend for variable TourPr…
Merging datasets without uniquely identified observationsHello, I found a post on this subject but the solutions posted do not work for me. My master data …
Two step system GMMHi I run two step system GMM and the assumption that all the variable is exogenous; but might not s…
Subscribe to:
Post Comments (Atom)
0 Response to Matching households food consumption with individual
Post a Comment