This video does a beautiful job in explaining what the merge statement does. What I was looking for, however, was a detailed explanation of how SAS does it. In other words, how does the PDV change at each step of the merging process. Do you have any video that covers this specific topic? Thanks in advance.
Thank you so much for the wonderful video. I have one question. Supposing I want to merge Cust1 and Cust 2. In Table - Cust1, some observations have multiple transactions e.g. Ann has different 5 different transaction amounts. I want to link Cust1 (with duplicates) to information in cust2. How do I go about this? Thanks
assuming cust1 has five entries for "ann" and in cust2 you have just one entry for the same contact... if so.. this should absolutely work.. you just try it and let us know if you are getting any error... or not the desired output.. just put your code here.. we will investigate.. alternatively you can also share with us at learnerea.edu@gmail.com
Hi Learnerea As always, fantastic contents and easy to comprehend One thing, what if the common Variable is using different variable name ? for example "contactname" on table A and "name" on Table B?
Hi. Your videos are very informative. Please make video on merging three or more datasets in work library that are imported from multiple sheets of one excel file which all datasets in work library that your are going to merge have no common variables or common column...
Please check out the series of MERGING Tables, we have covered everything that you need, first one you can watch, using below link - th-cam.com/video/D8ftgdPdx8E/w-d-xo.html
in set repeated values may be present in output if present in a input table but in merge repeated values are not present...( may be this answer is right) if wrong please correct it....
Hii Bro Don't stop your videos with basic ones.Go ahead and pick some complex problems identify solutions and present over to us.All the best bro And Explain datastep merge concepts when and where we have to use multiple variables in by statement. And how datastep merging better or inferior than proc sql join?
Great, now please make a tutorial on how to effortlessly just mute barking noises… cus i dont know what you did there but that dog just went silent all of a sudden
Incredibly helpful, thank you!
Greetings from San Diego, CA. Thank you for your videos!
Glad you liked it !!!
Clear and helpful. Thank you!
Glad it was helpful!
This video does a beautiful job in explaining what the merge statement does. What I was looking for, however, was a detailed explanation of how SAS does it. In other words, how does the PDV change at each step of the merging process. Do you have any video that covers this specific topic? Thanks in advance.
Great video! Thank you so much!
Glad you liked it
Fantastic !
Many thanks!
Great Video, Thank you so much .
Glad it was helpful!
Thank you my friend. Brilliant job 👌👌
Thank you! Cheers!
Thank you so much for the wonderful video. I have one question. Supposing I want to merge Cust1 and Cust 2. In Table - Cust1, some observations have multiple transactions e.g. Ann has different 5 different transaction amounts. I want to link Cust1 (with duplicates) to information in cust2. How do I go about this? Thanks
assuming cust1 has five entries for "ann" and in cust2 you have just one entry for the same contact... if so.. this should absolutely work.. you just try it and let us know if you are getting any error... or not the desired output..
just put your code here.. we will investigate.. alternatively you can also share with us at learnerea.edu@gmail.com
Hi Sir when we merge two or more DS then for common variable SAS generate value 1, is it possible to see those value ?
Hi Learnerea
As always, fantastic contents and easy to comprehend
One thing, what if the common Variable is using different variable name ? for example "contactname" on table A and "name" on Table B?
Either rename and make it same before merging (you can do that while sorting before merge) or you can use proc sql
Thanks for sharing 👍
Glad it was helpful
Thank you!
Hi. Your videos are very informative. Please make video on merging three or more datasets in work library that are imported from multiple sheets of one excel file which all datasets in work library that your are going to merge have no common variables or common column...
When the data are not relative, why would you like to combine(merge or append) them together?
Very helpful thanks a lot
Glad you liked it
Thank you so much sir..
Most welcome
Amazing, can i merge more than 2 tables? I need to get like 5 tables, they all have the same 'PRIMARY KEY'
Yes you can
👏🏻👏🏻👏🏻thank you
Hi sir
Can you compare set and merging
Tht will be helpful
Thank you
Please check out the series of MERGING Tables, we have covered everything that you need, first one you can watch, using below link -
th-cam.com/video/D8ftgdPdx8E/w-d-xo.html
in set repeated values may be present in output if present in a input table but in merge repeated values are not present...( may be this answer is right) if wrong please correct it....
Thanks. I learned new item today
If a=1 and b=0 what will be the output?
not sure if this explains the question correctly
@@learnerea assigning 1 and 0 , does this mean we need to consider only the columns of 1st table as it says a=1
Hii Bro Don't stop your videos with basic ones.Go ahead and pick some complex problems identify solutions and present over to us.All the best bro
And Explain datastep merge concepts when and where we have to use multiple variables in by statement.
And how datastep merging better or inferior than proc sql join?
definitely, we will do that as soon as the beginner series is completed
Your Merging Tables series is crucial incorrect sytax could lead to wrong presentations and visuals.
Great, now please make a tutorial on how to effortlessly just mute barking noises… cus i dont know what you did there but that dog just went silent all of a sudden
That's acknowledged.. will try to have that removed in the upcoming videos
@@learnerea it was a joke that you where able to silence him right away. I’m only kidding it was not a big deal.