topic Re: combining tables in SAS Procedures

combining tables

tjonas — Fri, 27 May 2011 15:57:24 GMT

I tried to merge three tables using the code below but in the new table the values are missing.

data momdadbirth (drop=partype year);
merge street (in=b)
father
mother;

by SFN;
if b;
run;

Re: combining tables

SPR — Fri, 27 May 2011 16:24:12 GMT

Please, give samples of these datasets: father, mother, street.
SPR

Re: combining tables

tjonas — Fri, 27 May 2011 17:22:00 GMT

all 3 tables have the same file numbers as a column. The country of birth is different on the mothers/fathers table for some file numbers as they have been updated. I need to use these updated records to update the other table but still keep the countries for the records that have not been updated.

Re: combining tables

tjonas — Fri, 27 May 2011 17:36:53 GMT

Re: combining tables

SPR — Fri, 27 May 2011 18:03:03 GMT

I guess that field CFN contains "file numbers" and is common to all three tables. However, it is necessary to know other lields that contribute to this merge. So, I need samples of your data as well as output that you would like to get.

If it is sensitive information you could replace it with some fake data like
CFN Name Surname State
100 John Smith Arizona etc.

SPR Message was edited by: SPR

Re: combining tables

ballardw — Fri, 27 May 2011 18:09:23 GMT

For variables with the same name, as may be the case with country of birth, the values from the first dataset with that variable are all you'll see. You'll need to use the RENAME= to get all of the variables if that is what is happening with your data.