My apologies,
the syntax is:
tab expenditure maingrp (weight=new_wgt),row
Like I said this gives me the number of households within each expenditure group
Regards
>>> "Martin Weiss" <[email protected]> 1/15/2009 12:59:34 PM >>>
Line for the server...
Hi, welcome to the Stata community, very good to see you! Have you actually
tried to run the line " gen expenditure maingrp (weight=new_wgt),row"? I
have a hard time figuring out what that is supposed to do. -gen- requires at
least an equal sign to run (see -h gen-), and AFAIK, it does not have the
"row" option...
HTH
Martin
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Mosidi Nhlapo
Sent: Thursday, January 15, 2009 11:51 AM
To: [email protected]
Subject: st: Analysing expenditure data
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/
*
* 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/
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/
