Hello everyone. I have a dataset with certain variables for each firm. each firm has multiple year observations i.e. 1990, 1993, 1995,1998, 2000, 2002 and 2004. I want to create the missing values not only for the missing years between these years but also want to add 2005 to these years. the values of other variables for the years created using SAS needs to be the value of previous years. For example 1990 exists originally in the dataset so the missing years which i create i.e. 1991 and 1992 should have same observations as 1990. 1994 should have same observations as 1993. 1996 and 1997 should have same observations as 1995 and so on until 2005 where the observations should be same as 2004. If the firm observation ends before year 2004 lets say at year 2000, then still I would like to create the observations until 2005 where the variables will have values of 2000 in 2001 to 2005. I am providing tables for examples Have Year Cusip Index Dual class dummy 1990 XXXYY12 3 1 1993 XXXYY12 5 1 1995 XXXYY12 7 1 1998 XXXYY12 9 1 2000 XXXYY12 6 1 2002 XXXYY12 5 1 2004 XXXYY12 4 1 1993 ABCD220 2 0 1995 ABCD220 8 0 1998 ABCD220 6 0 2000 ABCD220 7 0 1995 DECO921 7 0 1998 DECO921 8 0 2000 DECO921 9 0 2002 DECO921 5 0 want Year Cusip Index Dual class dummy 1990 XXXYY12 3 1 1991 XXXYY12 3 1 1992 XXXYY12 3 1 1993 XXXYY12 5 1 1994 XXXYY12 5 1 1995 XXXYY12 7 1 1996 XXXYY12 7 1 1997 XXXYY12 7 1 1998 XXXYY12 9 1 1999 XXXYY12 9 1 2000 XXXYY12 6 1 2001 XXXYY12 6 1 2002 XXXYY12 5 1 2003 XXXYY12 5 1 2004 XXXYY12 4 1 2005 XXXYY12 4 1 1993 ABCD220 2 0 1994 ABCD220 2 0 1995 ABCD220 8 0 1996 ABCD220 8 0 1997 ABCD220 8 0 1998 ABCD220 6 0 1999 ABCD220 6 0 2000 ABCD220 6 0 2001 ABCD220 6 0 2002 ABCD220 6 0 2003 ABCD220 6 0 2004 ABCD220 6 0 2005 ABCD220 6 0 Thanking you in anticipation
... View more