Ksharp i have checked with your recent code in the given i am getting output with out any wrong household ids ,but in the above example i just kept "|" as delimiter to post the example observations i the real time i am working with the sas dataset that is alredy created ,when i have ran this code on 8 laks obs the pan1 is getting correctly the obs in pan1 are going only in to one Househodld but while coming to add1,pan2,pan3 the pan2 obs also should have ex-BBB in pan2 should have only in one household like that i am struggling for this..tnqs
... View more