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 900 rows, the using file is much larger (~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