I am new to this Forum and also had a long break of using SPSS - now would need some help to get back on track
I have a Panel dataset, with i.e. variables "Person ID" (multiple), "Age" (categorical groups), "Year"(categorical), "Profession"(categorical, i.e. 1=unemployed; 2=farmer,..). I have aggregated data at annual and person ID Basis, so it looks like this at the Moment:
Person ID | Year | Age | Profession
1 | 2009 | 2 | 1
1 | 2010 | 2 | 1
1 | 2011 | 2 | 2
1 | 2012 | 2 | 2
2 | 2009 | 3 | 2
Now, for the purposes of later, I would want to create a new binary/dummy variable indicating, whether there happened a change in individual person's profession sometime during the years 2009-2012 (1=Change, 0=No change in Profession). So, i.e. on the above, for Person ID 1 the new binary variable would be 1 in 2011 and otherwise 0.
How could I do this, to see how many of the persons (Person ID) have gone through a Change in Profession, and at which age/year? I can try to clarify in case needed. Thank you!