combining data

U

usmanecon

Guest
#1
Dear All
I have these three type of data set format that i want to combine in Stata. But neither one of the command in merging gives me a correct number of observation after merging. Moreover, I want also to merge these three data set combine with another data set which has fipstate and fipscty and other variables and i really cannot get the right answer. I am falling back on you guys and hope to get hep on code which will allow us to do that. This is very important for my success and any help would be appreciated. I have tried all week but unsuccessful. Please help

YEAR fipstate fipscty naics payroll YEAR fipstate fipscty naics payroll
2008 1 1 4244 0 2008 1 1 4451 0
2008 1 3 4244 0 2008 1 3 4451 0
2008 1 5 4244 0 2008 1 5 4451 0
2008 1 9 4244 0 2008 1 9 4451 0
2008 1 11 4244 0 2008 1 11 4451 0

YEAR fipstate fipscty naics payroll
2008 1 1 4245 0
2008 1 3 4245 0
2008 1 5 4245 0
2008 1 9 4245 0
2008 1 11 4245 0

We have try the m: m command which is bad and doe snot work. 1:m or m:1 and 1:1 also do not work. Please a genius around
 
Last edited by a moderator: