I have a simple merging question that should be an easy answer, but I can not figure it out. Here is the data. Thanks.
Dataset1
ID Var1
1 Yes
2
3 No
Dataset2
1
2 Yes
3
data dataset3;
merge dataset1 (in=a) dataset2 (in=b);
by ID;
if a;
run;
Dataset3
Why does ID = 2 not have "Yes" replace the blanks in Var1 for both records?
Thanks.
Because only one record with a YES was provided from the second dataset. So on the second observation for ID=2 only dataset1 is contributing a value.
Many to One merges like this only work when the non-key variables do not overlap.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Submit your idea!
ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.
Find more tutorials on the SAS Users YouTube channel.