Hi,
I have the following data management issue. I am trying to combine multiple
years of ethnicity data into one variable called ethnic. The data looks
similar to the following
id ethnic07 ethnic08 ethnic09 ethnic10
1 1 1 1 1
2 1 1 2 2
3 3 4 4 NA
4 2 3 NA NA
So, what I'd like to do is create a variable called 'ethnic' and I'd like to
have this variable be filled with the most recent data available. So
ethnic10 would have the highest priority, then ethnic09, followed by
ethnic08, and finally ethnic07. So the ethnic variable based on the data
above would look like the following:
ethnic
1
2
4
3
I thought an ifelse() statement might work but I seem to be writing over my
data every time I do this.
Thanks,
Chris
[[alternative HTML version deleted]]
______________________________________________
[email protected] mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
