Thank you very much!!!  ... View more

Any ideas, please? ... View more

Here it is: ***DATA STEP TO CREATE LABS; DATA forecasts; LENGTH Forecast $ 6; INFORMAT FDATE MMDDYY10.; INFILE DATALINES MISSOVER; INPUT ANALYST FIRM FORECAST FDATE; FORMAT DATE MMDDYY10.; DATALINES; 01 23 4 01/03/1995 01 23 7 04/04/1997 01 24 400 03/04/1993 01 24 450 03/04/2000 01 24 300 11/05/2001 02 23 20 11/03/1994 02 23 2 01/03/1995 02 23 8 05/04/1997 02 24 420 04/04/1991 02 24 430 06/04/2000 02 24 310 07/05/2001 03 23 21 11/03/1992 03 23 5 01/03/1995 03 23 6 05/04/1997 03 24 420 04/04/1995 03 24 430 06/04/1998 03 24 310 06/05/2004 04 24 20 03/06/2007 04 24 24 12/12/2010 04 24 26 11/01/2011 ; ... View more

OK, a simplified example of the data could look like this   ***DATA STEP TO CREATE LABS; DATA forecasts; LENGTH Forecast $ 6; INFORMAT FDATE MMDDYY10.; INFILE DATALINES MISSOVER; INPUT ANALYST FIRM FORECAST FDATE; FORMAT DATE MMDDYY10.; DATALINES; 01 23 4 01/03/1995 01 23 7 04/04/1997 01 24 400 03/04/1993 01 24 450 03/04/2000 01 24 300 11/05/2001 02 23 20 11/03/1994 02 23 2 01/03/1995 02 23 8 05/04/1997 02 24 420 04/04/1991 02 24 430 06/04/2000 02 24 310 07/05/2001 03 23 21 11/03/1992 03 23 5 01/03/1995 03 23 6 05/04/1997 03 24 420 04/04/1995 03 24 430 06/04/1998 03 24 310 06/05/2004 04 24 20 03/06/2007 04 24 24 12/12/2010 ;  An example for relative general experience for the second line would be comuted like this: Analyst 01 submited his fist forecast in 1993 and therefore has been forecastin for 1993-1997 five years including the first one and has five years of general experience. At the same time, the oldest forecast for firm 23 was in 1995, therefore he has 3 years of firm specific experience.   I need to relate them to the other forecast. In 1997 also analysts 02 and 03 have submitted a forecast for firm 23. Analyst 04 hasn't, so I ignore him.   Their general experience (time form their first forecast in the dataset) is 1997-1991 + 1 = 7 years for analyst 02 and 1997-1992 + 1 = 6 for analyst 03. The average of all analysts is (5+7+6)/3=6 years and the relative general experience of analyst 01 is 5-6=-1.   Their firm specific experiences (time form their first forecast for firm 23 in the dataset) are 1997-1994 +1 = 4 for analyst 02 and 1997-1992 +1= 6 for analyst 03. The average of all analysts who submited a forecast for this firm in 1997 is (3+4+6)/3=4,33 and analyst 01 therefore has -1,33 years of relative firm specific experience.   I hope I explained it clear enough and you will be able to help me further. Thank you very much in advance!         ... View more