match tables

[Theofanis Nikolopoulos]

Hello everybody

I am trying to merge 2 tables using the command merge 1:1 or 1:m or m:1 or m:n, but the same problem arizes:

(pathsplit() in lmatabase, compiled by Stata 16.1, is too new to be run by this version
of Stata and so was ignored)
fullfilename(): 3499 pathsplit() not found
<istmt>: - function returned error


I do not know another way how to merge just 2 small tables and it is crucial

[Leonardo Guizzetti]

Welcome to the Statalist. Your question is not clear enough to answer, at least not without guessing. Please help us to help you, and review the FAQ on how to ask questions.

You are trying to merge "tables", but it seems as though you have multiple datasets (i.e., pre-summarized data stored as a dataset). You also mention using -merge- as well as compiled mata libraries, and it's not clear how these are relevant. Please show us exactly the code that you ran, and the output that Stata gave you. Please paste that into a post using the CODE delimiters. It would also help to show us a reproducible data example that we can work with so we know we are speaking the same language.

[Theofanis Nikolopoulos]

Hello again. I write the following commands :

use hotel, clear
list
describe

use finan, clear

list
describe

list

merge 1:1 taxid using hotel
merge m:1 taxid using hotel
merge 1:m taxid using hotel
merge m:m taxid using hotel


The answer I take follows :


do "C:\Users\FANHS\AppData\Local\Temp\STD1940_000000. tmp"

. merge 1:1 taxid using hotel
(pathsplit() in lmatabase, compiled by Stata 16.1, is too new to be run by this
version of Stata and so was ignored)
fullfilename(): 3499 pathsplit() not found
<istmt>: - function returned error
r(3499);

end of do-file

r(3499);

. do "C:\Users\FANHS\AppData\Local\Temp\STD1940_000000. tmp"

. merge 1:1 taxid using hotel
(pathsplit() in lmatabase, compiled by Stata 16.1, is too new to be run by this
version of Stata and so was ignored)
fullfilename(): 3499 pathsplit() not found
<istmt>: - function returned error
r(3499);

end of do-file

r(3499);

. do "C:\Users\FANHS\AppData\Local\Temp\STD1940_000000. tmp"

. merge m:1 taxid using hotel
(pathsplit() in lmatabase, compiled by Stata 16.1, is too new to be run by this
version of Stata and so was ignored)
fullfilename(): 3499 pathsplit() not found
<istmt>: - function returned error
r(3499);

end of do-file

r(3499);

. do "C:\Users\FANHS\AppData\Local\Temp\STD1940_000000. tmp"

. merge 1:m taxid using hotel
(pathsplit() in lmatabase, compiled by Stata 16.1, is too new to be run by this
version of Stata and so was ignored)
fullfilename(): 3499 pathsplit() not found
<istmt>: - function returned error
r(3499);

end of do-file

r(3499);

. do "C:\Users\FANHS\AppData\Local\Temp\STD1940_000000. tmp"

. merge m:m taxid using hotel
(pathsplit() in lmatabase, compiled by Stata 16.1, is too new to be run by this
version of Stata and so was ignored)
fullfilename(): 3499 pathsplit() not found
<istmt>: - function returned error
r(3499);

end of do-file

r(3499);

[Leonardo Guizzetti]

There are two issues here.

1) Applying -merge- without understanding what it does and attempting to brute-force some result is unlikely to be productive.

2) The mata error is bizarre. I wonder if your installation hasn't been corrupted in some way? Perhaps we can put this aside for now.

Please show us the output of:

dataex finan
dataex hotel

[William Lisowski]

I'm going to hazard a guess that the error message is an indication that your Stata installation is damaged in some way. I'm guessing the merge command uses some Mata functions as part of its work, and that is where the error message arises.

Somehow your installation of Stata - apparently something before Stata 16 - has gotten some newer Mata functions mixed into its libraries.

Or somehow you accidentally replaced a newer version of the Stata executable with an older version.

Or somehow there are two copies of the stata executable on your system. I can imagine an old version of Stata not deleted before upgrading might still be launched when you start Stata by double-clicking on a do-file or datatset, and then trying to use libraries from the newer installation of Stata. So do check your whole system for multiple copies of stata.

One thing to check is to run the version command before your first merge command. Since your Mata libraries are Version 16.1 I'd expect that version to be reported, but your error message suggests an older version may be reported.