Hi Everyone,

I'm trying to merge about a dozen different lists that use the same ID scheme but are missing different subsets of entries. The data is by the year and I want every year in one .dta file. How can I import by ID or reformat columns so that I get a data set with the same ID list and just missing values by the year?

Here is a small sample of the data:
Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input long(unitid v2 v3 v4 v5 v6 v7 v8)
100654  6106 100654  6001 100690   597 100654  5628
100663 21923 100663 20902 100724  5318 100663 18333
100706  9736 100690   675 100751 37663 100690   627
100724  4413 100706  9101 100760  1769 100706  7866
100751 38390 100724  4760 100830  4878 100724  5383
100760  1681 100751 38563 100858 28290 100751 37098
100812  3044 100760  1835 101028  1528 100760  1787
100830  5211 100812  3114 101143  1755 100812  3041
100858 30440 100830  4894 101161  4781 100830  4919
100937  1268 100858 29776 101189  3319 100858 27287
end

You can see in the unitid columns some of the same ID values. I want to line up data by ID and fill in missing values with the empty condition '.'


Thank you