means median for Built and major

[Khang]

I need to develop this table. Panel A  needs to calculate mean expenditure amount in event pre-event and post-event year. Where the event is the year in which value of built is 1 and value of acquis is 1. 

Panel B is for Median financing proportion during event year.

While Panel C is little different. Economic events are defined as major investments (Built, acquis) with adjacent event years, starting with a pre-event year and ending with a post-event year (e.g., a sequence in event time of [–1, 0, 0, +1] over 4 years). Thanking in anticipation.

data work.new;
  infile datalines dsd truncover;
  input FYEAR:BEST12. CUSIP:$10. DEBT:BEST12. EQUITY:BEST12. CASHFLOW:BEST12. OTHER:BEST12. BUILT:BEST12. ACQUISIT:BEST12.;
datalines;
1989,000021,0.55,0.095,0.282,,0,0
1990,000021,0.645,0.888,0.386,,0,0
1991,000021,1.012,1.53,-0.092,,0,0
1992,000021,6.796,7.797,-1.58,,1,0
1993,000021,0.839,0.471,-0.96,,0,0
1994,000021,-0.231,1.289,-1.308,,0,0
1995,000021,1.114,0,-0.899,,0,0
1996,000021,0.922,0,-1.971,,0,0
1997,000021,-0.744,0.75,-3.829,,0,0
1998,000021,0.701,6.406,-5.677,,0,0
1989,000209,,0.152,16.496,,1,0
1990,000209,-9.905,-1.259,17.242,,0,0
1991,000209,-15.345,0.906,15.211,,0,0
1992,000209,-7,3.519,9.78,,0,0
2002,000255,10,83.4,-0.382,,0,0
2003,000255,0,0,-1.055,,0,0
2004,000255,0,0,-0.327,,0,0
2005,000255,0,0,0.439,,0,0
2006,000255,0,0,1.456,,0,0
1990,000360,0.835,0.113,0.879,,0,0
1991,000360,-3.37,0,0.742,,0,0
1992,000360,0.663,0,2.63,,0,0
1993,000360,2.655,0,3.747,,0,0
1994,000360,,0.01,6.902,,1,0
1995,000360,,0.016,4.137,,0,0
1996,000360,,0.019,5.097,,0,0
1997,000360,,0.107,5.651,,0,0
1998,000360,,0.252,8.079,,0,0
1999,000360,,-0.635,12.76,,0,0
2000,000360,,-9.96,16.267,,0,1
2001,000360,,-2.112,17.43,,0,0
2002,000360,,-3.116,15.578,,0,0
2003,000360,1.79,-9.518,18.547,,0,0
2004,000360,-5.356,-4.501,18.445,,0,0
2005,000360,-0.108,-4.092,20.122,,0,0
2006,000360,,-2.599,24.35,,0,0
1989,000361,,0,28.44,,0,1
1990,000361,,-2.326,21.348,,0,0
1991,000361,,0,13.32,,0,0
1992,000361,,-1.164,3.547,,0,0
1993,000361,,,-4.042,,0,0
1994,000361,,,8.728,,0,0
1995,000361,,,7.332,,0,0
1996,000361,-1.474,,9.237,,0,0
1997,000361,,1.642,75.305,,0,0
1998,000361,,,58.331,,0,0
1999,000361,,,51.327,,0,0
2000,000361,,,15.383,,0,0
2001,000361,,34.129,-61.586,,1,0
2002,000361,,0,19.333,,0,0
;;;;

[Khang]

No one here to reply to my Question?