In my data,
only the codes are reported as 1 2 or 3 etc. That is
if 1 is reported then that 1 corresponds to income
<2500 if per year, <200 if per month and <50 if per
week. And then I have another incomereport variable
which says that the income variable above was either
reported by year(1), by month(2) or by week(3).
What I don't know is how do I replace the value 1 2
and 3 into income range of <2500 or <200 in order for
me to convert everything into values in $ not code 1 2
3 and then convert all in yearly income.
sorry to bother you all,
Feno
--- Svend Juul <[email protected]> wrote:
> 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/
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
*
* 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/
