@Deepak_More wrote:   The codes worked well in creating the missing years and the range from 1990 to 2005. However the values of the variables except Cusip could not be created as previous observations and instead they were blank for every observation in the new variable created. But because the years are created by Cusip, I think I might be able to fill the missing values by the previous observation by some other codes. I don't know what this means, please show us. In any event, please provide the data in the requested format. ... View more