Hi,
I am working with the National Sample Survey Organization dataset from India. It is an individual level dataset but the consumption figures are of the entire household.
The consumption figures are given item wise in the data set in terms of monthly per capita consumption expenditure
There is a household id for each household and a person id as well.
If I want to calculate the total annual household consumption expenditure of each household, what sepcific command of Stata do I use?
The process that I followed was :
1. convert the MPCE (in rupee terms) for 30 days into 365 days by multiplying and dividing by 365 and 30 respectively
2.add the MPCE_365 for all individuals in the same household by using the bysort hhid command
However, this does not give the correct figures because the consumption figures are household wise and not at the individual level.
Thanks and regards,
Meghna
Related Posts with Command for calculating household level expenditure
Predict commandHi, I estimated the probability of default of loans using borrower characteristics. First, I run a …
coefplot - creating a vertical coefficient plot with multiple lines across the entire x-axisDear Stata users, I'm having a problem creating a coefficient plot with Stata that produces vertica…
Clusteff command for panel dataDear Statalisters, could anyone tell me whether the command "clusteff" can also be applied to panel …
Rolling percentiles for large datasetHi, I have a large dataset containing more than 30m observations. The dataset aggregates daily trad…
DID difference in difference for count data using nbreg (negativ binomial)Dear statalists, I have a data set of treated (employees purchasing stocks through a firm´s stock o…
Subscribe to:
Post Comments (Atom)
0 Response to Command for calculating household level expenditure
Post a Comment