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/
