Hi,   I have a panel dataset like below. data have; input FirmID $ Year Count; datalines; 1001 1992 1 1001 1993 2 1001 1994 3 1001 1995 4 1001 1996 5 1001 1997 5 1002 1992 6 1002 1993 7 1002 1994 8 1002 1995 9 1002 1996 8 1002 1997 7 ;   I would like to get the sum of the count in the previous 3 years. For example, Pre3 in 1995 is 6 (1+2+3). The result I want is below.   FirmID      Year       Count       Pre3 1001        1992          1             . 1001        1993          2             . 1001        1994          3             . 1001        1995          4            6 1001        1996          5            9 1001        1997          5           12 1002        1992          6            . 1002        1993          7            . 1002        1994          8           . 1002        1995          9          21 1002        1996          8          24 1002        1997          7          25 What program do I need to use? ... View more

Hi,   I have a dataset like below.   FirmID      Year       Count 1001        1992          1 1001        1993          2 1001        1994          3 1001        1995          4 1001        1996          5 1001        1997          5   I would like to get the sum of the count in the previous 3 years. For example, Pre3 in 1995 is 6 (1+2+3). The result I want is below.   FirmID      Year       Count       Pre3 1001        1992          1             . 1001        1993          2             . 1001        1994          3             . 1001        1995          4            6 1001        1996          5            9 1001        1997          5           12   I tried to use proc expand, but the sum includes the count in the same year. If I only want to include the previous 3 years, what program do I need? Thanks.   proc expand data=have out=want; by firmID; id Year; Convert Count=Pre3 / transformout=(movsum 3 trimleft 2); run; ... View more

Hello,   I would like to calculate the Herfindahl index each year. There are three steps.   1. calculate the total industry sales for each year, which is the sum of sales for each firm each year. 2. calculate the market share square for each firm each year. Market_share_sqr = (sales for each firm each year / total industry sale for that year)^2. 3. select the 50 largest market share each year and add them up.   The sample data is below.   FirmID Year Sales 1001 1992 1 1001 1993 2 1001 1994 3 1002 1992 4 1002 1993 5 1002 1994 6 1003 1992 7 1003 1993 8 1003 1994 9 1004 1992 10 1004 1993 11 1004 1994 12   Want: Since I have 4 firms here, I only select the larget two market shares. In my complete data, there are more than 200 firms and I would like to select the largest 50 firms each year.   Year H_Index 1992 0.307851 1993 0.273669 1994 0.25     What program do I need to use? Thanks. ... View more

Hi,   I have a panel dataset like below.   FirmID           Year 1001             1995 1001             1996 1001             1997 1001             1998 1002              2011 1002             2012 1003             1992 1004             2015 1004             2016 1004             2017   I would like to delete firms that exist for less than 3 years. In my data above, firm 1002 and 1003 should be deleted.   What program do I need to use? Thanks. ... View more

Hi SAS Master,   I have an unbalanced panel like below.    ID year value 1001 1992 1 1001 1993 2 1001 1994 3 1001 1995 4 1001 1996 5 1002 2001 6 1002 2002 7 1002 2003 8 1003 1995 9 1003 1996 10 1003 1997 11 1003 1998 12 1003 1999 13 1003 2000 14 1003 2001 15 1003 2002 16 1003 2003 17 1004 2002 18 1004 2003 19   I would like to calculate the average for each year. The results I want is below.   Year Average 1992 1 1993 2 1994 3 1995 6.5 1996 7.5 1997 11 1998 12 1999 13 2000 14 2001 10.5 2002 13.66667 2003 14.66667   I can get the "want" table by using the program below. I just want to confirm that I use the right one.   proc sql; create table want as select Year, avg(value) as ave_value from have group by year; quit;   ... View more

Hi,   I have a dataset, which has three variables (FirmID, Year and Var1). I would like to delete the duplicate so that the same Var1 is only shown once within 3 years for each firm. What programs do I need to use? Thanks.   have   FirmID Year Var1 1001 1995 AA 1001 1995 AB 1001 1995 AC 1001 1995 AD 1001 1996 AA 1001 1996 CS 1001 1996 SW 1001 1997 AC 1001 1997 FD 1001 1998 OL 1001 1999 AD 1001 1999 SC 1001 1999 QW     want   FirmID Year Var1 1001 1995 AA 1001 1995 AB 1001 1995 AC 1001 1995 AD 1001 1996 CS 1001 1996 SW 1001 1997 FD 1001 1998 OL 1001 1999 AD 1001 1999 SC 1001 1999 QW   ... View more

Hello,   I have a dataset that lists the beginning year and end year of companies. The sample dataset is below   FirmID    Beginning              End 1001          1998                  2005 1002          1982                  2000   I would like to generate a panel data. The data is below.     FirmID      Year          age 1001        1998          1 1001        1999          2 ... 1001        2005          8 1002        1982          1 ... 1002        2000         19   What program do I need to use? Thanks. ... View more

Hi SAS master,    I have a dataset like below.   ID Year Var1 1 2001 3.5 1 2003 32.6 1 2005 0 1 2005 0 1 2005 5.6 1 2006 72.5 1 2010 0 1 2012 4.5 2 2004 0 2 2004 5 2 2007 42.31 2 2012 95.12 2 2012 86.4 2 2012 49.3 2 2015 0 2 2015 0   I would like to get the average for each firm in each year. The dataset I want is below.   ID Year Var1 1 2001 3.5 1 2003 32.6 1 2005 1.866667 1 2006 72.5 1 2010 0 1 2012 4.5 2 2004 2.5 2 2007 42.31 2 2012 76.94 2 2015 0   what program do I need to use? Thanks. ... View more