Hey statatlist,

I am working on a panel-dataset with footballplayers and their performance for each season.
Besides that I also have a dummy-variable which is 1 if the footballplayer gets sold the particular season.

Now what I could really need some support with:

1. I want to generate a variable that is a prediction of the performance after a transfer. I am using a fixed effect model to measure the effect of sold=1, and now I want the predicted performance after sold=1, if that makes sense?

2. I want to generate a dummy variable that is 1 if the performance for the particular season after the transfer is below the predicted performance and 0 if the performance is above the predicted performance.


I have the following variables:
SeasonID: Ranging from 1-6 (since I am working with up to 6 seasons per player)
PlayerID: Name of the player
Year: The season of interest (2011/2012, 2012/2013, etc.)
Sold: Dummy variable -> 1 if sold 0 if not
Performance: Performance-measure for each player per season


This is my first post, so if you need some sort of summary of my data please let me know.

Best regards,
Martin