Stata users,
I hope you can help me! I am new to STATA
I need to run an analysis, using the expenditure variable ( valuedairyannualized) in the Income and Expenditure Survey, but I failed as STATA returned an error code saying "too many items "
So i created a variable in the data set called expediture and coded it 0- 12.
In the data set Expenditure is grouped based on type of expenditure
namely: main grp, secondarygrp and thirdgrp
I would like to run tables that will give me total household expenditure, within each expenditure group
This is the advice I got:
gen new_wgt=round(( Weight*valueannualized))
then syntax is:
gen expenditure maingrp (weight=new_wgt),row
(where maingrrp is type of expenditure)
1. Is there any way to do this without first group the expenditure
(variablevalueannualized)
2. Tabulate seems to give me the number of household within each
expenditure group instead of their actual expenditure
Any help is greatly appreciated.
Mosidi
Statistics South Africa: Disclaimer and Confidentiality Note
This email, its attachments and any rights attaching hereto are, unless the context clearly indicates otherwise, the property of Statistics South Africa. It is confidential, private and intended for the addressee only. Should you not be the addressee and receive this email by mistake, kindly notify the sender, and delete this email immediately and do not disclose or use same in any manner whatsoever. Views and opinions expressed in this email are those of the sender unless clearly stated as those of Statistics South Africa. Statistics South Africa accepts no liability whatsoever for any loss or damages whatsoever and howsoever incurred, or suffered, resulting, or arising, from the use of this email or its attachments. Statistics South Africa does not warrant the integrity of this email nor that it is free of errors, viruses, interception or interference.
Statistics South Africa:
Telephone number: (27) 12 310 8911
[email protected]
WebSite :- www.statssa.gov.za
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
