Help with using the gvkey-cik linking table

[Bernice Mi]

Dear Statalists,
I am trying to find out the historical ciks for companies (identifier: gvkey). I have downloaded the gvkey-cik linking table but found it very difficult to use, as gvkey has a date range and cik has another date range (please see a screenshot of a data sample). For example, gvkey 1002 has a date range between 1968 and 1972 whereas its cik 1306124 is between 2004 and 2005. Please does anyone know how to create a date column, gvkey column, and cik column so I can easily use it in my further analysis? I.e., the data I want would look like below:

fyear	gvkey	cik
1968	1002	.
1969	1002	.
1970	1002	.
1971	1002	.
1972	1002	.
1973	.	.
1974	.	.
1975	.	.
1976	.	.
1977	.	.
1978	.	.
up until 2003	.	.
2004	.	1306124
2005	.	1306124

I have tried different methods for many days but with no luck. Any advice or help is greatly appreciated!!!
Bernice

[Bernice Mi]

Hi All,
I have figured out a solution. Please disregard my post. Thank you though.
Bernice

[Clyde Schechter]

It would be appreciated if you would close the thread by sharing your solution so that others who encounter a similar problem will be able to learn from you. Statalist is, after all, a community for learning from each other.