# st: AW: how to reconstruct a minimum acceptable income from a set of binary variables?

 From "Martin Weiss" To Subject st: AW: how to reconstruct a minimum acceptable income from a set of binary variables? Date Sun, 1 Mar 2009 20:23:06 +0100

```<>

*************
*reconstruct Ekaterina`s data
clear*
input id mindesinc_500_999 mindesinc_1000_1499  mindesinc_1500_1999
101 1 0 0 0
102 0 1 0 0
103 0 0 1 0
104 0 0 1 0
105 0 1 0 0
end
*construct the minimum desired income
g mindesinc=500 if mindesinc_500_999
replace mindesinc=1000 if mindesinc_1000_1499
replace mindesinc=1500 if mindesinc_1500_1999
l
*************

HTH
Martin

-----Ursprüngliche Nachricht-----
Von: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Ekaterina
Hertog
Gesendet: Sonntag, 1. März 2009 20:15
An: statalist@hsphsun2.harvard.edu
Betreff: st: how to reconstruct a minimum acceptable income from a set of
binary variables?

Dear all,
I am dealing with a dataset from a private company and so my data often
comes in rather strange format and I now came against the following problem:

I have a set of individuals who answered questions about desired income.
It looks as follows:

Individ nmb | Min desired income 500 - 999 | 1000 - 1499 |  1500 - 2000 |
101             |                      0
|         0          |           1          |
102             |                      0
|         1          |           1          |
103             |                      0
|         0          |           1          |
104             |                      1
|         1          |           1          |
105             |                      0
|         1          |           1          |

Is there a way to automatically recode these binary minimum desired
income variables into a numerical variable which would state the minimum
acceptable figure for each individual?
That is some routine which would check "Min desired income 500 - 999"
and if it equals 1 then would input 500 for the individual in question
into a newly constructed variable "Minimum acceptable income" and move
on to the next person and if it equals 0 would look at the value of
"1000 - 1499" variable and if it equals 1 would input 1000 for that
person and move on to the next person and if it is 0 would look at "1500
- 2000" variable?
I would be most grateful for any advice,
Sincerely yours,
Ekaterina

--
Ekaterina Hertog (née Korobtseva)
Career Development Fellow
Department of Sociology and Nissan Institute of Japanese Studies
University of Oxford

Oxford
OX2 6NA
United Kingdom

*
*   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/
```