Analysera lite data

We have: - 1 "main Stata list with key figures from all firms" in Sweden (including listed firms). Firms are named after its id; the variable “orgnr”. Observations are on multiple years for each orgnr, totaling 5.7 million observations. - 1 "Stata list with listed firms" in Sweden. Firms are named after its id; the variable “orgnr”. - 1 "Stata list with listed firms in Sweden with bonds". We want: - 1 "main Stata list with key figures from listed firms" in Sweden. We also want a dummyvariable (name it “bonds”) for the listed firms with bonds (1 for bonds; 2 for no bonds).