DATA Step, Macro, Functions and more

Calculate quarterly growth rate for panel data

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 76
Accepted Solution

Calculate quarterly growth rate for panel data

I am trying to calculate seasonal quarterly growth rate for panel data. That means sales of Q4 over sales of Q4 in the prior year. 

 

data HAVE;
  infile datalines dsd truncover;
  input DATADATE:DATE9. GVKEY:$6. DATAFQTR:$6. SALEQ:F18.4;
  format DATADATE DATE9. SALEQ F18.4;
  label DATADATE="Data Date" firmid="Firm Identifier" DATAFQTR="Fiscal Data Year and Quarter" SALEQ="Sales";
datalines4;
30SEP1986,012994,1987Q1,1.7450
31DEC1986,012994,1987Q2,5.4490
31MAR1987,012994,1987Q3,6.4420
30JUN1987,012994,1987Q4,2.9850
30SEP1987,012994,1988Q1,1.7250
31DEC1987,012994,1988Q2,5.4530
31MAR1988,012994,1988Q3,7.1790
30JUN1989,012994,1989Q4,4.8260
30SEP1989,012994,1990Q1,2.8830
31DEC1989,012994,1990Q2,7.6150
31MAR1990,012994,1990Q3,8.3500
30JUN1990,012994,1990Q4,4.3790
30SEP1990,012994,1991Q1,2.4030
31DEC1990,012994,1991Q2,8.4950
31MAR1991,012994,1991Q3,8.4520
30JUN1991,012994,1991Q4,4.4990
30SEP1991,012994,1992Q1,2.7710
31DEC1991,012994,1992Q2,8.3330
31MAR1992,012994,1992Q3,8.1240
30JUN1992,012994,1992Q4,3.7220
30SEP1992,012994,1993Q1,3.2550
31DEC1992,012994,1993Q2,8.5980
31MAR1993,012994,1993Q3,11.7180
30JUN1993,012994,1993Q4,4.0580
30SEP1993,012994,1994Q1,3.9780
31DEC1993,012994,1994Q2,9.1720
31MAR1994,012994,1994Q3,9.7680
30JUN1994,012994,1994Q4,4.7620
30SEP1994,012994,1995Q1,3.7100
31DEC1994,012994,1995Q2,10.5370
31MAR1995,012994,1995Q3,11.2660
30JUN1995,012994,1995Q4,5.0350
30SEP1995,012994,1996Q1,3.9170
31DEC1995,012994,1996Q2,9.6400
31MAR1996,012994,1996Q3,12.1300
30JUN1996,012994,1996Q4,5.6310
30SEP1996,012994,1997Q1,4.5920
31DEC1996,012994,1997Q2,13.6610
31MAR1997,012994,1997Q3,15.9220
30JUN1997,012994,1997Q4,4.0400
30SEP1997,012994,1998Q1,5.2250
31DEC1997,012994,1998Q2,12.1450
31MAR1998,012994,1998Q3,15.9210
30JUN1999,012994,1999Q4,13.4280
30SEP1999,012994,2000Q1,12.5760
31DEC1999,012994,2000Q2,19.1400
31MAR2000,012994,2000Q3,23.8620
30JUN2000,012994,2000Q4,16.6180
30SEP2000,012994,2001Q1,16.4190
31DEC2000,012994,2001Q2,28.5280
31MAR2001,012994,2001Q3,39.9880
30JUN2001,012994,2001Q4,35.2260
30SEP2001,012994,2002Q1,16.8080
31DEC2001,012994,2002Q2,26.4590
31MAR2002,012994,2002Q3,36.9350
30JUN2002,012994,2002Q4,9.9700
30SEP2002,012994,2003Q1,10.3630
31DEC2002,012994,2003Q2,22.4850
31MAR2003,012994,2003Q3,29.6170
30JUN2003,012994,2003Q4,15.4330
30SEP2003,012994,2004Q1,12.4870
31DEC2003,012994,2004Q2,22.6260
31MAR2004,012994,2004Q3,24.4470
30JUN2004,012994,2004Q4,13.7310
30SEP2004,012994,2005Q1,12.0390
31DEC2004,012994,2005Q2,23.1160
31MAR2005,012994,2005Q3,27.4390
30JUN2005,012994,2005Q4,14.1150
30SEP2005,012994,2006Q1,10.2910
31DEC2005,012994,2006Q2,25.4140
31MAR2006,012994,2006Q3,27.5750
30JUN2006,012994,2006Q4,11.4150
30SEP2006,012994,2007Q1,8.4560
31DEC2006,012994,2007Q2,18.0560
31MAR2007,012994,2007Q3,21.5330
30JUN2007,012994,2007Q4,11.3280
31MAR2008,012994,2008Q1,30.8780
30JUN2008,012994,2008Q2,17.6420
30SEP2008,012994,2008Q3,13.9870
31DEC2008,012994,2008Q4,25.9620
31MAR2009,012994,2009Q1,31.3340
30JUN2009,012994,2009Q2,12.2380
30SEP2009,012994,2009Q3,8.3260
31DEC2009,012994,2009Q4,19.5560
31MAR2010,012994,2010Q1,34.7330
30JUN2010,012994,2010Q2,16.6560
30SEP2010,012994,2010Q3,10.9020
31DEC2010,012994,2010Q4,29.2090
31MAR2011,012994,2011Q1,40.1510
30JUN2011,012994,2011Q2,18.6730
30SEP2011,012994,2011Q3,12.3210
31DEC2011,012994,2011Q4,28.0720
31MAR2012,012994,2012Q1,33.7720
30JUN2012,012994,2012Q2,12.0350
30SEP2012,012994,2012Q3,12.3630
31DEC2012,012994,2012Q4,31.0310
31MAR2013,012994,2013Q1,43.6150
30JUN2013,012994,2013Q2,15.8820
30SEP2013,012994,2013Q3,13.6170
31DEC2013,012994,2013Q4,36.2860
31MAR2014,012994,2014Q1,61.4970
30JUN2014,012994,2014Q2,20.5000
30SEP2014,012994,2014Q3,13.6150
31DEC2014,012994,2014Q4,36.9580
31MAR2015,012994,2015Q1,53.7330
30JUN2015,012994,2015Q2,16.0460
30SEP2015,012994,2015Q3,13.0840
31DEC2015,012994,2015Q4,29.4980
31MAR2016,012994,2016Q1,38.3070
30JUN2016,012994,2016Q2,17.0330
30SEP2016,012994,2016Q3,13.3550
31DEC2016,012994,2016Q4,30.7460
31MAR2017,012994,2017Q1,39.8590
31MAR1994,019049,1994Q1,4.0920
30JUN1994,019049,1994Q2,4.3040
30SEP1994,019049,1994Q3,4.4640
31DEC1994,019049,1994Q4,4.6220
31MAR1995,019049,1995Q1,4.7340
30JUN1995,019049,1995Q2,5.0750
30SEP1995,019049,1995Q3,5.1700
31DEC1995,019049,1995Q4,5.3590
31MAR1996,019049,1996Q1,5.3000
30JUN1996,019049,1996Q2,5.2210
30SEP1996,019049,1996Q3,5.3740
31DEC1996,019049,1996Q4,6.5310
31MAR1997,019049,1997Q1,6.9990
30JUN1997,019049,1997Q2,7.1330
30SEP1997,019049,1997Q3,7.2500
31DEC1997,019049,1997Q4,7.6160
31MAR1998,019049,1998Q1,8.7680
30JUN1998,019049,1998Q2,11.5380
30SEP1998,019049,1998Q3,10.8840
30SEP1998,019049,1998Q3,10.8840
31DEC1998,019049,1998Q4,11.3950
31MAR1999,019049,1999Q1,10.8830
30JUN1999,019049,1999Q2,11.0760
30SEP1999,019049,1999Q3,11.2730
31DEC1999,019049,1999Q4,11.6020
31MAR2000,019049,2000Q1,11.7040
30JUN2000,019049,2000Q2,12.1460
30SEP2000,019049,2000Q3,12.3880
31DEC2000,019049,2000Q4,12.5740
31MAR2001,019049,2001Q1,12.3330
30JUN2001,019049,2001Q2,12.0040
30SEP2001,019049,2001Q3,11.5310
31DEC2001,019049,2001Q4,10.7900
31MAR2002,019049,2002Q1,10.2040
30JUN2002,019049,2002Q2,11.1190
30SEP2002,019049,2002Q3,11.3960
31DEC2002,019049,2002Q4,10.7560
31MAR2003,019049,2003Q1,10.0430
30JUN2003,019049,2003Q2,9.8760
30SEP2003,019049,2003Q3,9.4950
31DEC2003,019049,2003Q4,9.1690
31MAR2004,019049,2004Q1,14.1710
30JUN2004,019049,2004Q2,14.5690
30SEP2004,019049,2004Q3,15.5370
31DEC2004,019049,2004Q4,17.1530
31MAR2005,019049,2005Q1,18.1100
30JUN2005,019049,2005Q2,20.4710
30SEP2005,019049,2005Q3,22.0440
30SEP2005,019049,2005Q3,22.0440
30SEP2005,019049,2005Q3,22.0440
31DEC2005,019049,2005Q4,23.2670
31MAR2006,019049,2006Q1,23.3520
30JUN2006,019049,2006Q2,24.5700
30SEP2006,019049,2006Q3,26.0310
31DEC2006,019049,2006Q4,25.8550
31MAR2007,019049,2007Q1,26.7410
30JUN2007,019049,2007Q2,27.1030
30SEP2007,019049,2007Q3,26.0760
31DEC2007,019049,2007Q4,38.7260
31MAR2008,019049,2008Q1,37.7070
30JUN2008,019049,2008Q2,32.8350
30SEP2008,019049,2008Q3,30.8530
31DEC2008,019049,2008Q4,29.6520
31MAR2009,019049,2009Q1,28.8630
30JUN2009,019049,2009Q2,26.0240
30SEP2009,019049,2009Q3,27.1180
31DEC2009,019049,2009Q4,26.8530
31MAR2010,019049,2010Q1,26.1440
30JUN2010,019049,2010Q2,26.2890
30SEP2010,019049,2010Q3,25.8410
31DEC2010,019049,2010Q4,26.2060
31MAR2011,019049,2011Q1,25.1990
30JUN2011,019049,2011Q2,25.7290
30SEP2011,019049,2011Q3,25.4860
31DEC2011,019049,2011Q4,24.5300
31MAR2012,019049,2012Q1,23.9010
30JUN2012,019049,2012Q2,22.4410
30SEP2012,019049,2012Q3,21.3130
31MAR1994,016950,1994Q1,6.4050
30SEP1995,016950,1995Q3,6.2590
31DEC1979,001010,1979Q4,259.5590
31MAR1980,001010,1980Q1,268.8180
30JUN1980,001010,1980Q2,265.6770
30SEP1980,001010,1980Q3,233.5570
31DEC1980,001010,1980Q4,284.7610
31MAR1981,001010,1981Q1,231.6130
30JUN1981,001010,1981Q2,193.3370
30SEP1981,001010,1981Q3,246.5400
31DEC1981,001010,1981Q4,276.8560
31MAR1982,001010,1982Q1,237.4250
30JUN1982,001010,1982Q2,231.2020
30SEP1982,001010,1982Q3,165.7220
31DEC1982,001010,1982Q4,157.1520
31MAR1983,001010,1983Q1,105.0910
30JUN1983,001010,1983Q2,136.5170
30SEP1983,001010,1983Q3,141.6670
31DEC1983,001010,1983Q4,159.9470
31MAR1984,001010,1984Q1,0.0000
31MAR1986,009636,1986Q3,1.5830
31MAR1989,009636,1989Q3,1.9810
30JUN1989,009636,1989Q4,1.5110
30SEP1989,009636,1990Q1,2.9630
30JUN1986,012165,1986Q3,13.2290
30SEP1986,012165,1986Q4,7.4120
31DEC1986,012165,1987Q1,6.1270
31MAR1987,012165,1987Q2,16.4950
30JUN1987,012165,1987Q3,18.7280
30SEP1987,012165,1987Q4,12.7060
31DEC1987,012165,1988Q1,9.4630
31MAR1988,012165,1988Q2,18.0520
30JUN1988,012165,1988Q3,23.8620
30JUN1994,016739,1994Q2,8.0400
30SEP1994,016739,1994Q3,8.2890
31DEC1994,016739,1994Q4,8.5800
31MAR1995,016739,1995Q1,8.7160
30JUN1995,016739,1995Q2,9.0460
30SEP1995,016739,1995Q3,9.1780
31DEC1995,016739,1995Q4,9.2340
31MAR1996,016739,1996Q1,9.1050
30JUN1996,016739,1996Q2,9.6770
30SEP1996,016739,1996Q3,8.8270
31DEC1996,016739,1996Q4,9.8890
31MAR1997,016739,1997Q1,9.8360
30JUN1997,016739,1997Q2,10.1720
30SEP1997,016739,1997Q3,10.3210
31DEC1997,016739,1997Q4,10.4200
31MAR1998,016739,1998Q1,10.4620
30JUN1998,016739,1998Q2,10.7140
30SEP1998,016739,1998Q3,10.9140
31DEC1998,016739,1998Q4,11.0310
31MAR1999,016739,1999Q1,10.6130
30JUN1999,016739,1999Q2,11.0210
30SEP1999,016739,1999Q3,11.3090
31DEC1999,016739,1999Q4,11.5230
31MAR2000,016739,2000Q1,11.4420
30JUN2000,016739,2000Q2,11.7290
31OCT1986,012622,1986Q4,2.3720
31JAN1987,012622,1987Q1,3.4080
30APR1987,012622,1987Q2,3.3910
31JUL1987,012622,1987Q3,3.6250
31OCT1987,012622,1987Q4,4.3200
31JAN1988,012622,1988Q1,5.0450
30APR1988,012622,1988Q2,5.3320
31JUL1988,012622,1988Q3,5.3750
31OCT1988,012622,1988Q4,5.0850
31JAN1989,012622,1989Q1,4.4920
30APR1989,012622,1989Q2,5.4720
31JUL1989,012622,1989Q3,5.7480
31OCT1989,012622,1989Q4,5.5400
31JAN1990,012622,1990Q1,5.3960
30APR1990,012622,1990Q2,6.4790
31JUL1990,012622,1990Q3,7.4680
31OCT1990,012622,1990Q4,8.2980
31JAN1991,012622,1991Q1,9.2530
30APR1991,012622,1991Q2,10.0560
31JUL1991,012622,1991Q3,10.5810
31OCT1991,012622,1991Q4,10.7710
31JAN1992,012622,1992Q1,10.8470
30APR1992,012622,1992Q2,12.5640
31JUL1992,012622,1992Q3,12.6910
31OCT1992,012622,1992Q4,18.8960
31JAN1993,012622,1993Q1,18.0950
30APR1993,012622,1993Q2,17.8240
31JUL1993,012622,1993Q3,17.4500
31OCT1993,012622,1993Q4,16.1910
31JAN1994,012622,1994Q1,16.7160
30APR1994,012622,1994Q2,17.1860
31JUL1994,012622,1994Q3,16.3630
31OCT1994,012622,1994Q4,17.8320
31JAN1995,012622,1995Q1,15.7330
30APR1995,012622,1995Q2,16.5000
30NOV1988,014453,1988Q3,2.1480
28FEB1989,014453,1988Q4,1.7270
31MAY1989,014453,1989Q1,2.2840
28FEB1990,014453,1989Q4,1.8770
31MAY1990,014453,1990Q1,2.5740
31AUG1990,014453,1990Q2,3.2290
30NOV1990,014453,1990Q3,2.6040
31AUG1991,014453,1991Q2,2.9450
30NOV1991,014453,1991Q3,2.8750
29FEB1992,014453,1991Q4,2.6650
31MAY1992,014453,1992Q1,2.9980
31AUG1992,014453,1992Q2,5.1590
31AUG1993,014453,1993Q2,7.3970
30NOV1993,014453,1993Q3,7.0750
28FEB1994,014453,1993Q4,7.4640
31MAY1994,014453,1994Q1,8.1680
31AUG1994,014453,1994Q2,8.7210
30NOV1994,014453,1994Q3,9.2290
28FEB1995,014453,1994Q4,10.1540
31MAY1995,014453,1995Q1,10.8150
31AUG1995,014453,1995Q2,11.6490
31MAY1996,014453,1996Q1,16.6460
31AUG1996,014453,1996Q2,33.9220
30NOV1996,014453,1996Q3,32.8490
28FEB1997,014453,1996Q4,30.4380
31MAY1997,014453,1997Q1,31.3750
31AUG1997,014453,1997Q2,34.7220
30NOV1997,014453,1997Q3,38.1660
28FEB1986,011907,1985Q4,1.6520
31MAY1986,011907,1986Q1,0.5190
31AUG1986,011907,1986Q2,1.3260
30NOV1986,011907,1986Q3,0.7570
31MAY1987,011907,1987Q1,1.2940
31AUG1987,011907,1987Q2,1.6210
30NOV1987,011907,1987Q3,1.4410
29FEB1988,011907,1987Q4,1.6490
31MAY1988,011907,1988Q1,1.8300
31AUG1988,011907,1988Q2,1.4870
30NOV1988,011907,1988Q3,1.8810
28FEB1989,011907,1988Q4,1.8110
31MAY1989,011907,1989Q1,2.0530
31AUG1989,011907,1989Q2,1.7780
30NOV1989,011907,1989Q3,1.8260
28FEB1990,011907,1989Q4,1.4220
31MAY1990,011907,1990Q1,2.3310
28FEB1991,011907,1990Q4,1.9350
29FEB1992,011907,1991Q4,1.0830
31MAY1992,011907,1992Q1,1.9240
31AUG1992,011907,1992Q2,2.0520
30NOV1992,011907,1992Q3,1.6670
28FEB1993,011907,1992Q4,1.6780
31MAY1993,011907,1993Q1,2.7210
31AUG1993,011907,1993Q2,3.0800
30NOV1993,011907,1993Q3,2.2480
28FEB1994,011907,1993Q4,3.1560
30NOV1994,011907,1994Q3,2.7810
28FEB1995,011907,1994Q4,3.1930
31MAY1995,011907,1995Q1,4.2300
31AUG1995,011907,1995Q2,4.4400
30NOV1995,011907,1995Q3,4.5170
29FEB1996,011907,1995Q4,4.8190
31MAY1996,011907,1996Q1,4.0640
31AUG1996,011907,1996Q2,3.6440
30NOV1996,011907,1996Q3,2.8550
28FEB1997,011907,1996Q4,3.4610
31MAY1997,011907,1997Q1,3.4490
31AUG1997,011907,1997Q2,4.5710
30NOV1997,011907,1997Q3,3.2680
28FEB1998,011907,1997Q4,2.1760
31MAY1998,011907,1998Q1,2.2050
31AUG1998,011907,1998Q2,2.7750
30NOV1998,011907,1998Q3,3.4170
28FEB1999,011907,1998Q4,4.2070
31MAY1999,011907,1999Q1,6.0410
31AUG1999,011907,1999Q2,7.3560
30NOV1999,011907,1999Q3,7.5440
29FEB2000,011907,1999Q4,6.5190
31MAY2000,011907,2000Q1,10.9800
31AUG2000,011907,2000Q2,7.2050
30NOV2000,011907,2000Q3,9.6490
28FEB2001,011907,2000Q4,7.9890
31MAY2001,011907,2001Q1,7.4530
31AUG2001,011907,2001Q2,8.2010
30NOV2001,011907,2001Q3,6.2610
28FEB2002,011907,2001Q4,8.5900
31MAY2002,011907,2002Q1,11.9370
31AUG2002,011907,2002Q2,10.8830
30NOV2002,011907,2002Q3,5.4200
28FEB2003,011907,2002Q4,6.2490
31MAY2003,011907,2003Q1,0.0000
31AUG2003,011907,2003Q2,0.0000
30NOV2003,011907,2003Q3,0.0220
29FEB2004,011907,2003Q4,0.0740
31MAY2004,011907,2004Q1,0.4000
31AUG2004,011907,2004Q2,0.2230
30NOV2004,011907,2004Q3,0.3340
28FEB2005,011907,2004Q4,0.4690
31MAY2005,011907,2005Q1,0.2640
31DEC1983,001001,1983Q4,8.1660
31MAR1984,001001,1984Q1,6.4340
30JUN1984,001001,1984Q2,7.5590
30SEP1984,001001,1984Q3,8.0580
31DEC1984,001001,1984Q4,9.9560
31MAR1985,001001,1985Q1,7.8650
30JUN1985,001001,1985Q2,9.3480
30SEP1985,001001,1985Q3,16.3270
31MAR1986,004641,1986Q1,220.4790
31MAR1986,004641,1986Q1,220.4790
30JUN1986,004641,1986Q2,234.4120
30JUN1986,004641,1986Q2,234.4120
30SEP1986,004641,1986Q3,222.1860
30SEP1986,004641,1986Q3,222.1860
31DEC1986,004641,1986Q4,242.7410
31DEC1986,004641,1986Q4,242.7410
31MAR1987,004641,1987Q1,237.7800
31MAR1987,004641,1987Q1,237.7800
30JUN1987,004641,1987Q2,247.6720
30JUN1987,004641,1987Q2,247.6720
30SEP1987,004641,1987Q3,241.8780
30SEP1987,004641,1987Q3,241.8780
31DEC1987,004641,1987Q4,295.3620
31DEC1987,004641,1987Q4,295.3620
31MAR1988,004641,1988Q1,273.9650
31MAR1988,004641,1988Q1,273.9650
30JUN1988,004641,1988Q2,294.3310
30JUN1988,004641,1988Q2,294.3310
30SEP1988,004641,1988Q3,276.8130
30SEP1988,004641,1988Q3,276.8130
31DEC1988,004641,1988Q4,340.3050
31DEC1988,004641,1988Q4,340.3050
31MAR1989,004641,1989Q1,320.3550
31MAR1989,004641,1989Q1,320.3550
30JUN1989,004641,1989Q2,333.4680
30JUN1989,004641,1989Q2,333.4680
30SEP1989,004641,1989Q3,311.2810
30SEP1989,004641,1989Q3,311.2810
31DEC1989,004641,1989Q4,348.3800
31DEC1989,004641,1989Q4,348.3800
31MAR1990,004641,1990Q1,340.4130
31MAR1990,004641,1990Q1,340.4130
30JUN1990,004641,1990Q2,342.5110
30JUN1990,004641,1990Q2,342.5110
30SEP1990,004641,1990Q3,321.4220
30SEP1990,004641,1990Q3,321.4220
31DEC1990,004641,1990Q4,356.6130
31DEC1990,004641,1990Q4,356.6130
31MAR1991,004641,1991Q1,314.4550
31MAR1991,004641,1991Q1,314.4550
30JUN1991,004641,1991Q2,313.8800
30JUN1991,004641,1991Q2,313.8800
30SEP1991,004641,1991Q3,282.9280
30SEP1991,004641,1991Q3,282.9280
31DEC1991,004641,1991Q4,332.2230
31DEC1991,004641,1991Q4,332.2230
31MAR1992,004641,1992Q1,298.4610
31MAR1992,004641,1992Q1,298.4610
30JUN1992,004641,1992Q2,286.1270
30JUN1992,004641,1992Q2,286.1270
30SEP1992,004641,1992Q3,7.4420
30SEP1992,004641,1992Q3,7.4420
31DEC1992,004641,1992Q4,200.3790
31DEC1992,004641,1992Q4,200.3790
31MAR1993,004641,1993Q1,281.8090
31MAR1993,004641,1993Q1,281.8090
30JUN1993,004641,1993Q2,292.3830
30JUN1993,004641,1993Q2,292.3830
30SEP1993,004641,1993Q3,0.1930
30SEP1993,004641,1993Q3,0.1930
31DEC1993,004641,1993Q4,194.2570
31DEC1993,004641,1993Q4,194.2570
31MAR1994,004641,1994Q1,73.1110
31MAR1994,004641,1994Q1,73.1110
30JUN1994,004641,1994Q2,80.0300
30JUN1994,004641,1994Q2,80.0300
30SEP1994,004641,1994Q3,79.7920
30SEP1994,004641,1994Q3,79.7920
31DEC1994,004641,1994Q4,86.4870
31DEC1994,004641,1994Q4,86.4870
31MAR1995,004641,1995Q1,85.2660
31MAR1995,004641,1995Q1,85.2660
30JUN1995,004641,1995Q2,80.5720
30JUN1995,004641,1995Q2,80.5720
30SEP1995,004641,1995Q3,87.2860
30SEP1995,004641,1995Q3,87.2860
31DEC1995,004641,1995Q4,87.6940
31DEC1995,004641,1995Q4,87.6940
31MAR1996,004641,1996Q1,55.3880
31MAR1996,004641,1996Q1,55.3880
30JUN1996,004641,1996Q2,56.4290
30JUN1996,004641,1996Q2,56.4290
30SEP1996,004641,1996Q3,57.6110
30SEP1996,004641,1996Q3,57.6110
31DEC1996,004641,1996Q4,57.7930
31DEC1996,004641,1996Q4,57.7930
31MAR1997,004641,1997Q1,62.6510
31MAR1997,004641,1997Q1,62.6510
30JUN1997,004641,1997Q2,18.0160
30JUN1997,004641,1997Q2,18.0160
30SEP1997,004641,1997Q3,38.0840
30SEP1997,004641,1997Q3,38.0840
31DEC1997,004641,1997Q4,63.0280
31DEC1997,004641,1997Q4,63.0280
31MAR1998,004641,1998Q1,46.2140
31MAR1998,004641,1998Q1,46.2140
30JUN1998,004641,1998Q2,45.9640
30JUN1998,004641,1998Q2,45.9640
30SEP1998,004641,1998Q3,43.1970
30SEP1998,004641,1998Q3,43.1970
31DEC1998,004641,1998Q4,41.7330
31DEC1998,004641,1998Q4,41.7330
31MAR1999,004641,1999Q1,48.7530
30JUN1999,004641,1999Q2,50.1930
30SEP1999,004641,1999Q3,49.9980
31DEC1999,004641,1999Q4,52.5970
31MAR2000,004641,2000Q1,61.7520
30JUN2000,004641,2000Q2,66.1350
30SEP2000,004641,2000Q3,66.9190
31DEC2000,004641,2000Q4,69.1750
31MAR2001,004641,2001Q1,75.5220
31JAN1987,012678,1987Q2,60.8170
30APR1987,012678,1987Q3,64.1330
31JUL1987,012678,1987Q4,68.5910
31OCT1987,012678,1988Q1,66.9490
31JAN1988,012678,1988Q2,65.6640
30APR1988,012678,1988Q3,69.2350
31JUL1988,012678,1988Q4,61.2240
31JUL1992,011881,1992Q3,2.1150
31OCT1992,011881,1992Q4,2.0940
31JAN1993,011881,1993Q1,8.6410
31OCT1993,011881,1993Q4,6.5450
31JAN1994,011881,1994Q1,5.7500
30APR1994,011881,1994Q2,6.3570
31JUL1994,011881,1994Q3,6.6540
31OCT1994,011881,1994Q4,6.6010
31MAR1986,011908,1986Q3,9.4880
30JUN1986,011908,1986Q4,9.8140
31MAR1987,011908,1987Q3,7.9450
30JUN1987,011908,1987Q4,9.8520
30SEP1987,011908,1988Q1,9.0450
31DEC1987,011908,1988Q2,9.6780
31MAR1988,011908,1988Q3,8.7710
30JUN1988,011908,1988Q4,10.4520
30SEP1988,011908,1989Q1,10.1140
31DEC1988,011908,1989Q2,11.9630
31MAR1989,011908,1989Q3,12.2080
30JUN1989,011908,1989Q4,14.4710
30SEP1989,011908,1990Q1,12.6790
31DEC1989,011908,1990Q2,12.0880
31MAR1990,011908,1990Q3,13.1770
30JUN1990,011908,1990Q4,14.0820
30SEP1990,011908,1991Q1,12.2720
31DEC1990,011908,1991Q2,12.2140
31MAR1991,011908,1991Q3,12.1680
30JUN1991,011908,1991Q4,12.0510
30SEP1991,011908,1992Q1,9.5400
31DEC1992,011908,1993Q2,15.7220
31MAR1993,011908,1993Q3,14.2610
30JUN1993,011908,1993Q4,18.0850
30SEP1993,011908,1994Q1,15.1530
31DEC1993,011908,1994Q2,16.9730
31MAR1994,011908,1994Q3,15.6290
30JUN1994,011908,1994Q4,17.3180
30SEP1994,011908,1995Q1,17.1960
31DEC1995,011908,1996Q2,23.5070
31MAR1996,011908,1996Q3,22.8020
30JUN1996,011908,1996Q4,23.8310
30SEP1996,011908,1997Q1,23.2580
31DEC1996,011908,1997Q2,26.9870
31MAR1997,011908,1997Q3,26.2380
30JUN1997,011908,1997Q4,27.0340
30SEP1997,011908,1998Q1,25.5210
31DEC1997,011908,1998Q2,27.5390
31MAR1998,011908,1998Q3,45.7780
30JUN1998,011908,1998Q4,49.2310
30JUN1999,011908,1999Q1,33.9910
30SEP1999,011908,1999Q2,34.7050
31DEC1999,011908,1999Q3,35.2650
31MAR2000,011908,1999Q4,37.9300
30JUN2000,011908,2000Q1,34.5460
30SEP2000,011908,2000Q2,35.8620
31DEC2000,011908,2000Q3,34.5120
31MAR2001,011908,2000Q4,36.6060
30JUN2001,011908,2001Q1,31.8580
30SEP2001,011908,2001Q2,30.1060
31DEC2001,011908,2001Q3,26.3040
30JUN1992,013073,1992Q2,65.6320
30SEP1992,013073,1992Q3,64.6110
31DEC1992,013073,1992Q4,63.5350
30SEP1995,012115,1995Q3,2.1940
31JUL1986,004008,1986Q1,0.6420
30APR1987,004008,1986Q4,0.7630
30APR1986,011903,1986Q2,14.6860
31JUL1986,011903,1986Q3,14.3540
31OCT1986,011903,1986Q4,18.2070
31JAN1987,011903,1987Q1,14.2030
30APR1987,011903,1987Q2,16.9060
31JUL1987,011903,1987Q3,17.9970
31OCT1987,011903,1987Q4,20.8750
31JAN1988,011903,1988Q1,21.1510
30APR1988,011903,1988Q2,24.6750
31JUL1988,011903,1988Q3,24.9200
31OCT1988,011903,1988Q4,29.9140
31JAN1989,011903,1989Q1,29.6610
30APR1989,011903,1989Q2,30.8110
31JUL1989,011903,1989Q3,29.1480
31OCT1989,011903,1989Q4,31.3390
31JAN1990,011903,1990Q1,26.8550
30APR1990,011903,1990Q2,27.4120
31JUL1990,011903,1990Q3,28.9040
31OCT1990,011903,1990Q4,36.0960
31JAN1991,011903,1991Q1,31.6360
30APR1991,011903,1991Q2,32.2390
31JUL1991,011903,1991Q3,33.1690
31OCT1991,011903,1991Q4,36.4040
31JAN1992,011903,1992Q1,31.0280
30APR1992,011903,1992Q2,33.7480
31JUL1992,011903,1992Q3,37.6560
31OCT1992,011903,1992Q4,40.1890
31JAN1993,011903,1993Q1,32.4160
30APR1993,011903,1993Q2,38.9710
31JUL1993,011903,1993Q3,40.3240
31OCT1993,011903,1993Q4,41.5960
31JAN1994,011903,1994Q1,39.1080
30APR1994,011903,1994Q2,43.0460
31JUL1994,011903,1994Q3,46.8950
31OCT1994,011903,1994Q4,55.6200
31JAN1995,011903,1995Q1,58.6870
30APR1995,011903,1995Q2,58.3470
31JUL1995,011903,1995Q3,64.2180
31OCT1995,011903,1995Q4,61.6340
31JAN1996,011903,1996Q1,54.7700
30APR1996,011903,1996Q2,55.8210
31JUL1996,011903,1996Q3,63.9070
31OCT1996,011903,1996Q4,96.0360
31JAN1997,011903,1997Q1,181.6860
30APR1997,011903,1997Q2,190.3020
31JUL1997,011903,1997Q3,198.0310
31OCT1997,011903,1997Q4,189.1040
31JAN1998,011903,1998Q1,168.3780
30APR1998,011903,1998Q2,169.6670
31JUL1998,011903,1998Q3,164.8560
31OCT1998,011903,1998Q4,163.6550
31JAN1999,011903,1999Q1,151.8980
30APR1999,011903,1999Q2,165.7540
31JUL1999,011903,1999Q3,172.7860
31OCT1999,011903,1999Q4,179.6140
31JAN2000,011903,2000Q1,163.8460
30APR2000,011903,2000Q2,184.1390
31JUL2000,011903,2000Q3,178.1600
31OCT2000,011903,2000Q4,175.1760
31JAN2001,011903,2001Q1,156.4990
30APR2001,011903,2001Q2,164.5340
31JUL2001,011903,2001Q3,157.5540
31OCT2001,011903,2001Q4,161.1130
31JAN2002,011903,2002Q1,148.5360
30APR2002,011903,2002Q2,161.0150
31JUL2002,011903,2002Q3,173.6820
31OCT2002,011903,2002Q4,177.3450
31JAN2003,011903,2003Q1,169.7720
30APR2003,011903,2003Q2,184.2580
31JUL2003,011903,2003Q3,186.1600
31OCT2003,011903,2003Q4,204.8220
31JAN2004,011903,2004Q1,139.7590
30APR2004,011903,2004Q2,156.5150
31JUL2004,011903,2004Q3,144.6690
31OCT2004,011903,2004Q4,167.2850
31JAN2005,011903,2005Q1,171.3730
30APR2005,011903,2005Q2,179.1720
31JUL2005,011903,2005Q3,179.3980
31OCT2005,011903,2005Q4,202.7810
31JAN2006,011903,2006Q1,192.7600
30APR2006,011903,2006Q2,193.2510
31JUL2006,011903,2006Q3,208.9250
31OCT2006,011903,2006Q4,207.1730
31JAN2007,011903,2007Q1,151.6080
30APR2007,011903,2007Q2,158.2730
31JUL2007,011903,2007Q3,173.8120
31OCT2007,011903,2007Q4,182.6250
31JAN2008,011903,2008Q1,173.6980
30APR2008,011903,2008Q2,181.2030
31JUL2008,011903,2008Q3,207.0200
31OCT2008,011903,2008Q4,200.3100
31JAN2009,011903,2009Q1,180.2120
30APR2009,011903,2009Q2,182.5670
31JUL2009,011903,2009Q3,189.7500
31OCT2009,011903,2009Q4,192.2900
31JAN2010,011903,2010Q1,157.1700
30APR2010,011903,2010Q2,215.6620
31JUL2010,011903,2010Q3,204.8700
31OCT2010,011903,2010Q4,222.8680
31JAN2011,011903,2011Q1,217.7270
30APR2011,011903,2011Q2,248.5400
31JUL2011,011903,2011Q3,246.3850
31OCT2011,011903,2011Q4,262.1400
31JAN2012,011903,2012Q1,267.6640
30APR2012,011903,2012Q2,296.6630
31JUL2012,011903,2012Q3,291.9880
31OCT2012,011903,2012Q4,296.2200
31JAN2013,011903,2013Q1,267.1420
30APR2013,011903,2013Q2,285.5740
31JUL2013,011903,2013Q3,291.8730
31OCT2013,011903,2013Q4,299.2630
31JAN2014,011903,2014Q1,272.5170
30APR2014,011903,2014Q2,294.9420
31JUL2014,011903,2014Q3,308.8460
31OCT2014,011903,2014Q4,316.6850
31JAN2015,011903,2015Q1,275.4390
30APR2015,011903,2015Q2,285.7220
31JUL2015,011903,2015Q3,301.9820
31OCT2015,011903,2015Q4,278.2480
31JAN2016,011903,2016Q1,253.5530
30APR2016,011903,2016Q2,273.1620
31JUL2016,011903,2016Q3,283.6890
31OCT2016,011903,2016Q4,285.4260
31MAR1987,012825,1987Q2,9.5830
30JUN1987,012825,1987Q3,10.8830
30SEP1987,012825,1987Q4,19.3430
31DEC1987,012825,1988Q1,15.0200
31MAR1988,012825,1988Q2,16.0260
30JUN1988,012825,1988Q3,18.9690
30SEP1988,012825,1988Q4,21.0830
31DEC1988,012825,1989Q1,19.7520
31MAR1989,012825,1989Q2,18.8960
30JUN1989,012825,1989Q3,21.2560
30SEP1989,012825,1989Q4,26.9460
31DEC1989,012825,1990Q1,20.3010
31MAR1990,012825,1990Q2,21.0970
30JUN1990,012825,1990Q3,26.5350
30SEP1990,012825,1990Q4,28.5100
31DEC1990,012825,1991Q1,24.7290
31MAR1991,012825,1991Q2,24.9790
30JUN1991,012825,1991Q3,28.6320
30SEP1991,012825,1991Q4,31.3260
31DEC1991,012825,1992Q1,27.0430
31MAR1992,012825,1992Q2,28.5150
30JUN1992,012825,1992Q3,33.4780
30SEP1992,012825,1992Q4,37.8910
31DEC1992,012825,1993Q1,30.7920
31MAR1993,012825,1993Q2,32.7290
30JUN1993,012825,1993Q3,39.4220
30SEP1993,012825,1993Q4,44.2470
31DEC1993,012825,1994Q1,38.4050
31MAR1994,012825,1994Q2,40.2710
30JUN1994,012825,1994Q3,45.1660
30SEP1994,012825,1994Q4,50.5830
31DEC1994,012825,1995Q1,41.2170
31MAR1995,012825,1995Q2,40.3170
30JUN1995,012825,1995Q3,47.8760
30SEP1995,012825,1995Q4,55.9520
31DEC1995,012825,1996Q1,42.8630
31MAR1996,012825,1996Q2,42.1380
30JUN1996,012825,1996Q3,49.0910
30SEP1996,012825,1996Q4,51.9260
31DEC1996,012825,1997Q1,43.6010
31MAR1997,012825,1997Q2,50.3050
30JUN1997,012825,1997Q3,63.4480
30SEP1997,012825,1997Q4,62.9640
31DEC1997,012825,1998Q1,52.1910
31MAR1998,012825,1998Q2,58.8680
30JUN1998,012825,1998Q3,73.2760
30SEP1998,012825,1998Q4,78.0550
31DEC1998,012825,1999Q1,60.5490
31MAR1999,012825,1999Q2,62.9080
30JUN1999,012825,1999Q3,82.0940
30SEP1999,012825,1999Q4,82.8880
31DEC1999,012825,2000Q1,65.5060
31MAR2000,012825,2000Q2,67.8130
30JUN2000,012825,2000Q3,88.8880
30SEP2000,012825,2000Q4,96.2830
31DEC2000,012825,2001Q1,70.0700
31MAR2001,012825,2001Q2,76.8070
30JUN2001,012825,2001Q3,100.9700
30SEP2001,012825,2001Q4,80.4880
31DEC2001,012825,2002Q1,74.7970
31MAR2002,012825,2002Q2,77.7120
30JUN2002,012825,2002Q3,100.6280
30SEP2002,012825,2002Q4,100.0500
31DEC2002,012825,2003Q1,77.2440
31MAR2003,012825,2003Q2,81.4080
30JUN2003,012825,2003Q3,102.5290
30SEP2003,012825,2003Q4,103.3860
31DEC2003,012825,2004Q1,79.9450
31MAR2004,012825,2004Q2,95.2140
30JUN2004,012825,2004Q3,118.9520
30SEP2004,012825,2004Q4,122.4770
31DEC2004,012825,2005Q1,98.5210
31MAR2005,012825,2005Q2,99.3500
30JUN2005,012825,2005Q3,129.4520
30SEP2005,012825,2005Q4,129.7890
31DEC2005,012825,2006Q1,108.5710
31MAR2006,012825,2006Q2,112.0440
30JUN2006,012825,2006Q3,140.1320
30SEP2006,012825,2006Q4,154.0840
31DEC2006,012825,2007Q1,114.1420
31MAR2007,012825,2007Q2,130.0400
30JUN2007,012825,2007Q3,162.5100
30SEP2007,012825,2007Q4,162.2090
31DEC2007,012825,2008Q1,130.8980
31MAR2008,012825,2008Q2,144.2290
30JUN2008,012825,2008Q3,176.8390
30SEP2008,012825,2008Q4,177.3930
31DEC2008,012825,2009Q1,141.1420
31MAR2009,012825,2009Q2,149.3520
30JUN2009,012825,2009Q3,179.7610
30SEP2009,012825,2009Q4,182.7920
31DEC2009,012825,2010Q1,149.1020
31MAR2010,012825,2010Q2,157.3610
30JUN2010,012825,2010Q3,189.7290
30SEP2010,012825,2010Q4,200.5110
31DEC2010,012825,2011Q1,155.6320
31MAR2011,012825,2011Q2,162.7310
30JUN2011,012825,2011Q3,206.3280
30SEP2011,012825,2011Q4,219.3800
31DEC2011,012825,2012Q1,172.6860
31MAR2012,012825,2012Q2,189.5540
30JUN2012,012825,2012Q3,226.3350
30SEP2012,012825,2012Q4,242.2210
30SEP2012,012825,2012Q4,242.2210
31DEC2012,012825,2013Q1,191.4080
31MAR2013,012825,2013Q2,201.3260
30JUN2013,012825,2013Q3,237.0360
30SEP2013,012825,2013Q4,237.9130
31DEC2013,012825,2014Q1,203.5230
31MAR2014,012825,2014Q2,205.3210
30JUN2014,012825,2014Q3,257.1130
30SEP2014,012825,2014Q4,253.4940
31DEC2014,012825,2015Q1,212.7520
31MAR2015,012825,2015Q2,225.0080
30JUN2015,012825,2015Q3,278.7240
30SEP2015,012825,2015Q4,259.7720
31DEC2015,012825,2016Q1,222.8500
31MAR2016,012825,2016Q2,229.7100
30JUN2016,012825,2016Q3,277.9810
30SEP2016,012825,2016Q4,262.2400
31DEC2016,012825,2017Q1,225.5700
31MAR2017,012825,2017Q2,246.5130
30JUN2017,012825,2017Q3,295.4150
30SEP2017,012825,2017Q4,316.7260
30JUN1986,012305,1986Q1,3.3720
30SEP1986,012305,1986Q2,3.5920
31DEC1986,012305,1986Q3,3.9510
31MAR1987,012305,1986Q4,4.5050
30JUN1987,012305,1987Q1,4.5410
30SEP1987,012305,1987Q2,4.5220
31DEC1987,012305,1987Q3,4.5610
31MAR1988,012305,1987Q4,4.4410
30JUN1988,012305,1988Q1,4.4420
30SEP1988,012305,1988Q2,4.2750
31DEC1988,012305,1988Q3,4.5420
31MAR1989,012305,1988Q4,4.3990
30JUN1989,012305,1989Q1,4.4140
30SEP1989,012305,1989Q2,4.1360
31DEC1989,012305,1989Q3,4.1440
30JUN1990,012096,1990Q2,10.9380
30SEP1990,012096,1990Q3,14.0160
31DEC1991,012096,1991Q4,3.1610
31MAR1992,012096,1992Q1,2.6930
30JUN1992,012096,1992Q2,2.4380
30SEP1992,012096,1992Q3,2.5960
31MAR1993,012096,1993Q1,4.3690
30JUN1993,012096,1993Q2,2.9200
30SEP1993,012096,1993Q3,3.4460
31DEC1993,012096,1993Q4,4.0390
31MAR1994,012096,1994Q1,3.3740
30JUN1994,012096,1994Q2,3.2500
30SEP1994,012096,1994Q3,2.7300
31MAR1995,012096,1995Q1,2.9840
30JUN1995,012096,1995Q2,3.3530
30SEP1995,012096,1995Q3,2.8100
31DEC1995,012096,1995Q4,3.9700
31MAR1996,012096,1996Q1,3.0110
30JUN1996,012096,1996Q2,3.2240
30SEP1996,012096,1996Q3,2.7190
31DEC1996,012096,1996Q4,3.3820
31MAR1997,012096,1997Q1,2.8940
30JUN1997,012096,1997Q2,2.3900
30SEP1997,012096,1997Q3,2.9530
31DEC1997,012096,1997Q4,4.6900
31MAR1998,012096,1998Q1,2.8980
30JUN1998,012096,1998Q2,3.5480
30SEP1998,012096,1998Q3,4.0340
31DEC1998,012096,1998Q4,5.3730
31MAR1999,012096,1999Q1,4.6430
30JUN1999,012096,1999Q2,4.0010
30SEP1999,012096,1999Q3,4.5610
31DEC1999,012096,1999Q4,8.2730
31MAR2000,012096,2000Q1,5.5950
30JUN2000,012096,2000Q2,5.9700
30SEP2000,012096,2000Q3,5.8390
31DEC2000,012096,2000Q4,8.1170
31MAR2001,012096,2001Q1,4.3710
30JUN2001,012096,2001Q2,5.1880
30SEP2001,012096,2001Q3,4.4160
31DEC2001,012096,2001Q4,7.1420
31MAR2002,012096,2002Q1,4.5360
30JUN2002,012096,2002Q2,5.4160
30SEP2002,012096,2002Q3,4.7520
31DEC2002,012096,2002Q4,7.3160
31MAR2003,012096,2003Q1,5.1420
30JUN2003,012096,2003Q2,5.7130
30SEP2003,012096,2003Q3,5.4970
31DEC2003,012096,2003Q4,9.0740
31MAR2004,012096,2004Q1,6.7990
30JUN2004,012096,2004Q2,6.2170
30SEP2004,012096,2004Q3,6.3080
31DEC2004,012096,2004Q4,9.3180
31MAR2005,012096,2005Q1,6.7180
30JUN2005,012096,2005Q2,6.8000
30SEP2005,012096,2005Q3,7.2150
31DEC2005,012096,2005Q4,14.9070
31MAR2006,012096,2006Q1,9.7210
30JUN2006,012096,2006Q2,12.4450
30SEP2006,012096,2006Q3,9.5490
31DEC2006,012096,2006Q4,12.1420
31MAR2007,012096,2007Q1,10.1740
30JUN2007,012096,2007Q2,12.5140
30SEP2007,012096,2007Q3,16.8560
31DEC2007,012096,2007Q4,23.4230
31MAR2008,012096,2008Q1,31.6130
30JUN2008,012096,2008Q2,25.1450
30SEP2008,012096,2008Q3,23.4910
31DEC2008,012096,2008Q4,20.9750
31MAR2009,012096,2009Q1,25.3400
30JUN2009,012096,2009Q2,21.6340
30SEP2009,012096,2009Q3,16.2800
31DEC2009,012096,2009Q4,22.1160
31MAR2010,012096,2010Q1,17.3480
30JUN2010,012096,2010Q2,20.7450
30SEP2010,012096,2010Q3,18.1090
31MAR2011,012096,2011Q1,22.9700
30JUN2011,012096,2011Q2,30.6430
30SEP2011,012096,2011Q3,44.0150
30SEP2012,012096,2012Q3,28.9750
31DEC2012,012096,2012Q4,37.5030
31MAR2013,012096,2013Q1,23.5300
30JUN2013,012096,2013Q2,23.7750
30SEP2013,012096,2013Q3,19.0000
31DEC2013,012096,2013Q4,20.7910
31MAR2014,012096,2014Q1,18.0650
30JUN2014,012096,2014Q2,17.5180
30SEP2014,012096,2014Q3,17.0400
31DEC2014,012096,2014Q4,18.1200
31MAR2015,012096,2015Q1,12.8750
30JUN2015,012096,2015Q2,14.9430
30SEP2015,012096,2015Q3,16.5240
31DEC2015,012096,2015Q4,16.5760
31MAR2016,012096,2016Q1,11.7750
31MAR2016,012096,2016Q1,11.7750
30JUN2016,012096,2016Q2,15.4980
30SEP2016,012096,2016Q3,10.5720
31DEC2016,012096,2016Q4,10.4820
31MAR2017,012096,2017Q1,15.1240
30JUN2017,012096,2017Q2,16.7470
30SEP2017,012096,2017Q3,15.6780
30JUN1986,012147,1986Q3,9.3090
30SEP1986,012147,1986Q4,9.0710
31DEC1986,012147,1987Q1,9.6230
31MAR1987,012147,1987Q2,10.5410
30JUN1987,012147,1987Q3,17.3410
30SEP1987,012147,1987Q4,28.7540
30JUN1988,012147,1988Q3,33.6580
30SEP1988,012147,1988Q4,33.2230
31DEC1988,012147,1989Q1,13.3580
31MAR1989,012147,1989Q2,20.9110
30JUN1989,012147,1989Q3,28.5130
30SEP1989,012147,1989Q4,31.9090
31DEC1989,012147,1990Q1,13.9560
31MAR1990,012147,1990Q2,19.0780
30JUN1990,012147,1990Q3,36.7300
30JUN1984,001003,1984Q2,2.8530
30SEP1984,001003,1984Q3,3.2410
30APR1986,001003,1986Q1,7.3920
31JUL1986,001003,1986Q2,7.8610
31OCT1986,001003,1986Q3,10.1740
31JAN1987,001003,1986Q4,10.8810
30APR1987,001003,1987Q1,8.8520
31JUL1987,001003,1987Q2,8.5670
31OCT1987,001003,1987Q3,9.3170
31JAN1988,001003,1987Q4,10.6200
30APR1988,001003,1988Q1,7.4300
31JUL1988,001003,1988Q2,8.0710
30SEP1987,012945,1987Q4,8.8590
31DEC1987,012945,1988Q1,9.9270
31MAR1988,012945,1988Q2,11.3400
30JUN1988,012945,1988Q3,14.2950
30SEP1988,012945,1988Q4,17.5890
31DEC1988,012945,1989Q1,21.3340
31MAR1989,012945,1989Q2,20.6570
30JUN1989,012945,1989Q3,20.3680
30SEP1989,012945,1989Q4,15.7040
31DEC1989,012945,1990Q1,20.0920
31MAR1990,012945,1990Q2,18.8690
30JUN1990,012945,1990Q3,18.6860
30SEP1990,012945,1990Q4,21.0490
31DEC1990,012945,1991Q1,26.5410
31MAR1991,012945,1991Q2,26.5500
30JUN1991,012945,1991Q3,32.6230
30SEP1991,012945,1991Q4,34.7200
31DEC1991,012945,1992Q1,36.9200
31MAR1992,012945,1992Q2,38.7830
30JUN1992,012945,1992Q3,41.3600
30SEP1992,012945,1992Q4,40.3130
31DEC1992,012945,1993Q1,42.0990
31MAR1993,012945,1993Q2,36.5810
30JUN1993,012945,1993Q3,38.9710
30SEP1993,012945,1993Q4,41.9460
31DEC1993,012945,1994Q1,55.9440
31MAR1994,012945,1994Q2,61.3230
30JUN1994,012945,1994Q3,55.0040
30SEP1994,012945,1994Q4,70.2120
31DEC1994,012945,1995Q1,65.3410
31MAR1995,012945,1995Q2,69.3800
30JUN1995,012945,1995Q3,72.3540
30SEP1995,012945,1995Q4,76.0590
31DEC1995,012945,1996Q1,71.3080
31MAR1996,012945,1996Q2,75.2860
;;;;

I tried this code but I am not sure if this is correct and takes a lot of time. Can someone please provide an efficient and correct code.

proc sql;
 create have1 as
  select *,((select SALEQ from have where firmid=h.firmid and datadate=intnx('quarter',h.datadate,-4)) -
            (select SALEQ from have where firmid=h.firmid and datadate=intnx('quarter',h.datadate,-8)) ) /
            (select SALEQ from have where firmid=h.firmid and datadate=intnx('quarter',h.datadate,-4)) as sales_growth1
   from have as h;
quit;

Accepted Solutions
Solution
a month ago
Super User
Posts: 23,662

Re: Calculate quarterly growth rate for panel data

Posted in reply to Agent1592

Can you have missing records? Ie no records for a quarter?

 

If you have good data (or make it full) you can use the LAG() instead.

 

data want;
set have;

by GVKEY DATAFQTR;

if first.gvkey then counter=1;

prev_year = lag4(saleQ);
prev_year2 = lag8(saleQ);

if first.gvkey then  call missing(prev_year, prev_year2);

if counter<4 then call missing(prev_year);
if counter<8 then call missing(prev_year2);

YoY = saleQ/prev_year -1;
YoY2 = saleQ/prev_year2;

run;

 

View solution in original post


All Replies
Solution
a month ago
Super User
Posts: 23,662

Re: Calculate quarterly growth rate for panel data

Posted in reply to Agent1592

Can you have missing records? Ie no records for a quarter?

 

If you have good data (or make it full) you can use the LAG() instead.

 

data want;
set have;

by GVKEY DATAFQTR;

if first.gvkey then counter=1;

prev_year = lag4(saleQ);
prev_year2 = lag8(saleQ);

if first.gvkey then  call missing(prev_year, prev_year2);

if counter<4 then call missing(prev_year);
if counter<8 then call missing(prev_year2);

YoY = saleQ/prev_year -1;
YoY2 = saleQ/prev_year2;

run;

 

Frequent Contributor
Posts: 76

Re: Calculate quarterly growth rate for panel data

Yes there will be missing data for some quarters unfortunately. I see your code takes the sales from 2 years ago if the sales from a year ago is missing. Is that correct?

Super User
Posts: 23,662

Re: Calculate quarterly growth rate for panel data

Posted in reply to Agent1592

No, I noticed you were doing 4 and 8 month lags, so assumed YoY and Y over 2 years. If you don't need that part, delete it. 

If you're missing data, the easiest solution is to use PROC TIMESERIES to fill it in first. And if you're going down that route, see PROC EXPAND with the CONVERT statement to make this a 4 line solution instead.

 

An example of that approach is outlined here:

https://gist.github.com/statgeek/07a3708dee1225ceb9d4aa75daab2c52

 


@Agent1592 wrote:

Yes there will be missing data for some quarters unfortunately. I see your code takes the sales from 2 years ago if the sales from a year ago is missing. Is that correct?




 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 79 views
  • 1 like
  • 2 in conversation