Hello,
I'm trying to re-create a table given in one of the technical reports on housing. The data set includes household level data on housing condition and other socio-economic parameters. The table that I want to recreate basically divides the households into decile groups based on monthly per capita consumption expenditure (MPCE). I tried different approaches including:

Method 1:

egen MPCErank= rank( MPCE ), unique
egen decile =cut(MPCErank), group(10)

Method 2:
sort MPCE
sumdist MPCE [aweight==weight], n(10)

But yet failed to recreate them. Please tell me where I'm going wrong.