Link between 2 different database

[Ubos]

Hi friends,
I would like to know if it possible to relate two different databases that share one single variable.

For example VarX is present in database1 and database2, I need to use this key to compute some informations of database2 in database1.
Please consider that database1 and database2 have differents numbers of observations.

Thank you very much in advance.

Ubos

[PRogman]

If varX is unique in one of the databases you can use it as a look-up table. Sort the data on that variable and the use MATCH FILES to add variables to your current data. The you can do your computations.

If VarX does not identify a unique record in either database you need more information on how to identify which record to link to. It is important to have a 1:n relation. If you have n:n (many:many)  you are in trouble...
/PR

[David Marso]

"If you have n:n (many:many)  you are in trouble... "
Not necessarily.
Could flatten one or both tables using CasesToVars or other then let the devil sort the mess out later!

PRogman wrote

If varX is unique in one of the databases you can use it as a look-up table. Sort the data on that variable and the use MATCH FILES to add variables to your current data. The you can do your computations.

If VarX does not identify a unique record in either database you need more information on how to identify which record to link to. It is important to have a 1:n relation. If you have n:n (many:many)  you are in trouble...
/PR

[Ubos]

Hello to all,
thank you very much indeed to informations.
I did not solved the problem to relate two databases that share a variable but with different numbers of observations using SPSS.
I solved the problem by using a data manager in which it is possible to create a relation between data.
Thanks a lot.