Please advise syntax for retaining last value, time variable is "fin_year" and I would like the most recent "last_place_type". Also since there is missing data; ignore missing data and take the last recorded "last_place_type". I tried this and it did not work:
by personid (fin_year), sort: gen last_ptype = last_place_type[_N] if last_place_type !=.
[CODE]
* Example generated by -dataex-. To install: ssc install dataex
clear
input long personid str7 fin_year long last_place_type
2337 "FY10/11" 5
2337 "FY11/12" 5
2337 "FY11/12" .
2337 "FY12/13" .
3172 "FY09/10" .
3172 "FY09/10" 5
3172 "FY09/10" .
3172 "FY09/10" .
3172 "FY09/10" .
3172 "FY10/11" .
3172 "FY10/11" .
3172 "FY10/11" 8
3172 "FY10/11" .
3172 "FY10/11" .
3172 "FY11/12" 8
3172 "FY12/13" 8
3172 "FY13/14" .
3653 "FY07/08" 4
3653 "FY08/09" 4
3653 "FY09/10" 4
3653 "FY10/11" 4
3653 "FY11/12" 4
3653 "FY12/13" 4
3653 "FY13/14" .
5625 "FY08/09" .
5625 "FY08/09" .
5625 "FY09/10" .
5625 "FY09/10" .
5625 "FY10/11" .
5625 "FY10/11" .
5625 "FY11/12" 5
5625 "FY12/13" 5
10045 "FY07/08" 4
10045 "FY08/09" 4
10045 "FY09/10" 4
10045 "FY10/11" 4
10045 "FY11/12" 4
10045 "FY12/13" 5
10045 "FY13/14" .
by personid (fin_year), sort: gen last_ptype = last_place_type[_N] if last_place_type !=.
[CODE]
* Example generated by -dataex-. To install: ssc install dataex
clear
input long personid str7 fin_year long last_place_type
2337 "FY10/11" 5
2337 "FY11/12" 5
2337 "FY11/12" .
2337 "FY12/13" .
3172 "FY09/10" .
3172 "FY09/10" 5
3172 "FY09/10" .
3172 "FY09/10" .
3172 "FY09/10" .
3172 "FY10/11" .
3172 "FY10/11" .
3172 "FY10/11" 8
3172 "FY10/11" .
3172 "FY10/11" .
3172 "FY11/12" 8
3172 "FY12/13" 8
3172 "FY13/14" .
3653 "FY07/08" 4
3653 "FY08/09" 4
3653 "FY09/10" 4
3653 "FY10/11" 4
3653 "FY11/12" 4
3653 "FY12/13" 4
3653 "FY13/14" .
5625 "FY08/09" .
5625 "FY08/09" .
5625 "FY09/10" .
5625 "FY09/10" .
5625 "FY10/11" .
5625 "FY10/11" .
5625 "FY11/12" 5
5625 "FY12/13" 5
10045 "FY07/08" 4
10045 "FY08/09" 4
10045 "FY09/10" 4
10045 "FY10/11" 4
10045 "FY11/12" 4
10045 "FY12/13" 5
10045 "FY13/14" .
Comment