Nirina wrote:
My data on income is reported in messy way: AND I
WOULD LIKE TO GET THE INCOME IN THE SAME WAY, FOR
EXAMPLE ALL INCOME WOULD BE PER YEAR OR PER MONTH OR
PER DAY.
HOW DO I DO THIS?
I have:" income" variable
codes Average per year Average per month
Average per week
1 <2,500 < 200
<50
2 2,500- 3,750 200-300
50-70
3 3,750 -5000 300-400
70-100
4 >5000 >400
>100
and then I have "incomereport" variable which says:
codes label
1 income reported was per WEEK
2 income reported was per MONTH
3 income reported was per YEAR
- and there was a not too successful dialogue between Nirina and Nick.
--------------------------------------------------------------------
I am in doubt about what your primary data look like. Is it your primary
data you describe above, or are 1, 2, 3, 4 codes you want to create,
with the complication that in the primary data -income- is sometimes
recorded per week, sometimes per month or year, with -incomereport-
telling the which time interval is used?
If that is the case I would choose e.g. monthly income (-mincome-) and:
generate mincome = income*4 if incomereport==1
replace mincome = income if incomereport==2
replace mincome = income/12 if incomereport==3
and next greate a grouped variable:
recode mincome (min/2499.99 = 1 "<2,500") ///
(2500/3749.99 = 2 "2,500-3,749")(...) , generate(mincomegr)
- but my guessing may be wrong.
Svend
__________________________________________
Svend Juul
Institut for Folkesundhed, Afdeling for Epidemiologi
(Institute of Public Health, Department of Epidemiology)
Vennelyst Boulevard 6
DK-8000 Aarhus C, Denmark
Phone: +45 8942 6090
Home: +45 8693 7796
Email: [email protected]
__________________________________________
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
