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?