Good morning Guys, I have a issue with One to many Merge statement. Should we follow a specific sequence to expect the correct output. Lets say the two datasets are as below and already in sorted by C1 variable and C1 is the only common variable between D1 & D2. (NOTE : Changed the data in datasets for better understanding) D1(C1, C2, C3 are D1 data variables) C1 C2 C3 1 A B D2(C1, C4, C5 are D2 data variables) C1 C4 C5 1 C D 1 E F when i do Merge D1(IN=A) D2(IN=B); BY C1; IF A AND B; OUTPUT IS LIKE : C1 C2 C3 C4 C5 1 A B C D 1 A B E F But when am swapping datasets like Merge D2(IN=A) D1(IN=B); BY C1; IF A AND B; OUTPUT IS LIKE : C1 C2 C3 C4 C5 1 A C ------> C3 AND C5 variables values on first observation or missing(printed as blanks) 1 A B E F Please note that the data am using is different what i've given above.
... View more