Stata command help

[Sunshine bae]

Hello. I am working with household survey dataset.
I need to find the share of diversified farm households in each districts.
I have two unique variables (xhpsu : household primary sampling unit and xhnum: household number) in each dataset with which I have been merging the datasets.
I tried using coll2(mean) by xhpsu command, it gave me the statistics that I wanted. But I am having problem merging this with my master dataset as this fails to incorporate xhnum.
So can anyone help me?

[Jared Greathouse]

Using Statalist is just like making wild mushroom risotto. If I asked you to make my favorite version of risotto, you'd likely need to know what the SPECIFIC ingredients are and the steps you do to make said dish. So far you've given neither, you're asking us for help to make a dish, and you've not given the recipe (the code) or ingredients (the data).

Precisely, you must give your dataset using dataex and your code that you've tried (formatted accordingly). No dataset, no code=no real assistance.

Verbal descriptions alone is never a good way of telling us what a dataset consists of.