How to merge datasets in Stata conditionally?

What is the most efficient and effective way to merge datasets in SAS?

  • Answer:

    It depends on the size of the 2 data sets big big: use sort/merge small small: use sql big small: use hash

Dirk Nachbar at Quora Visit the source

Was this solution helpful to you?

Other answers

Neha Shitut, Analytics Trainer , Jigsaw Academy Using merge statemnet is very efficient though you need to have a commonkey to merge the two datasets. Using proc sql is very simple and efficient too.

Neha Shitut

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.