[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

 From Ekaterina Hertog To statalist@hsphsun2.harvard.edu Subject st: how to reconstruct a minimum acceptable income from a set of binary variables? Date Sun, 01 Mar 2009 19:15:05 +0000

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

27 Winchester Road
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/
```

 © Copyright 1996–2017 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index