PROC SQL - 5 | Joins in SAS Using PROC SQL | Merging Data in SAS Using Join Method of PROC SQL 

Yes you can feel free to share that on learnerea.edu@gmail.com

There are multiple ways depending on your sitution - 1. you can check the number of records in both of the table and that will give you an idea 2. you can take frequency on name variable on both of the table and whichever has less number of missing values you can use that accordingl, if this doesn't help, please post your problem statement with an example, we will try to solve that

@@learnerea bonjour, merci pour votre réponse. Voila ce que je veux faire /* Full join on multiple tables with differents values of observations, and take all observations, but i dont know wich table countaines the max number of observations. */ Je ne sais pas si je me suis bien fait comprendre, j'essaye en français aussi: Faire un full join sur plusieurs tables qui on un nombre d'observations différents et garder toutes les observations en sortie, en sachant que je ne sais pas quelle table contient toutes les observations. Voilà j'ai essayé avec ifc ça marche bien quand on a que deux tables mais pour une jointure beaucoup de table je ne sais pas comment procéder

Thanks for watching. Not sure if I understood the question, however, as far as I observe we have tried to explain each of the joins in the similar fashion. Will be easy to assist if you put some example and time stamp where you see the doubt

Will do it soon

Glad it was helpful

Hi Prashant, There isn't any limit to learn anything... however this covers most of the activities which we generally perform on job.. All the best..

Yes, very soon we will start uploading the videos on macros

here is what you are looking for - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-i4hu1b9r_Qw.html

Hi Vishal, Thanks for following the channel. We have already made a video on the which we can watch using the below link: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-i4hu1b9r_Qw.html

Glad it helped

I'm glad you liked it