BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
lioradam
Obsidian | Level 7

Hello,

I have a data set with monthly share prices for several firms. I would like to create a variable "share price year before" which takes the share price  12 months before the current month. 

It is a kind of lag function but 12 rows backward (if there are 12 rows backward for the specific firm).

Could you please assist how to write this code?

Thanks in advance,

Lior


DATA WORK.have;
    LENGTH
        'Company Name'n  $ 26
        'Ticker Symbol'n $ 6
        year               8
        month              8
        'Price - Close - Monthly'n   8 ;
    FORMAT
        'Company Name'n  $CHAR26.
        'Ticker Symbol'n $CHAR6.
        year             BEST12.
        month            BEST12.
        'Price - Close - Monthly'n BEST12. ;
    INFORMAT
        'Company Name'n  $CHAR26.
        'Ticker Symbol'n $CHAR6.
        year             BEST12.
        month            BEST12.
        'Price - Close - Monthly'n BEST12. ;
    INFILE DATALINES4
        DLM='7F'x
        MISSOVER
        DSD ;
    INPUT
        'Company Name'n  : $CHAR26.
        'Ticker Symbol'n : $CHAR6.
        year             : BEST32.
        month            : BEST32.
        'Price - Close - Monthly'n : BEST32. ;
DATALINES4;
PETCO ANIMAL SUPPLIES INC0230B1994312.99999905
PETCO ANIMAL SUPPLIES INC0230B1994413.24999809
PETCO ANIMAL SUPPLIES INC0230B1994513.62499809
PETCO ANIMAL SUPPLIES INC0230B1994612.24999905
PETCO ANIMAL SUPPLIES INC0230B1994712.24999905
PETCO ANIMAL SUPPLIES INC0230B1994814.37499809
PETCO ANIMAL SUPPLIES INC0230B1994914.99999857
PETCO ANIMAL SUPPLIES INC0230B19941016.99999809
PETCO ANIMAL SUPPLIES INC0230B19941116.74999762
PETCO ANIMAL SUPPLIES INC0230B19941214.49999905
PETCO ANIMAL SUPPLIES INC0230B1995117.49999762
PETCO ANIMAL SUPPLIES INC0230B1995218.74999857
PETCO ANIMAL SUPPLIES INC0230B1995320.99999857
PETCO ANIMAL SUPPLIES INC0230B1995420.62499857
PETCO ANIMAL SUPPLIES INC0230B1995520.49999762
PETCO ANIMAL SUPPLIES INC0230B1995623.24999857
PETCO ANIMAL SUPPLIES INC0230B1995722.24999809
PETCO ANIMAL SUPPLIES INC0230B1995824.24998474
PETCO ANIMAL SUPPLIES INC0230B1995925.99999237
PETCO ANIMAL SUPPLIES INC0230B19951027.99998474
PETCO ANIMAL SUPPLIES INC0230B19951127.49999237
PETCO ANIMAL SUPPLIES INC0230B19951229.24997711
PETCO ANIMAL SUPPLIES INC0230B1996131.87497711
PETCO ANIMAL SUPPLIES INC0230B1996232.99997711
PETCO ANIMAL SUPPLIES INC0230B1996344.74999237
PETCO ANIMAL SUPPLIES INC0230B1996428.75
PETCO ANIMAL SUPPLIES INC0230B1996528.5
PETCO ANIMAL SUPPLIES INC0230B1996628.75
PETCO ANIMAL SUPPLIES INC0230B1996722.25
PETCO ANIMAL SUPPLIES INC0230B1996824
PETCO ANIMAL SUPPLIES INC0230B1996927.25
PETCO ANIMAL SUPPLIES INC0230B19961023.5
PETCO ANIMAL SUPPLIES INC0230B19961121.875
PETCO ANIMAL SUPPLIES INC0230B19961220.75
PETCO ANIMAL SUPPLIES INC0230B1997124.375
PETCO ANIMAL SUPPLIES INC0230B1997227.625
PETCO ANIMAL SUPPLIES INC0230B1997323.5
PETCO ANIMAL SUPPLIES INC0230B1997421.375
PETCO ANIMAL SUPPLIES INC0230B1997526.75
PETCO ANIMAL SUPPLIES INC0230B1997630
PETCO ANIMAL SUPPLIES INC0230B1997726.5
PETCO ANIMAL SUPPLIES INC0230B1997829.625
PETCO ANIMAL SUPPLIES INC0230B1997931.375
PETCO ANIMAL SUPPLIES INC0230B19971030.75
PETCO ANIMAL SUPPLIES INC0230B19971129.5
PETCO ANIMAL SUPPLIES INC0230B19971224
PETCO ANIMAL SUPPLIES INC0230B1998124.625
PETCO ANIMAL SUPPLIES INC0230B1998214.31199932
PETCO ANIMAL SUPPLIES INC0230B1998319.5
PETCO ANIMAL SUPPLIES INC0230B1998419.75
PETCO ANIMAL SUPPLIES INC0230B1998519.375
PETCO ANIMAL SUPPLIES INC0230B1998619.9375
PETCO ANIMAL SUPPLIES INC0230B1998710.375
PETCO ANIMAL SUPPLIES INC0230B199887.0625
PETCO ANIMAL SUPPLIES INC0230B199899
PETCO ANIMAL SUPPLIES INC0230B1998108.875
PETCO ANIMAL SUPPLIES INC0230B19981110
PETCO ANIMAL SUPPLIES INC0230B19981210.0625
PETCO ANIMAL SUPPLIES INC0230B199918.0625
PETCO ANIMAL SUPPLIES INC0230B199928.0625
PETCO ANIMAL SUPPLIES INC0230B1999310
PETCO ANIMAL SUPPLIES INC0230B1999413.125
PETCO ANIMAL SUPPLIES INC0230B1999514.125
PETCO ANIMAL SUPPLIES INC0230B1999615.75
PETCO ANIMAL SUPPLIES INC0230B1999716.5
PETCO ANIMAL SUPPLIES INC0230B1999812.5
PETCO ANIMAL SUPPLIES INC0230B1999911.875
PETCO ANIMAL SUPPLIES INC0230B19991011.5625
PETCO ANIMAL SUPPLIES INC0230B19991114
PETCO ANIMAL SUPPLIES INC0230B19991214.875
PETCO ANIMAL SUPPLIES INC0230B2000112.5
PETCO ANIMAL SUPPLIES INC0230B2000210.75
PETCO ANIMAL SUPPLIES INC0230B2000311.875
PETCO ANIMAL SUPPLIES INC0230B2000411.5625
PETCO ANIMAL SUPPLIES INC0230B2000518.9375
PETCO ANIMAL SUPPLIES INC0230B2000619.625
PETCO ANIMAL SUPPLIES INC0230B2000719.8125
PETCO ANIMAL SUPPLIES INC0230B2000821
PETCO ANIMAL SUPPLIES INC0230B2000921.8125
METRO AIRLINES INC3MAIRQ1986612.49999809
METRO AIRLINES INC3MAIRQ198679.37499857
METRO AIRLINES INC3MAIRQ198688.74999809
METRO AIRLINES INC3MAIRQ198699.12499809
METRO AIRLINES INC3MAIRQ19861010.49999857
METRO AIRLINES INC3MAIRQ19861110.99999809
METRO AIRLINES INC3MAIRQ19861211.49999905
METRO AIRLINES INC3MAIRQ198717.625
METRO AIRLINES INC3MAIRQ198727.625
METRO AIRLINES INC3MAIRQ198737.625
METRO AIRLINES INC3MAIRQ198746.25
METRO AIRLINES INC3MAIRQ198756.625
METRO AIRLINES INC3MAIRQ198768.375
METRO AIRLINES INC3MAIRQ198778
METRO AIRLINES INC3MAIRQ198788.875
METRO AIRLINES INC3MAIRQ198797.625
METRO AIRLINES INC3MAIRQ1987105.125
METRO AIRLINES INC3MAIRQ1987114.625
METRO AIRLINES INC3MAIRQ1987124.125
METRO AIRLINES INC3MAIRQ198813.875
METRO AIRLINES INC3MAIRQ198824.125
METRO AIRLINES INC3MAIRQ198834
METRO AIRLINES INC3MAIRQ198844.25
METRO AIRLINES INC3MAIRQ198854.125
METRO AIRLINES INC3MAIRQ198866.625
METRO AIRLINES INC3MAIRQ198877.75
METRO AIRLINES INC3MAIRQ198888
METRO AIRLINES INC3MAIRQ198898.75
METRO AIRLINES INC3MAIRQ1988108.5
METRO AIRLINES INC3MAIRQ1988117.75
METRO AIRLINES INC3MAIRQ1988127.625
METRO AIRLINES INC3MAIRQ198917.625
METRO AIRLINES INC3MAIRQ198928.5
METRO AIRLINES INC3MAIRQ198938.375
METRO AIRLINES INC3MAIRQ198947.625
METRO AIRLINES INC3MAIRQ198957.125
METRO AIRLINES INC3MAIRQ198967.375
METRO AIRLINES INC3MAIRQ198978.25
METRO AIRLINES INC3MAIRQ198988.75
METRO AIRLINES INC3MAIRQ198999.125
METRO AIRLINES INC3MAIRQ1989107.5
METRO AIRLINES INC3MAIRQ1989118.75
METRO AIRLINES INC3MAIRQ1989127.375
METRO AIRLINES INC3MAIRQ199015.75
METRO AIRLINES INC3MAIRQ199024.5
METRO AIRLINES INC3MAIRQ199034.875
METRO AIRLINES INC3MAIRQ199044.875
METRO AIRLINES INC3MAIRQ199055.25
METRO AIRLINES INC3MAIRQ199065.375
METRO AIRLINES INC3MAIRQ199075
METRO AIRLINES INC3MAIRQ199083.875
METRO AIRLINES INC3MAIRQ199093.25
METRO AIRLINES INC3MAIRQ1990102.81199932
METRO AIRLINES INC3MAIRQ1990112.875
METRO AIRLINES INC3MAIRQ1990121.875
METRO AIRLINES INC3MAIRQ199111.875
METRO AIRLINES INC3MAIRQ199121.5
ABM INDUSTRIES INCABM1986625.625
ABM INDUSTRIES INCABM1986726.25
ABM INDUSTRIES INCABM1986825.5
ABM INDUSTRIES INCABM1986924.375
ABM INDUSTRIES INCABM19861023.5
ABM INDUSTRIES INCABM19861122.625
ABM INDUSTRIES INCABM19861221.375
ABM INDUSTRIES INCABM1987123.75
ABM INDUSTRIES INCABM1987224.375
ABM INDUSTRIES INCABM1987326
ABM INDUSTRIES INCABM1987424.75
ABM INDUSTRIES INCABM1987525
ABM INDUSTRIES INCABM1987625
ABM INDUSTRIES INCABM1987723.75
ABM INDUSTRIES INCABM1987825
ABM INDUSTRIES INCABM1987925.5
ABM INDUSTRIES INCABM19871017.625
ABM INDUSTRIES INCABM19871116.875
ABM INDUSTRIES INCABM19871219.5
ABM INDUSTRIES INCABM1988120
ABM INDUSTRIES INCABM1988220.25
ABM INDUSTRIES INCABM1988322
ABM INDUSTRIES INCABM1988423.75
ABM INDUSTRIES INCABM1988524.375
ABM INDUSTRIES INCABM1988624.875
ABM INDUSTRIES INCABM1988725.25
ABM INDUSTRIES INCABM1988826.375
ABM INDUSTRIES INCABM1988928
ABM INDUSTRIES INCABM19881027.375
ABM INDUSTRIES INCABM19881125.75
ABM INDUSTRIES INCABM19881227.625
ABM INDUSTRIES INCABM1989129.625
ABM INDUSTRIES INCABM1989229.125
ABM INDUSTRIES INCABM1989333.625
ABM INDUSTRIES INCABM1989434.5
ABM INDUSTRIES INCABM1989536.625
ABM INDUSTRIES INCABM1989634.625
ABM INDUSTRIES INCABM1989735.25
ABM INDUSTRIES INCABM1989836.375
ABM INDUSTRIES INCABM1989935.875
ABM INDUSTRIES INCABM19891033
ABM INDUSTRIES INCABM19891133.25
ABM INDUSTRIES INCABM19891233.125
ABM INDUSTRIES INCABM1990133.5
ABM INDUSTRIES INCABM1990236.875
ABM INDUSTRIES INCABM1990338.375
ABM INDUSTRIES INCABM1990438
ABM INDUSTRIES INCABM1990538.75
ABM INDUSTRIES INCABM1990637
ABM INDUSTRIES INCABM1990737.125
ABM INDUSTRIES INCABM1990833.75
ABM INDUSTRIES INCABM1990932.375
ABM INDUSTRIES INCABM19901028.5
ABM INDUSTRIES INCABM19901127.625
ABM INDUSTRIES INCABM19901225.875
ABM INDUSTRIES INCABM1991130.25
ABM INDUSTRIES INCABM1991231.625
ABM INDUSTRIES INCABM1991330.375
ABM INDUSTRIES INCABM1991430.875
ABM INDUSTRIES INCABM1991530
ABM INDUSTRIES INCABM1991630.25
ABM INDUSTRIES INCABM1991733.125
ABM INDUSTRIES INCABM1991833.5
ABM INDUSTRIES INCABM1991932.375
ABM INDUSTRIES INCABM19911033.875
ABM INDUSTRIES INCABM19911134.25
ABM INDUSTRIES INCABM19911235.625
ABM INDUSTRIES INCABM1992137.625
ABM INDUSTRIES INCABM1992239.625
ABM INDUSTRIES INCABM1992337.5
ABM INDUSTRIES INCABM1992434.875
ABM INDUSTRIES INCABM1992536.875
ABM INDUSTRIES INCABM1992636.5
ABM INDUSTRIES INCABM1992716
ABM INDUSTRIES INCABM1992818.25
ABM INDUSTRIES INCABM1992917.5
ABM INDUSTRIES INCABM19921017.875
ABM INDUSTRIES INCABM19921118.875
ABM INDUSTRIES INCABM19921220
ABM INDUSTRIES INCABM1993117.625
ABM INDUSTRIES INCABM1993220.25
ABM INDUSTRIES INCABM1993320.5
ABM INDUSTRIES INCABM1993421.125
ABM INDUSTRIES INCABM1993519.25
ABM INDUSTRIES INCABM1993617.25
ABM INDUSTRIES INCABM1993717
ABM INDUSTRIES INCABM1993815.25
ABM INDUSTRIES INCABM1993915.75
ABM INDUSTRIES INCABM19931016.375
ABM INDUSTRIES INCABM19931116.875
ABM INDUSTRIES INCABM19931217.875
ABM INDUSTRIES INCABM1994118.375
ABM INDUSTRIES INCABM1994217.875
ABM INDUSTRIES INCABM1994318.25
ABM INDUSTRIES INCABM1994418
ABM INDUSTRIES INCABM1994520.125
ABM INDUSTRIES INCABM1994620.25
ABM INDUSTRIES INCABM1994721.5
ABM INDUSTRIES INCABM1994822.875
ABM INDUSTRIES INCABM1994921
ABM INDUSTRIES INCABM19941021
ABM INDUSTRIES INCABM19941120.75
ABM INDUSTRIES INCABM19941223.25
ABM INDUSTRIES INCABM1995123.75
ABM INDUSTRIES INCABM1995223
ABM INDUSTRIES INCABM1995322.75
ABM INDUSTRIES INCABM1995423.125
ABM INDUSTRIES INCABM1995522.75
ABM INDUSTRIES INCABM1995623.125
ABM INDUSTRIES INCABM1995725
ABM INDUSTRIES INCABM1995825.75
ABM INDUSTRIES INCABM1995926.5
ABM INDUSTRIES INCABM19951026.5
ABM INDUSTRIES INCABM19951128.125
ABM INDUSTRIES INCABM19951227.75
ABM INDUSTRIES INCABM1996128
ABM INDUSTRIES INCABM1996229.375
ABM INDUSTRIES INCABM1996333.125
ABM INDUSTRIES INCABM1996434.125
ABM INDUSTRIES INCABM1996538.125
ABM INDUSTRIES INCABM1996639.125
ABM INDUSTRIES INCABM1996735.125
ABM INDUSTRIES INCABM1996817.125
ABM INDUSTRIES INCABM1996916.875
ABM INDUSTRIES INCABM19961017.625
ABM INDUSTRIES INCABM19961117.25
ABM INDUSTRIES INCABM19961218.5
ABM INDUSTRIES INCABM1997118.875
ABM INDUSTRIES INCABM1997218.75
ABM INDUSTRIES INCABM1997318.75
ABM INDUSTRIES INCABM1997418.75
ABM INDUSTRIES INCABM1997519.375
ABM INDUSTRIES INCABM1997619.31199646
ABM INDUSTRIES INCABM1997723.125
ABM INDUSTRIES INCABM1997824.56199646
ABM INDUSTRIES INCABM1997926.375
ABM INDUSTRIES INCABM19971027.125
ABM INDUSTRIES INCABM19971127.875
ABM INDUSTRIES INCABM19971230.56199646
ABM INDUSTRIES INCABM1998130.56199646
ABM INDUSTRIES INCABM1998236
ABM INDUSTRIES INCABM1998331.06199646
ABM INDUSTRIES INCABM1998428.9375
ABM INDUSTRIES INCABM1998527.6875
ABM INDUSTRIES INCABM1998627.875
ABM INDUSTRIES INCABM1998729.5
ABM INDUSTRIES INCABM1998825.5
ABM INDUSTRIES INCABM1998929.25
ABM INDUSTRIES INCABM19981028
ABM INDUSTRIES INCABM19981133.3125
ABM INDUSTRIES INCABM19981234.625
ABM INDUSTRIES INCABM1999133.0625
ABM INDUSTRIES INCABM1999228.6875
ABM INDUSTRIES INCABM1999330.5
ABM INDUSTRIES INCABM1999430.375
ABM INDUSTRIES INCABM1999527.3125
ABM INDUSTRIES INCABM1999630.6875
ABM INDUSTRIES INCABM1999727.8125
ABM INDUSTRIES INCABM1999823
ABM INDUSTRIES INCABM1999925.375
ABM INDUSTRIES INCABM19991023.875
ABM INDUSTRIES INCABM19991121.5
ABM INDUSTRIES INCABM19991220.375
ABM INDUSTRIES INCABM2000120.5
ABM INDUSTRIES INCABM2000225.1875
ABM INDUSTRIES INCABM2000323.5
ABM INDUSTRIES INCABM2000425.25
ABM INDUSTRIES INCABM2000523.1875
ABM INDUSTRIES INCABM2000623
ABM INDUSTRIES INCABM2000726
ABM INDUSTRIES INCABM2000827
ABM INDUSTRIES INCABM2000927.1875
ABM INDUSTRIES INCABM20001027.9375
ABM INDUSTRIES INCABM20001128.5625
ABM INDUSTRIES INCABM20001230.625
ABM INDUSTRIES INCABM2001130.35
ABM INDUSTRIES INCABM2001232.3
ABM INDUSTRIES INCABM2001331.25
ABM INDUSTRIES INCABM2001430.92
ABM INDUSTRIES INCABM2001531.8
ABM INDUSTRIES INCABM2001637.25
ABM INDUSTRIES INCABM2001736.55
ABM INDUSTRIES INCABM2001834.55
ABM INDUSTRIES INCABM2001925.81
ABM INDUSTRIES INCABM20011027.3
ABM INDUSTRIES INCABM20011130.2
ABM INDUSTRIES INCABM20011231.35
ABM INDUSTRIES INCABM2002130.5
ABM INDUSTRIES INCABM2002232.7
ABM INDUSTRIES INCABM2002336.7
ABM INDUSTRIES INCABM2002438.3
ABM INDUSTRIES INCABM2002518.05
ABM INDUSTRIES INCABM2002617.36
ABM INDUSTRIES INCABM2002716.5
ABM INDUSTRIES INCABM2002816.78
ABM INDUSTRIES INCABM2002914.1
ABM INDUSTRIES INCABM20021014.69
ABM INDUSTRIES INCABM20021114.84
ABM INDUSTRIES INCABM20021215.5
ABM INDUSTRIES INCABM2003115.21
ABM INDUSTRIES INCABM2003215.99
ABM INDUSTRIES INCABM2003313.14
ABM INDUSTRIES INCABM2003413.85
ABM INDUSTRIES INCABM2003514.78
ABM INDUSTRIES INCABM2003615.4
ABM INDUSTRIES INCABM2003716.22
ABM INDUSTRIES INCABM2003815.65
ABM INDUSTRIES INCABM2003914.15
ABM INDUSTRIES INCABM20031015.56
ABM INDUSTRIES INCABM20031115.85
ABM INDUSTRIES INCABM20031217.41
ABM INDUSTRIES INCABM2004118.05
ABM INDUSTRIES INCABM2004218.06
ABM INDUSTRIES INCABM2004317.95
ABM INDUSTRIES INCABM2004418.46
ABM INDUSTRIES INCABM2004519.02
ABM INDUSTRIES INCABM2004619.47
ABM INDUSTRIES INCABM2004717.99
ABM INDUSTRIES INCABM2004817.96
ABM INDUSTRIES INCABM2004920.15
ABM INDUSTRIES INCABM20041020.75
ABM INDUSTRIES INCABM20041121.95
ABM INDUSTRIES INCABM20041219.72
ABM INDUSTRIES INCABM2005118.3
ABM INDUSTRIES INCABM2005218.53
ABM INDUSTRIES INCABM2005319.23
ABM INDUSTRIES INCABM2005418.17
ABM INDUSTRIES INCABM2005519.07
ABM INDUSTRIES INCABM2005619.5
ABM INDUSTRIES INCABM2005719.6
ABM INDUSTRIES INCABM2005819.83
ABM INDUSTRIES INCABM2005920.81
ABM INDUSTRIES INCABM20051019.78
ABM INDUSTRIES INCABM20051121.55
ABM INDUSTRIES INCABM20051219.55
ABM INDUSTRIES INCABM2006119.11
ABM INDUSTRIES INCABM2006218.45
ABM INDUSTRIES INCABM2006319.17
ABM INDUSTRIES INCABM2006417.2
ABM INDUSTRIES INCABM2006517.35
ABM INDUSTRIES INCABM2006617.1
ABM INDUSTRIES INCABM2006716.5
ABM INDUSTRIES INCABM2006817.99
ABM INDUSTRIES INCABM2006918.76
ABM INDUSTRIES INCABM20061019.86
ABM INDUSTRIES INCABM20061120.77
ABM INDUSTRIES INCABM20061222.71
ABM INDUSTRIES INCABM2007125.84
ABM INDUSTRIES INCABM2007226.3
ABM INDUSTRIES INCABM2007326.39
ABM INDUSTRIES INCABM2007428.14
ABM INDUSTRIES INCABM2007529.51
ABM INDUSTRIES INCABM2007625.81
ABM INDUSTRIES INCABM2007725.16
ABM INDUSTRIES INCABM2007823.38
ABM INDUSTRIES INCABM2007919.98
ABM INDUSTRIES INCABM20071023.52
ABM INDUSTRIES INCABM20071120.4
ABM INDUSTRIES INCABM20071220.39
ABM INDUSTRIES INCABM2008120.72
ABM INDUSTRIES INCABM2008219.86
ABM INDUSTRIES INCABM2008322.44
ABM INDUSTRIES INCABM2008420.94
ABM INDUSTRIES INCABM2008521.83
ABM INDUSTRIES INCABM2008622.25
ABM INDUSTRIES INCABM2008723.93
ABM INDUSTRIES INCABM2008826.28
ABM INDUSTRIES INCABM2008921.84
ABM INDUSTRIES INCABM20081016.33
ABM INDUSTRIES INCABM20081116.87
ABM INDUSTRIES INCABM20081219.05
ABM INDUSTRIES INCABM2009114.85
ABM INDUSTRIES INCABM2009212.23
ABM INDUSTRIES INCABM2009316.4
ABM INDUSTRIES INCABM2009417.52
ABM INDUSTRIES INCABM2009516.18
ABM INDUSTRIES INCABM2009618.07
ABM INDUSTRIES INCABM2009721.07
ABM INDUSTRIES INCABM2009822.43
ABM INDUSTRIES INCABM2009921.04
ABM INDUSTRIES INCABM20091018.78
ABM INDUSTRIES INCABM20091118.43
ABM INDUSTRIES INCABM20091220.66
ABM INDUSTRIES INCABM2010119.42
ABM INDUSTRIES INCABM2010220.48
ABM INDUSTRIES INCABM2010321.2
ABM INDUSTRIES INCABM2010421.49
ABM INDUSTRIES INCABM2010521.47
ABM INDUSTRIES INCABM2010620.95
ABM INDUSTRIES INCABM2010721.7
ABM INDUSTRIES INCABM2010819.61
ABM INDUSTRIES INCABM2010921.59
ABM INDUSTRIES INCABM20101022.55
ABM INDUSTRIES INCABM20101123.03
ABM INDUSTRIES INCABM20101226.3
ABM INDUSTRIES INCABM2011125.7
ABM INDUSTRIES INCABM2011226.63
ABM INDUSTRIES INCABM2011325.39
ABM INDUSTRIES INCABM2011424.32
ABM INDUSTRIES INCABM2011522.78
ABM INDUSTRIES INCABM2011623.34
ABM INDUSTRIES INCABM2011722.5
ABM INDUSTRIES INCABM2011820.44
ABM INDUSTRIES INCABM2011919.06
ABM INDUSTRIES INCABM20111020.22
ABM INDUSTRIES INCABM20111121.73
ABM INDUSTRIES INCABM20111220.62
ABM INDUSTRIES INCABM2012121.7
ABM INDUSTRIES INCABM2012222.7
ABM INDUSTRIES INCABM2012324.3
ABM INDUSTRIES INCABM2012423.28
ABM INDUSTRIES INCABM2012521.47
ABM INDUSTRIES INCABM2012619.56
ABM INDUSTRIES INCABM2012718.6
ABM INDUSTRIES INCABM2012820.22
ABM INDUSTRIES INCABM2012918.93
ABM INDUSTRIES INCABM20121019
ABM INDUSTRIES INCABM20121119.08
ABM INDUSTRIES INCABM20121219.95
ABM INDUSTRIES INCABM2013121.92
ABM INDUSTRIES INCABM2013222.7
ABM INDUSTRIES INCABM2013322.24
ABM INDUSTRIES INCABM2013422.55
ABM INDUSTRIES INCABM2013524.18
ABM INDUSTRIES INCABM2013624.51
ABM INDUSTRIES INCABM2013725.9
ABM INDUSTRIES INCABM2013824.15
ABM INDUSTRIES INCABM2013926.62
ABM INDUSTRIES INCABM20131027.51
ABM INDUSTRIES INCABM20131127.81
ABM INDUSTRIES INCABM20131228.59
ABM INDUSTRIES INCABM2014126.66
ABM INDUSTRIES INCABM2014228.23
ABM INDUSTRIES INCABM2014328.74
ABM INDUSTRIES INCABM2014427.09
ABM INDUSTRIES INCABM2014527.27
ABM INDUSTRIES INCABM2014626.98
ABM INDUSTRIES INCABM2014724.61
ABM INDUSTRIES INCABM2014826.6
ABM INDUSTRIES INCABM2014925.69
ABM INDUSTRIES INCABM20141027.64
ABM INDUSTRIES INCABM20141127.09
ABM INDUSTRIES INCABM20141228.65
ABM INDUSTRIES INCABM2015128.87
ABM INDUSTRIES INCABM2015231.09
ABM INDUSTRIES INCABM2015331.86
ABM INDUSTRIES INCABM2015432.05
ABM INDUSTRIES INCABM2015532.44
ABM INDUSTRIES INCABM2015632.87
ABM INDUSTRIES INCABM2015732.96
ABM INDUSTRIES INCABM2015832.01
ABM INDUSTRIES INCABM2015927.31
ABM INDUSTRIES INCABM20151028.4
ABM INDUSTRIES INCABM20151129.67
ABM INDUSTRIES INCABM20151228.47
ABM INDUSTRIES INCABM2016130.03
ABM INDUSTRIES INCABM2016231.4
ABM INDUSTRIES INCABM2016332.31
ABM INDUSTRIES INCABM2016432.17
ABM INDUSTRIES INCABM2016534.17
ABM INDUSTRIES INCABM2016636.48
ABM INDUSTRIES INCABM2016737.21
ABM INDUSTRIES INCABM2016838.43
ABM INDUSTRIES INCABM2016939.7
ABM INDUSTRIES INCABM20161039.08
ABM INDUSTRIES INCABM20161144
ABM INDUSTRIES INCABM20161240.84
ABM INDUSTRIES INCABM2017140.39
ABM INDUSTRIES INCABM2017240.79
ABM INDUSTRIES INCABM2017343.6
ABM INDUSTRIES INCABM2017443.19
ABM INDUSTRIES INCABM2017543.04
ABM INDUSTRIES INCABM2017641.52
ABM INDUSTRIES INCABM2017744.62
ABM INDUSTRIES INCABM2017844.43
ABM INDUSTRIES INCABM2017941.71
ABM INDUSTRIES INCABM20171041.97
ABM INDUSTRIES INCABM20171142.8
ABM INDUSTRIES INCABM20171237.72
ABM INDUSTRIES INCABM2018138.03
ABM INDUSTRIES INCABM2018235.16
ABM INDUSTRIES INCABM2018333.48
ABM INDUSTRIES INCABM2018431.13
ABM INDUSTRIES INCABM2018528.46
ABM INDUSTRIES INCABM2018629.18
ABM INDUSTRIES INCABM2018731.2
ABM INDUSTRIES INCABM2018831.72
ABM INDUSTRIES INCABM2018932.25
ABM INDUSTRIES INCABM20181030.75
ABM INDUSTRIES INCABM20181131.68
ABM INDUSTRIES INCABM20181232.11
ABM INDUSTRIES INCABM2019134.19
ABM INDUSTRIES INCABM2019235.66
ABM INDUSTRIES INCABM2019336.35
ABM INDUSTRIES INCABM2019437.97
ABM INDUSTRIES INCABM2019536.25
ABM INDUSTRIES INCABM2019640
ABM INDUSTRIES INCABM2019742.09
ABM INDUSTRIES INCABM2019837.26
ABM INDUSTRIES INCABM2019936.32
ABM INDUSTRIES INCABM20191036.46
ABM INDUSTRIES INCABM20191137.99
ABM INDUSTRIES INCABM20191237.71
ABM INDUSTRIES INCABM2020138.14
ABM INDUSTRIES INCABM2020232.92
ABM INDUSTRIES INCABM2020324.36
ABM INDUSTRIES INCABM2020434.49
ABM INDUSTRIES INCABM2020530.73
ABM INDUSTRIES INCABM2020636.3
ABM INDUSTRIES INCABM2020735.9
ABM INDUSTRIES INCABM2020838.14
ABM INDUSTRIES INCABM2020936.66
ABM INDUSTRIES INCABM20201034.72
ABM INDUSTRIES INCABM20201138.5
ABM INDUSTRIES INCABM20201237.84
ABM INDUSTRIES INCABM2021136.74
ABM INDUSTRIES INCABM2021243.18
ABM INDUSTRIES INCABM2021351.01
ABM INDUSTRIES INCABM2021451.41
ABM INDUSTRIES INCABM2021549.89
ABM INDUSTRIES INCABM2021644.35
ABM INDUSTRIES INCABM2021746.49
ABM INDUSTRIES INCABM2021849.52
ABM INDUSTRIES INCABM2021945.01
ABM INDUSTRIES INCABM20211044.01
ABM INDUSTRIES INCABM20211145
ABM INDUSTRIES INCABM20211240.85
ABM INDUSTRIES INCABM2022141.69
ABM INDUSTRIES INCABM2022244.83
ABM INDUSTRIES INCABM2022346.04
ABM INDUSTRIES INCABM2022448.27
ABM INDUSTRIES INCABM2022548.35
ABM INDUSTRIES INCABM2022643.42
ABM INDUSTRIES INCABM2022744.84
ABM INDUSTRIES INCABM2022846.4
ABM INDUSTRIES INCABM2022938.23
ABM INDUSTRIES INCABM202210.
ACADIA PHARMACEUTICALS INCACAD200456.61
ACADIA PHARMACEUTICALS INCACAD200466.2
ACADIA PHARMACEUTICALS INCACAD200476.22
ACADIA PHARMACEUTICALS INCACAD200486.45
ACADIA PHARMACEUTICALS INCACAD200497.8
ACADIA PHARMACEUTICALS INCACAD2004107.63
ACADIA PHARMACEUTICALS INCACAD2004116.78
ACADIA PHARMACEUTICALS INCACAD2004126.77
ACADIA PHARMACEUTICALS INCACAD200517.07
ACADIA PHARMACEUTICALS INCACAD200527.52
ACADIA PHARMACEUTICALS INCACAD200536.9
ACADIA PHARMACEUTICALS INCACAD200547.46
ACADIA PHARMACEUTICALS INCACAD200558.73
ACADIA PHARMACEUTICALS INCACAD200568.4
ACADIA PHARMACEUTICALS INCACAD200579.55
ACADIA PHARMACEUTICALS INCACAD200589.57
ACADIA PHARMACEUTICALS INCACAD2005911.37
ACADIA PHARMACEUTICALS INCACAD20051010.5
ACADIA PHARMACEUTICALS INCACAD2005118.77
ACADIA PHARMACEUTICALS INCACAD2005129.85
ACADIA PHARMACEUTICALS INCACAD2006113.05
ACADIA PHARMACEUTICALS INCACAD2006214.97
ACADIA PHARMACEUTICALS INCACAD2006315.98
ACADIA PHARMACEUTICALS INCACAD2006411.57
ACADIA PHARMACEUTICALS INCACAD2006510.36
ACADIA PHARMACEUTICALS INCACAD200668.44
ACADIA PHARMACEUTICALS INCACAD200676.43
ACADIA PHARMACEUTICALS INCACAD200688.66
ACADIA PHARMACEUTICALS INCACAD200698.64
ACADIA PHARMACEUTICALS INCACAD2006109.48
ACADIA PHARMACEUTICALS INCACAD2006119.36
ACADIA PHARMACEUTICALS INCACAD2006128.79
ACADIA PHARMACEUTICALS INCACAD200717.15
ACADIA PHARMACEUTICALS INCACAD200726.96
ACADIA PHARMACEUTICALS INCACAD2007315.02
ACADIA PHARMACEUTICALS INCACAD2007413.66
ACADIA PHARMACEUTICALS INCACAD2007512.79
ACADIA PHARMACEUTICALS INCACAD2007613.67
ACADIA PHARMACEUTICALS INCACAD2007714.04
ACADIA PHARMACEUTICALS INCACAD2007814.39
ACADIA PHARMACEUTICALS INCACAD2007915.05
ACADIA PHARMACEUTICALS INCACAD20071015.38
ACADIA PHARMACEUTICALS INCACAD20071111.34
ACADIA PHARMACEUTICALS INCACAD20071211.07
ACADIA PHARMACEUTICALS INCACAD2008111.86
ACADIA PHARMACEUTICALS INCACAD200829.92
ACADIA PHARMACEUTICALS INCACAD200839.06
ACADIA PHARMACEUTICALS INCACAD200848
ACADIA PHARMACEUTICALS INCACAD200858.8
ACADIA PHARMACEUTICALS INCACAD200863.69
ACADIA PHARMACEUTICALS INCACAD200872.98
ACADIA PHARMACEUTICALS INCACAD200882.55
ACADIA PHARMACEUTICALS INCACAD200892.68
ACADIA PHARMACEUTICALS INCACAD2008101.9
ACADIA PHARMACEUTICALS INCACAD2008111.28
ACADIA PHARMACEUTICALS INCACAD2008120.9
ACADIA PHARMACEUTICALS INCACAD200911.01
ACADIA PHARMACEUTICALS INCACAD200920.83
ACADIA PHARMACEUTICALS INCACAD200930.95
ACADIA PHARMACEUTICALS INCACAD200940.99
ACADIA PHARMACEUTICALS INCACAD200951.96
ACADIA PHARMACEUTICALS INCACAD200962.19
ACADIA PHARMACEUTICALS INCACAD200974.07
ACADIA PHARMACEUTICALS INCACAD200985.84
ACADIA PHARMACEUTICALS INCACAD200991.71
ACADIA PHARMACEUTICALS INCACAD2009101.3
ACADIA PHARMACEUTICALS INCACAD2009111.23
ACADIA PHARMACEUTICALS INCACAD2009121.32
ACADIA PHARMACEUTICALS INCACAD201011.25
ACADIA PHARMACEUTICALS INCACAD201021.31
ACADIA PHARMACEUTICALS INCACAD201031.51
ACADIA PHARMACEUTICALS INCACAD201041.66
ACADIA PHARMACEUTICALS INCACAD201051.34
ACADIA PHARMACEUTICALS INCACAD201061.09
ACADIA PHARMACEUTICALS INCACAD201071.22
ACADIA PHARMACEUTICALS INCACAD201081.01
ACADIA PHARMACEUTICALS INCACAD201090.9112
ACADIA PHARMACEUTICALS INCACAD2010100.761
ACADIA PHARMACEUTICALS INCACAD2010110.6744
ACADIA PHARMACEUTICALS INCACAD2010121.2
ACADIA PHARMACEUTICALS INCACAD201111.7
ACADIA PHARMACEUTICALS INCACAD201121.51
ACADIA PHARMACEUTICALS INCACAD201131.62
ACADIA PHARMACEUTICALS INCACAD201142.75
ACADIA PHARMACEUTICALS INCACAD201151.89
ACADIA PHARMACEUTICALS INCACAD201161.63
ACADIA PHARMACEUTICALS INCACAD201171.63
ACADIA PHARMACEUTICALS INCACAD201181.36
ACADIA PHARMACEUTICALS INCACAD201191.08
ACADIA PHARMACEUTICALS INCACAD2011101.23
ACADIA PHARMACEUTICALS INCACAD2011110.98
ACADIA PHARMACEUTICALS INCACAD2011121.08
ACADIA PHARMACEUTICALS INCACAD201211.51
ACADIA PHARMACEUTICALS INCACAD201221.67
ACADIA PHARMACEUTICALS INCACAD201232.15
ACADIA PHARMACEUTICALS INCACAD201241.5
ACADIA PHARMACEUTICALS INCACAD201251.38
ACADIA PHARMACEUTICALS INCACAD201261.76
ACADIA PHARMACEUTICALS INCACAD201271.61
ACADIA PHARMACEUTICALS INCACAD201281.78
ACADIA PHARMACEUTICALS INCACAD201292.53
ACADIA PHARMACEUTICALS INCACAD2012102.35
ACADIA PHARMACEUTICALS INCACAD2012115.2
ACADIA PHARMACEUTICALS INCACAD2012124.65
ACADIA PHARMACEUTICALS INCACAD201316.03
ACADIA PHARMACEUTICALS INCACAD201326.07
ACADIA PHARMACEUTICALS INCACAD201337.94
ACADIA PHARMACEUTICALS INCACAD2013412.89
ACADIA PHARMACEUTICALS INCACAD2013514.07
ACADIA PHARMACEUTICALS INCACAD2013618.15
ACADIA PHARMACEUTICALS INCACAD2013719.7
ACADIA PHARMACEUTICALS INCACAD2013819.96
ACADIA PHARMACEUTICALS INCACAD2013927.47
ACADIA PHARMACEUTICALS INCACAD20131022.725
ACADIA PHARMACEUTICALS INCACAD20131123.29
ACADIA PHARMACEUTICALS INCACAD20131224.99
ACADIA PHARMACEUTICALS INCACAD2014123.3
ACADIA PHARMACEUTICALS INCACAD2014228.3
ACADIA PHARMACEUTICALS INCACAD2014324.33
ACADIA PHARMACEUTICALS INCACAD2014420.13
ACADIA PHARMACEUTICALS INCACAD2014520.65
ACADIA PHARMACEUTICALS INCACAD2014622.59
ACADIA PHARMACEUTICALS INCACAD2014720.27
ACADIA PHARMACEUTICALS INCACAD2014823.98
ACADIA PHARMACEUTICALS INCACAD2014924.76
ACADIA PHARMACEUTICALS INCACAD20141027.7
ACADIA PHARMACEUTICALS INCACAD20141129.87
ACADIA PHARMACEUTICALS INCACAD20141231.75
ACADIA PHARMACEUTICALS INCACAD2015130.43
ACADIA PHARMACEUTICALS INCACAD2015237.97
ACADIA PHARMACEUTICALS INCACAD2015332.59
ACADIA PHARMACEUTICALS INCACAD2015434.17
ACADIA PHARMACEUTICALS INCACAD2015541.2
ACADIA PHARMACEUTICALS INCACAD2015641.88
ACADIA PHARMACEUTICALS INCACAD2015748.81
ACADIA PHARMACEUTICALS INCACAD2015836.63
ACADIA PHARMACEUTICALS INCACAD2015933.07
ACADIA PHARMACEUTICALS INCACAD20151034.82
ACADIA PHARMACEUTICALS INCACAD20151137.95
ACADIA PHARMACEUTICALS INCACAD20151235.65
ACADIA PHARMACEUTICALS INCACAD2016120.69
ACADIA PHARMACEUTICALS INCACAD2016217.26
ACADIA PHARMACEUTICALS INCACAD2016327.96
ACADIA PHARMACEUTICALS INCACAD2016432.3
ACADIA PHARMACEUTICALS INCACAD2016535.43
ACADIA PHARMACEUTICALS INCACAD2016632.46
ACADIA PHARMACEUTICALS INCACAD2016737.04
ACADIA PHARMACEUTICALS INCACAD2016832.13
ACADIA PHARMACEUTICALS INCACAD2016931.81
ACADIA PHARMACEUTICALS INCACAD20161023.31
ACADIA PHARMACEUTICALS INCACAD20161126.99
ACADIA PHARMACEUTICALS INCACAD20161228.84
ACADIA PHARMACEUTICALS INCACAD2017134.59
ACADIA PHARMACEUTICALS INCACAD2017238.11
ACADIA PHARMACEUTICALS INCACAD2017334.38
ACADIA PHARMACEUTICALS INCACAD2017434.33
ACADIA PHARMACEUTICALS INCACAD2017525.71
ACADIA PHARMACEUTICALS INCACAD2017627.89
ACADIA PHARMACEUTICALS INCACAD2017729.77
ACADIA PHARMACEUTICALS INCACAD2017835.61
ACADIA PHARMACEUTICALS INCACAD2017937.67
ACADIA PHARMACEUTICALS INCACAD20171034.83
ACADIA PHARMACEUTICALS INCACAD20171130.25
ACADIA PHARMACEUTICALS INCACAD20171230.11
ACADIA PHARMACEUTICALS INCACAD2018129.91
ACADIA PHARMACEUTICALS INCACAD2018224.915
ACADIA PHARMACEUTICALS INCACAD2018322.47
ACADIA PHARMACEUTICALS INCACAD2018415.81
ACADIA PHARMACEUTICALS INCACAD2018518.1
ACADIA PHARMACEUTICALS INCACAD2018615.27
ACADIA PHARMACEUTICALS INCACAD2018715.09
ACADIA PHARMACEUTICALS INCACAD2018814.22
ACADIA PHARMACEUTICALS INCACAD2018920.76
ACADIA PHARMACEUTICALS INCACAD20181019.48
ACADIA PHARMACEUTICALS INCACAD20181119.06
ACADIA PHARMACEUTICALS INCACAD20181216.17
ACADIA PHARMACEUTICALS INCACAD2019122.78
ACADIA PHARMACEUTICALS INCACAD2019226.5
ACADIA PHARMACEUTICALS INCACAD2019326.85
ACADIA PHARMACEUTICALS INCACAD2019424.05
ACADIA PHARMACEUTICALS INCACAD2019523.99
ACADIA PHARMACEUTICALS INCACAD2019626.73
ACADIA PHARMACEUTICALS INCACAD2019724.58
ACADIA PHARMACEUTICALS INCACAD2019827.66
ACADIA PHARMACEUTICALS INCACAD2019935.99
ACADIA PHARMACEUTICALS INCACAD20191042.41
ACADIA PHARMACEUTICALS INCACAD20191145.29
ACADIA PHARMACEUTICALS INCACAD20191242.78
ACADIA PHARMACEUTICALS INCACAD2020139.94
ACADIA PHARMACEUTICALS INCACAD2020242.74
ACADIA PHARMACEUTICALS INCACAD2020342.25
ACADIA PHARMACEUTICALS INCACAD2020448.31
ACADIA PHARMACEUTICALS INCACAD2020549.68
ACADIA PHARMACEUTICALS INCACAD2020648.47
ACADIA PHARMACEUTICALS INCACAD2020741.57
ACADIA PHARMACEUTICALS INCACAD2020839.59
ACADIA PHARMACEUTICALS INCACAD2020941.25
ACADIA PHARMACEUTICALS INCACAD20201046.45
ACADIA PHARMACEUTICALS INCACAD20201156.66
ACADIA PHARMACEUTICALS INCACAD20201253.46
ACADIA PHARMACEUTICALS INCACAD2021148.05
ACADIA PHARMACEUTICALS INCACAD2021248.97
ACADIA PHARMACEUTICALS INCACAD2021325.8
ACADIA PHARMACEUTICALS INCACAD2021420.56
ACADIA PHARMACEUTICALS INCACAD2021522.34
ACADIA PHARMACEUTICALS INCACAD2021624.39
ACADIA PHARMACEUTICALS INCACAD2021721.63
ACADIA PHARMACEUTICALS INCACAD2021817.51
ACADIA PHARMACEUTICALS INCACAD2021916.61
ACADIA PHARMACEUTICALS INCACAD20211017.95
ACADIA PHARMACEUTICALS INCACAD20211119.2
ACADIA PHARMACEUTICALS INCACAD20211223.34
ACADIA PHARMACEUTICALS INCACAD2022122.49
ACADIA PHARMACEUTICALS INCACAD2022225.41
ACADIA PHARMACEUTICALS INCACAD2022324.22
ACADIA PHARMACEUTICALS INCACAD2022418.44
ACADIA PHARMACEUTICALS INCACAD2022516.15
ACADIA PHARMACEUTICALS INCACAD2022614.09
ACADIA PHARMACEUTICALS INCACAD2022714.69
ACADIA PHARMACEUTICALS INCACAD2022816.43
ACADIA PHARMACEUTICALS INCACAD2022916.36
ASCENT INDUSTRIES COACNT198666.62499833
ASCENT INDUSTRIES COACNT198676.24999762
ASCENT INDUSTRIES COACNT198684.99999809
ASCENT INDUSTRIES COACNT198694.24999881
ASCENT INDUSTRIES COACNT1986104.7499969
ASCENT INDUSTRIES COACNT1986114.62499738
ASCENT INDUSTRIES COACNT1986124.62499738
ASCENT INDUSTRIES COACNT198714.37499833
ASCENT INDUSTRIES COACNT198724.87499642
ASCENT INDUSTRIES COACNT198734.7499969
ASCENT INDUSTRIES COACNT198744.99999809
ASCENT INDUSTRIES COACNT198754.62499738
ASCENT INDUSTRIES COACNT198764.37499833
ASCENT INDUSTRIES COACNT198774.24999881
ASCENT INDUSTRIES COACNT198784.49999785
ASCENT INDUSTRIES COACNT198795.24999714
ASCENT INDUSTRIES COACNT1987104.49999785
ASCENT INDUSTRIES COACNT1987113.87499809
ASCENT INDUSTRIES COACNT1987123.6249969
ASCENT INDUSTRIES COACNT198813.49999738
ASCENT INDUSTRIES COACNT198823.87499809
ASCENT INDUSTRIES COACNT198833.99999762
ASCENT INDUSTRIES COACNT198844.49999785
ASCENT INDUSTRIES COACNT198855.24999714
ASCENT INDUSTRIES COACNT198866.9999969
ASCENT INDUSTRIES COACNT198875.74999738
ASCENT INDUSTRIES COACNT198885.24999714
ASCENT INDUSTRIES COACNT198894.99999809
ASCENT INDUSTRIES COACNT1988105.37499881
ASCENT INDUSTRIES COACNT1988116.12499809
ASCENT INDUSTRIES COACNT1988125.8749969
ASCENT INDUSTRIES COACNT198916.49999881
ASCENT INDUSTRIES COACNT198927.87499785
ASCENT INDUSTRIES COACNT198937.74999833
ASCENT INDUSTRIES COACNT198948.37499595
ASCENT INDUSTRIES COACNT198959.2499969
ASCENT INDUSTRIES COACNT198969.2499969
ASCENT INDUSTRIES COACNT198979.2499969
ASCENT INDUSTRIES COACNT198989.37499642
ASCENT INDUSTRIES COACNT1989910.3749969
ASCENT INDUSTRIES COACNT1989109.74999714
ASCENT INDUSTRIES COACNT1989119.87499666
ASCENT INDUSTRIES COACNT19891210.12499785
ASCENT INDUSTRIES COACNT199019.49999595
ASCENT INDUSTRIES COACNT199028.49999762
ASCENT INDUSTRIES COACNT199038.74999666
ASCENT INDUSTRIES COACNT199047.74999833
ASCENT INDUSTRIES COACNT199057.74999833
ASCENT INDUSTRIES COACNT199068.62499714
ASCENT INDUSTRIES COACNT199078.1249969
ASCENT INDUSTRIES COACNT199086.62499833
ASCENT INDUSTRIES COACNT199095.8749969
ASCENT INDUSTRIES COACNT1990106.74999785
ASCENT INDUSTRIES COACNT1990117.24999809
ASCENT INDUSTRIES COACNT1990127.37499762
ASCENT INDUSTRIES COACNT199118.74999666
ASCENT INDUSTRIES COACNT1991212.99999762
ASCENT INDUSTRIES COACNT1991313.7499969
ASCENT INDUSTRIES COACNT1991414.62499571
ASCENT INDUSTRIES COACNT1991514.8749969
ASCENT INDUSTRIES COACNT1991612.49999523
ASCENT INDUSTRIES COACNT1991712.12499666
ASCENT INDUSTRIES COACNT1991812.6249969
ASCENT INDUSTRIES COACNT1991911.12499833
ASCENT INDUSTRIES COACNT19911012.49999523
ASCENT INDUSTRIES COACNT19911112.24999619
ASCENT INDUSTRIES COACNT19911212.99999762
ASCENT INDUSTRIES COACNT1992116.49999714
ASCENT INDUSTRIES COACNT1992216.12499642
ASCENT INDUSTRIES COACNT1992318.99999619
ASCENT INDUSTRIES COACNT1992422.24999666
ASCENT INDUSTRIES COACNT1992524.74997425
ASCENT INDUSTRIES COACNT1992624.37497354
ASCENT INDUSTRIES COACNT1992728.12497425
ASCENT INDUSTRIES COACNT1992826.62497354
ASCENT INDUSTRIES COACNT1992918.74999857
ASCENT INDUSTRIES COACNT19921020.24999857
ASCENT INDUSTRIES COACNT19921124.24998474
ASCENT INDUSTRIES COACNT19921225.99999237
ASCENT INDUSTRIES COACNT1993125.99999237
ASCENT INDUSTRIES COACNT1993223.99999857
ASCENT INDUSTRIES COACNT1993327.99998474
ASCENT INDUSTRIES COACNT1993415.99999905
ASCENT INDUSTRIES COACNT1993519.49999857
ASCENT INDUSTRIES COACNT1993615.49999809
ASCENT INDUSTRIES COACNT1993716.87499857
ASCENT INDUSTRIES COACNT1993818.49999809
ASCENT INDUSTRIES COACNT1993915.37499857
ASCENT INDUSTRIES COACNT19931014.24999857
ASCENT INDUSTRIES COACNT19931113.99999809
ASCENT INDUSTRIES COACNT19931214.24999857
ASCENT INDUSTRIES COACNT1994116.62499809
ASCENT INDUSTRIES COACNT1994217.99999857
ASCENT INDUSTRIES COACNT1994318.49999809
ASCENT INDUSTRIES COACNT1994417.99999857
ASCENT INDUSTRIES COACNT1994518.49999809
ASCENT INDUSTRIES COACNT1994617.49999762
ASCENT INDUSTRIES COACNT1994719.24999809
ASCENT INDUSTRIES COACNT1994818.99999762
ASCENT INDUSTRIES COACNT1994918.49999809
ASCENT INDUSTRIES COACNT19941019.49999857
ASCENT INDUSTRIES COACNT19941117.62499857
ASCENT INDUSTRIES COACNT19941217.74999809
ASCENT INDUSTRIES COACNT1995119.24999809
ASCENT INDUSTRIES COACNT1995220.99999857
ASCENT INDUSTRIES COACNT1995322.74999762
ASCENT INDUSTRIES COACNT1995422.24999809
ASCENT INDUSTRIES COACNT1995522.99999809
ASCENT INDUSTRIES COACNT1995618.75
ASCENT INDUSTRIES COACNT1995720.75
ASCENT INDUSTRIES COACNT1995820.75
ASCENT INDUSTRIES COACNT1995922.875
ASCENT INDUSTRIES COACNT19951020.5
ASCENT INDUSTRIES COACNT19951120.375
ASCENT INDUSTRIES COACNT19951221.125
ASCENT INDUSTRIES COACNT1996115.5
ASCENT INDUSTRIES COACNT1996218.75
ASCENT INDUSTRIES COACNT1996319
ASCENT INDUSTRIES COACNT1996419.25
ASCENT INDUSTRIES COACNT1996519.375
ASCENT INDUSTRIES COACNT1996616.25
ASCENT INDUSTRIES COACNT1996713.25
ASCENT INDUSTRIES COACNT1996814.25
ASCENT INDUSTRIES COACNT1996915.5
ASCENT INDUSTRIES COACNT19961016.25
ASCENT INDUSTRIES COACNT19961116.75
ASCENT INDUSTRIES COACNT19961215.75
ASCENT INDUSTRIES COACNT1997116.75
ASCENT INDUSTRIES COACNT1997217.75
ASCENT INDUSTRIES COACNT1997316
ASCENT INDUSTRIES COACNT1997415.25
ASCENT INDUSTRIES COACNT1997515.5
ASCENT INDUSTRIES COACNT1997617.625
ASCENT INDUSTRIES COACNT1997717.75
ASCENT INDUSTRIES COACNT1997816.25
ASCENT INDUSTRIES COACNT1997916.25
ASCENT INDUSTRIES COACNT19971015.5
ASCENT INDUSTRIES COACNT19971114.75
ASCENT INDUSTRIES COACNT19971214.75
ASCENT INDUSTRIES COACNT1998114.81199932
ASCENT INDUSTRIES COACNT1998214
ASCENT INDUSTRIES COACNT1998314.125
ASCENT INDUSTRIES COACNT1998413.375
ASCENT INDUSTRIES COACNT1998513.375
ASCENT INDUSTRIES COACNT1998613.5
ASCENT INDUSTRIES COACNT1998711.875
ASCENT INDUSTRIES COACNT199889.875
ASCENT INDUSTRIES COACNT1998910
ASCENT INDUSTRIES COACNT1998109
ASCENT INDUSTRIES COACNT1998119.375
ASCENT INDUSTRIES COACNT1998128.75
ASCENT INDUSTRIES COACNT1999111.125
ASCENT INDUSTRIES COACNT199928.5
ASCENT INDUSTRIES COACNT199936.875
ASCENT INDUSTRIES COACNT199948
ASCENT INDUSTRIES COACNT199957.875
ASCENT INDUSTRIES COACNT199968.125
ASCENT INDUSTRIES COACNT199977.25
ASCENT INDUSTRIES COACNT199987.25
ASCENT INDUSTRIES COACNT199996.875
ASCENT INDUSTRIES COACNT1999107
ASCENT INDUSTRIES COACNT1999117
ASCENT INDUSTRIES COACNT1999127.5
ASCENT INDUSTRIES COACNT200017.875
ASCENT INDUSTRIES COACNT200027.5
ASCENT INDUSTRIES COACNT200037.375
ASCENT INDUSTRIES COACNT200047.75
ASCENT INDUSTRIES COACNT200057.375
ASCENT INDUSTRIES COACNT200067.109375
ASCENT INDUSTRIES COACNT200076.75
ASCENT INDUSTRIES COACNT200086.625
ASCENT INDUSTRIES COACNT200095.9375
ASCENT INDUSTRIES COACNT2000104.8125
ASCENT INDUSTRIES COACNT2000114.875
ASCENT INDUSTRIES COACNT2000124.75
ASCENT INDUSTRIES COACNT200115.53125
ASCENT INDUSTRIES COACNT200125.25
ASCENT INDUSTRIES COACNT200135
ASCENT INDUSTRIES COACNT200146.94
ASCENT INDUSTRIES COACNT200157.31
ASCENT INDUSTRIES COACNT200166.9
ASCENT INDUSTRIES COACNT200176.32
ASCENT INDUSTRIES COACNT200185.15
ASCENT INDUSTRIES COACNT200194.75
ASCENT INDUSTRIES COACNT2001104.65
ASCENT INDUSTRIES COACNT2001114.15
ASCENT INDUSTRIES COACNT2001123.47
ASCENT INDUSTRIES COACNT200213.6
ASCENT INDUSTRIES COACNT200224.13
ASCENT INDUSTRIES COACNT200234.8
ASCENT INDUSTRIES COACNT200244.45
ASCENT INDUSTRIES COACNT200254.559
ASCENT INDUSTRIES COACNT200263.01
ASCENT INDUSTRIES COACNT200272.6
ASCENT INDUSTRIES COACNT200282.14
ASCENT INDUSTRIES COACNT200292.08
ASCENT INDUSTRIES COACNT2002103.6
ASCENT INDUSTRIES COACNT2002114.6838
ASCENT INDUSTRIES COACNT2002124.16
ASCENT INDUSTRIES COACNT200314.05
ASCENT INDUSTRIES COACNT200324
ASCENT INDUSTRIES COACNT200334
ASCENT INDUSTRIES COACNT200344.15
ASCENT INDUSTRIES COACNT200355.21
ASCENT INDUSTRIES COACNT200365.43
ASCENT INDUSTRIES COACNT200375.85
ASCENT INDUSTRIES COACNT200386.04
ASCENT INDUSTRIES COACNT200395.819
ASCENT INDUSTRIES COACNT2003105.9
ASCENT INDUSTRIES COACNT2003116.85
ASCENT INDUSTRIES COACNT2003126.92
ASCENT INDUSTRIES COACNT200416.64
ASCENT INDUSTRIES COACNT200426.71
ASCENT INDUSTRIES COACNT200436.85
ASCENT INDUSTRIES COACNT200448.81
ASCENT INDUSTRIES COACNT200459.29
ASCENT INDUSTRIES COACNT2004610.2
ASCENT INDUSTRIES COACNT2004710.15
ASCENT INDUSTRIES COACNT200489.94
ASCENT INDUSTRIES COACNT2004910
ASCENT INDUSTRIES COACNT20041010.08
ASCENT INDUSTRIES COACNT2004119.75
ASCENT INDUSTRIES COACNT2004129.9
ASCENT INDUSTRIES COACNT200519.9
ASCENT INDUSTRIES COACNT2005210.03
ASCENT INDUSTRIES COACNT2005310.2
ASCENT INDUSTRIES COACNT2005411.25
ASCENT INDUSTRIES COACNT2005511.6
ASCENT INDUSTRIES COACNT2005610.15
ASCENT INDUSTRIES COACNT2005711.254
ASCENT INDUSTRIES COACNT2005811
ASCENT INDUSTRIES COACNT2005911.189
ASCENT INDUSTRIES COACNT20051010.73
ASCENT INDUSTRIES COACNT20051110.09
ASCENT INDUSTRIES COACNT20051210.464
ASCENT INDUSTRIES COACNT2006111.99
ASCENT INDUSTRIES COACNT2006213
ASCENT INDUSTRIES COACNT2006314.99
ASCENT INDUSTRIES COACNT2006412.93
ASCENT INDUSTRIES COACNT2006513.01
ASCENT INDUSTRIES COACNT2006613.04
ASCENT INDUSTRIES COACNT2006713.6
ASCENT INDUSTRIES COACNT2006813.92
ASCENT INDUSTRIES COACNT2006914.29
ASCENT INDUSTRIES COACNT20061016.4
ASCENT INDUSTRIES COACNT20061117.8
ASCENT INDUSTRIES COACNT20061218.54
ASCENT INDUSTRIES COACNT2007118.68
ASCENT INDUSTRIES COACNT2007224.55
ASCENT INDUSTRIES COACNT2007327.92
ASCENT INDUSTRIES COACNT2007437.26
ASCENT INDUSTRIES COACNT2007537.1
ASCENT INDUSTRIES COACNT2007634.9
ASCENT INDUSTRIES COACNT2007721.18
ASCENT INDUSTRIES COACNT2007820.048
ASCENT INDUSTRIES COACNT2007921.1
ASCENT INDUSTRIES COACNT20071017.98
ASCENT INDUSTRIES COACNT20071117.44
ASCENT INDUSTRIES COACNT20071217.19
ASCENT INDUSTRIES COACNT2008115.6
ASCENT INDUSTRIES COACNT2008213.04
ASCENT INDUSTRIES COACNT2008312.16
ASCENT INDUSTRIES COACNT2008416
ASCENT INDUSTRIES COACNT2008517.25
ASCENT INDUSTRIES COACNT2008615.42
ASCENT INDUSTRIES COACNT2008715.31
ASCENT INDUSTRIES COACNT2008815.45
ASCENT INDUSTRIES COACNT2008913.55
ASCENT INDUSTRIES COACNT2008107.5
ASCENT INDUSTRIES COACNT2008114.225
ASCENT INDUSTRIES COACNT2008124.8
ASCENT INDUSTRIES COACNT200915.48
ASCENT INDUSTRIES COACNT200925.19
ASCENT INDUSTRIES COACNT200935.25
ASCENT INDUSTRIES COACNT200946.03
ASCENT INDUSTRIES COACNT200958.1
ASCENT INDUSTRIES COACNT200968.3
ASCENT INDUSTRIES COACNT200978.7
ASCENT INDUSTRIES COACNT2009810.05
ASCENT INDUSTRIES COACNT200999.49
ASCENT INDUSTRIES COACNT2009109.04
ASCENT INDUSTRIES COACNT2009119.03
ASCENT INDUSTRIES COACNT2009129.42
ASCENT INDUSTRIES COACNT201018.0108
ASCENT INDUSTRIES COACNT201028
ASCENT INDUSTRIES COACNT201038.12
ASCENT INDUSTRIES COACNT201049.84
ASCENT INDUSTRIES COACNT201059.53
ASCENT INDUSTRIES COACNT201068.4
ASCENT INDUSTRIES COACNT201079.25
ASCENT INDUSTRIES COACNT201089.78
ASCENT INDUSTRIES COACNT201098.5
ASCENT INDUSTRIES COACNT2010109.3
ASCENT INDUSTRIES COACNT2010119.4
ASCENT INDUSTRIES COACNT20101212.12
ASCENT INDUSTRIES COACNT2011112.0001
ASCENT INDUSTRIES COACNT2011214.25
ASCENT INDUSTRIES COACNT2011312.87
ASCENT INDUSTRIES COACNT2011414.98
ASCENT INDUSTRIES COACNT2011514.72
ASCENT INDUSTRIES COACNT2011613.57
ASCENT INDUSTRIES COACNT2011711.55
ASCENT INDUSTRIES COACNT2011810.375
ASCENT INDUSTRIES COACNT2011911
ASCENT INDUSTRIES COACNT20111010.02
ASCENT INDUSTRIES COACNT20111110.5
ASCENT INDUSTRIES COACNT20111210.27
ASCENT INDUSTRIES COACNT2012110.76
ASCENT INDUSTRIES COACNT2012212.46
ASCENT INDUSTRIES COACNT2012313.14
ASCENT INDUSTRIES COACNT2012412.07
ASCENT INDUSTRIES COACNT2012511.7
ASCENT INDUSTRIES COACNT2012611.39
ASCENT INDUSTRIES COACNT2012712.51
ASCENT INDUSTRIES COACNT2012813.1
ASCENT INDUSTRIES COACNT2012913.8
ASCENT INDUSTRIES COACNT20121013.76
ASCENT INDUSTRIES COACNT20121113.346
ASCENT INDUSTRIES COACNT20121214.31
ASCENT INDUSTRIES COACNT2013114.28
ASCENT INDUSTRIES COACNT2013213.65
ASCENT INDUSTRIES COACNT2013314
ASCENT INDUSTRIES COACNT2013414
ASCENT INDUSTRIES COACNT2013514.69
ASCENT INDUSTRIES COACNT2013615.53
ASCENT INDUSTRIES COACNT2013716.57
ASCENT INDUSTRIES COACNT2013815.63
ASCENT INDUSTRIES COACNT2013916.38
ASCENT INDUSTRIES COACNT20131016.09
ASCENT INDUSTRIES COACNT20131116.11
ASCENT INDUSTRIES COACNT20131215.36
ASCENT INDUSTRIES COACNT2014115.29
ASCENT INDUSTRIES COACNT2014213.63
ASCENT INDUSTRIES COACNT2014314.36
ASCENT INDUSTRIES COACNT2014415.5
ASCENT INDUSTRIES COACNT2014515.67
ASCENT INDUSTRIES COACNT2014616.42
ASCENT INDUSTRIES COACNT2014716.54
ASCENT INDUSTRIES COACNT2014817.85
ASCENT INDUSTRIES COACNT2014917.4
ASCENT INDUSTRIES COACNT20141016.2
ASCENT INDUSTRIES COACNT20141117.15
ASCENT INDUSTRIES COACNT20141217.61
ASCENT INDUSTRIES COACNT2015116.7
ASCENT INDUSTRIES COACNT2015215.1
ASCENT INDUSTRIES COACNT2015314.41
ASCENT INDUSTRIES COACNT2015414.77
ASCENT INDUSTRIES COACNT2015514.48
ASCENT INDUSTRIES COACNT2015613.7
ASCENT INDUSTRIES COACNT2015711.81
ASCENT INDUSTRIES COACNT201589.76
ASCENT INDUSTRIES COACNT201599.04
ASCENT INDUSTRIES COACNT2015108.72
ASCENT INDUSTRIES COACNT2015118.2
ASCENT INDUSTRIES COACNT2015126.88
ASCENT INDUSTRIES COACNT201617.05
ASCENT INDUSTRIES COACNT201627.97
ASCENT INDUSTRIES COACNT201637.92
ASCENT INDUSTRIES COACNT201648.4
ASCENT INDUSTRIES COACNT201657.6
ASCENT INDUSTRIES COACNT201667.66
ASCENT INDUSTRIES COACNT201677.63
ASCENT INDUSTRIES COACNT201687.08
ASCENT INDUSTRIES COACNT201699.51
ASCENT INDUSTRIES COACNT20161010.3
ASCENT INDUSTRIES COACNT20161110.15
ASCENT INDUSTRIES COACNT20161210.95
ASCENT INDUSTRIES COACNT2017111.95
ASCENT INDUSTRIES COACNT2017210.45
ASCENT INDUSTRIES COACNT2017312.25
ASCENT INDUSTRIES COACNT2017412.95
ASCENT INDUSTRIES COACNT2017511.75
ASCENT INDUSTRIES COACNT2017611.31
ASCENT INDUSTRIES COACNT2017711.3
ASCENT INDUSTRIES COACNT2017811.35
ASCENT INDUSTRIES COACNT2017912.5
ASCENT INDUSTRIES COACNT20171014.3
ASCENT INDUSTRIES COACNT20171113.1
ASCENT INDUSTRIES COACNT20171213.4
ASCENT INDUSTRIES COACNT2018113.7
ASCENT INDUSTRIES COACNT2018213.7
ASCENT INDUSTRIES COACNT2018314.6
ASCENT INDUSTRIES COACNT2018417.25
ASCENT INDUSTRIES COACNT2018518.9
ASCENT INDUSTRIES COACNT2018619.95
ASCENT INDUSTRIES COACNT2018721.6
ASCENT INDUSTRIES COACNT2018822.95
ASCENT INDUSTRIES COACNT2018922.85
ASCENT INDUSTRIES COACNT20181018.49
ASCENT INDUSTRIES COACNT20181116.11
ASCENT INDUSTRIES COACNT20181216.59
ASCENT INDUSTRIES COACNT2019115.8
ASCENT INDUSTRIES COACNT2019215.27
ASCENT INDUSTRIES COACNT2019315.2
ASCENT INDUSTRIES COACNT2019417.65
ASCENT INDUSTRIES COACNT2019518.56
ASCENT INDUSTRIES COACNT2019615.62
ASCENT INDUSTRIES COACNT2019716.98
ASCENT INDUSTRIES COACNT2019816.04
ASCENT INDUSTRIES COACNT2019915.95
ASCENT INDUSTRIES COACNT20191015.66
ASCENT INDUSTRIES COACNT20191112.94
ASCENT INDUSTRIES COACNT20191212.91
ASCENT INDUSTRIES COACNT2020112.83
ASCENT INDUSTRIES COACNT2020211.45
ASCENT INDUSTRIES COACNT202038.73
ASCENT INDUSTRIES COACNT202048.84
ASCENT INDUSTRIES COACNT202059.34
ASCENT INDUSTRIES COACNT202067.48
ASCENT INDUSTRIES COACNT202077.1
ASCENT INDUSTRIES COACNT202086.31
ASCENT INDUSTRIES COACNT202095.52
ASCENT INDUSTRIES COACNT2020105.19
ASCENT INDUSTRIES COACNT2020116.355
ASCENT INDUSTRIES COACNT2020127.8
ASCENT INDUSTRIES COACNT202118
ASCENT INDUSTRIES COACNT202128.67
ASCENT INDUSTRIES COACNT202138.84
ASCENT INDUSTRIES COACNT202149.11
ASCENT INDUSTRIES COACNT202159.87
ASCENT INDUSTRIES COACNT202169.99
ASCENT INDUSTRIES COACNT202179.81
ASCENT INDUSTRIES COACNT2021811.65
ASCENT INDUSTRIES COACNT2021910.99
ASCENT INDUSTRIES COACNT20211011.3
ASCENT INDUSTRIES COACNT20211114
ASCENT INDUSTRIES COACNT20211216.43
ASCENT INDUSTRIES COACNT2022116.66
ASCENT INDUSTRIES COACNT2022215.98
ASCENT INDUSTRIES COACNT2022316.05
ASCENT INDUSTRIES COACNT2022416.39
ASCENT INDUSTRIES COACNT2022516.05
ASCENT INDUSTRIES COACNT2022614.06
ASCENT INDUSTRIES COACNT2022713.81
ASCENT INDUSTRIES COACNT2022816.74
ASCENT INDUSTRIES COACNT2022914.01
;;;;



 

1 ACCEPTED SOLUTION

Accepted Solutions
PeterClemmensen
Tourmaline | Level 20

That is a lot of sample data 🙂 For simplicity, I use sashelp.stocks data instead, it is similar in structure to your data.

 

You can use the lag12() function and set the first 12 values for each group to missing like this.

 

proc sort data = sashelp.stocks out = stocks;
   by stock date;
run;

data want(drop = c);
   set stocks;
   by stock;

   if first.stock then c = 0;

   l = lag12(close);
   c + 1;

   if c <= 12 then l = .;
run;

View solution in original post

6 REPLIES 6
PeterClemmensen
Tourmaline | Level 20

That is a lot of sample data 🙂 For simplicity, I use sashelp.stocks data instead, it is similar in structure to your data.

 

You can use the lag12() function and set the first 12 values for each group to missing like this.

 

proc sort data = sashelp.stocks out = stocks;
   by stock date;
run;

data want(drop = c);
   set stocks;
   by stock;

   if first.stock then c = 0;

   l = lag12(close);
   c + 1;

   if c <= 12 then l = .;
run;
lioradam
Obsidian | Level 7

Thank you 🙂

mkeintz
PROC Star

Can you guarantee that none of your data series has any "holes".   Otherwise, if a single month is skipped, then all observations 12 months later will have 13-month old lags instead of 12-months.

--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

--------------------------
lioradam
Obsidian | Level 7

Hi,

Thank you for that comment.

The data are for monthly share price, so there are no holes (in each month there is a value).

 

Kind Regards,

Lior

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 6 replies
  • 1962 views
  • 0 likes
  • 3 in conversation