Home > Data Services > Catalog . Restricted Data . Census . ACS

Search Data Services

Meta Search
search across all the following databases:

Data Catalog
Data and documentation

KnowledgeBase
Common questions and answers.

Resources
Entire collection of data resources.


Latest Data News

RSS Feed icon

Sage Stats and CQ Political Stats Trial

Breaking News: Protect the 2020 Census

The Fastest Growing US Cities Are Mostly In the West

Another rule from NIH: Demographers might get to ignore this one

Research on Health Disparities: Incarceration Matters

Data Services Knowledge Base

Q:  

I am trying to merge a file with some restricted use items with the public use version of the data. I'm using stata. When I run the merge, I got a message saying "merge already defined."

Is this because some of the variable names are the same?

A:  

No. The message from stata says "_merge already defined."

_merge is an item that stata creates after a merge. It gives the user input on the outcome of the merge.

The possible values for _merge are:

1 - Observations from the master dataset that did not match observations from the using dataset
2 - Observations from the using dataset that did not match observations from the master dataset
3 - Observations from both datasets that did match

After looking at _merge you should either drop the item (drop _merge) or rename it (rename _merge merge1) as stata will not write over the existing _merge variable.

Annotated Resources:

Direct Links:

Related Question Groups: