I have two files, each with 3 variables.

The first one has date, city, and score. The second one has date, city and ret. Each has 49 cities.

I want to split each files to 49 stata files, by city.

Then merge the 49 score files with the 49 ret files by city and date.

Then merge each of the 49 files with a fulldate file (only one variable date with all the 365/366 dates per year).

merge 1:1 date using fulldate



Then for the 49 files, each

replace city="cityname" if missing(city)


Then append all the 49 files to one file.

Anyone can help?

Great thanks!