I am looking at data on recycling and compost rates and have merged this data with recycling and waste collection methods. When I merge the data does not match for one quarter in 2016 (my data is from 2012-2016) specifically for the 'other' method of waste collection. The rates have merged for all other methods and time periods, is there a reason why they wouldn't merge for the 'other' collection method? I have attached screenshots below, as you can see the rate has matched for all other methods for example in 'Adur' it is only for 'compost' 'other'. The rate data only has the variables name code year quarter and rate.
Thank You in Advance
Related Posts with Merge not matching for one year for a specific variable unrelated to the merge
Generating dummy variables based on variables with multiple categoriesHi, I have a (panel) dataset that contains the following variables for each observation: person_id …
Merge One Variable to Multiple Instances in Master DatasetHello, I have a dataset in which multiple organizations can serve the same county. I have a crosswa…
Constraints with fmmI have a pretty basic mixture regression thus: . fmm 2: regress y x1 x2, lcprob(x1) What I would l…
Compressed and Out of Position Graph After Coefplot and grc1legHi, I have used the coefplot command to plot coefficients from a series of event study regressions …
Weighted median and range with svy dataHi all, I'm hoping this is an easy response but I can't seem to find an answer to it. I'm working w…
Subscribe to:
Post Comments (Atom)
0 Response to Merge not matching for one year for a specific variable unrelated to the merge
Post a Comment