topic Re: merge parent information to multiple children in SAS Programming

merge parent information to multiple children

Cooksam13 — Fri, 06 May 2022 00:38:48 GMT

I have a data set that includes the mother and child information in one row - they are combined using their shared family ID, but what just realized that if there are multiple children with the same family ID only one match with the mother happens.

How do I duplicate the mother information to merge with the 2nd or 3rd etc. child information. and maintain one whole data set?

thank you

Re: merge parent information to multiple children

SASKiwi — Fri, 06 May 2022 01:05:29 GMT

We can't provide a solution to your problem until you provide some sample mother and child data and details of what you would like it changed to.

Re: merge parent information to multiple children

Reeza — Fri, 06 May 2022 01:49:42 GMT

How was the child and family information merged/combined? Sounds like something went wrong in that step, so that step should be fixed.

Can you show the code or logic used?

Or the data structure. Fake data is fine but ensure the output expected matches with the input shown, ie provide a reproducible example.

Re: merge parent information to multiple children

Cooksam13 — Fri, 06 May 2022 02:06:14 GMT

first I combined the demographics data with the screening data

DATA have;
MERGE screen
dem;
BY ID_Person;
RUN;

then separated the child and mother data

data adult;
set have;
if Adult = 'Adult' then output;
run;
data adult2;
set adult;
if CD_Gender = 'Female' then output;
run;

data child;
set have;
if child = 'Child' then output;
run;

then I did some editing to some other variables like adding "A_" before all the variables associated with "Adult" so that when I merged them it wouldn't overwrite it - except for the variable "ID_Family"

next I sort it by the ID_family that both of the data sets have

proc sort data = child2;
by ID_family;
run;

proc sort data = adult;
by ID_family;
run;

data want;
Merge child
adult;
by ID_family;
run;

Re: merge parent information to multiple children

Reeza — Fri, 06 May 2022 15:19:01 GMT

You'll need to show your actual code, but your code as shown references a data set called CHILD2 that isn't shown somewhere.
Check your log thoroughly for notes and such. Your general logic is correct, so it's a specific detail somewhere, either in the code or data that's wrong.

Re: merge parent information to multiple children

Cooksam13 — Fri, 06 May 2022 19:39:18 GMT

sorry that is wrong I meant to say just "child" I think it was a typo error that is the code i used i can't show the rename section as it is a HIPPA problem

Re: merge parent information to multiple children

Reeza — Mon, 09 May 2022 15:49:41 GMT

HIPAA doesn't apply to variable names, it applies to patient data and you can make fake data. Unfortunately with what you've shown I cannot assist any further.