Difficulties merging LSMS-ISA data

[Felizia Pastter]

Hi everyone,

I am working with World Bank data from the Living Standards Measurement Study - Integrated Surveys on Agriculture (LSMS-ISA). The country is Mali and the year is 2017/2018.
I merged several data files based on the household id and individual id. However, some files cannot be merged because I have several rows of responses for the same household. That means that the household id and the individual id are not unique.

So, for instance, it looks like this:

hhid indid safety_net
12 1 cash transfer
12 1 food for work
12 1 donation of cereals
12 1 public work
13 3 cash transfer
13 3 food for work



I would highly appreciate any kind of help!


Many thanks!

[Jared Greathouse]

Please see the FAQ for how to ask a question. Welcome to Statalist.

in general, we prefer questions that provide a dataset as well as code we've tried so far. The more specific your question is, say this one, the easier it'll be for us to provide feedback.