Your appended data would be appropriate for statistics like Mean of a given variable assuming it has the same name. Use the family identifier as either a CLASS or By variable in Proc Means or Summary. Or you could use Proc Report with the family id as group variable requesting mean of analysis variables.
To bring other variables into the same record then Merge:
data merged;
merge sah.drcbw_sort sah.drcbm_sort;
by famcode;
run;
However you need to be careful about which of common named variables you want to keep as the second data set will overwrite common variables. Here is a brief example:
data work.ex1;
input famcode var1 var2;
datalines;
1 1 1
2 2 2
;
data work.ex2;
input famcode var1 var3;
datalines;
1 4 15
2 5 16
;
data work.merged;
merge work.ex1
work.ex2
;
by famcode;
run;
proc print data=work.merged;
run;
Note that the VAR! values in the merged data are from work.ex2.
So you may need to add drop options if you want to keep the VAR1 from work.ex1
data work.merged;
merge work.ex1
work.ex2 (drop=var1)
;
by famcode;
run;
or rename if you need both variables.
... View more