Merge

Moderators: statman, Analyst Techy, andris, Fierce, GerineL, Smash

mac_csa
Posts: 5
Joined: Fri Jan 11, 2013 4:28 pm

Merge

Postby mac_csa » Fri Jan 11, 2013 4:37 pm

So, I need to merge 2 databases, in one I have the info about the mothers and in the other the info about the children.
I can't simple merge them, cause I get the "warning 5132", because there is more than one child for each mom.

I want to know how to properly merge the variables without the missing values for the children with the same mom.
Can someone help me?
JonPedersen
Posts: 118
Joined: Wed May 25, 2011 7:07 am
Contact:

Re: Merge

Postby JonPedersen » Sun Jan 13, 2013 9:58 am

Hi,
Assuming that you want one record for each child you have to match the two files (tables) with a match file command that specifies that the mother resides in a table and the children resides in a file.
That is something like:

Code: Select all

Match files /file='children.sav'
/table='mothers.sav'
/by MothersID.
hth
Jon
mac_csa
Posts: 5
Joined: Fri Jan 11, 2013 4:28 pm

Re: Merge

Postby mac_csa » Thu Jan 17, 2013 12:36 pm

Hi, thank you very much!
I got it

Who is online

Users browsing this forum: No registered users and 2 guests

cron