Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • not enough memory for "merge"

    Dear community!

    I am trying two merge two files based on a facilityID which, however, is a unique identifer in the using dataset but not unique in the masterfile. I am thus using the merge m:1 command. While the masterset contains approximately 460'000 rows, the using file is a bit smaller (~180'000). Everytime I am trying to perform the m:1 merge I am receiving an error message saying that I am running low on Memory space and stata therefore cannot perform the match.

    Has someone else experienced something similar before? I have tried it with reclink as well but aborted the process after 30 minutes as there wasn't any visible progress.

    Thanks a lot in advance!

    Mascha
    Last edited by Mascha Mascha; 20 May 2019, 06:39.

  • #2
    I solved the Problem with the command "joinby". It obviously can handle larger data sets!

    Comment

    Working...
    X