Hi i have question, if we dont know wich table is full (left or right) of all names, and we went have final table with all names, then what is the solution
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
Hi Vishal, Thanks for following the channel. We have already made a video on the which we can watch using the below link: ua-cam.com/video/i4hu1b9r_Qw/v-deo.html
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
Bro /sir , are this PROC SQLS are enough for getting job, Or else still to learn more PROC SQLS , i have seen ur full PROC SQL video , im ur subscriber too , pls.
You did a good justice to this topic you are a star
Glad it was helpful
you are unique talented ,distributing knowledge great... dont let money come into mind
Explaination was very clear
I'm glad you liked it
Well explained! Thank you
Glad it helped
perfect！very clear！
Kindly do videos on SAS visualisation and modelling in SAS
Will do it soon
Hi i have question, if we dont know wich table is full (left or right) of all names, and we went have final table with all names, then what is the solution
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
I am having problem in right join and left join with two of my dataset. is there anyway I can share the dataset and clarify my doubts?
Yes you can feel free to share that on learnerea.edu@gmail.com
sir please upload videos on macros
here is what you are looking for -
ua-cam.com/video/i4hu1b9r_Qw/v-deo.html
Nice videos! Can you also teach advanced macro ? thanksss!!!
Yes, very soon we will start uploading the videos on macros
Nice explain.....
Upload macro video plz...
Hi Vishal,
Thanks for following the channel. We have already made a video on the which we can watch using the below link:
ua-cam.com/video/i4hu1b9r_Qw/v-deo.html
How to transpose a dataset without using proc transpose example sashelp.class dataset . plz help me with syntax
After the left join you stopped showing side by side merge vs sql:(
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
Bro /sir , are this PROC SQLS are enough for getting job,
Or else still to learn more PROC SQLS , i have seen ur full PROC SQL video , im ur subscriber too , pls.
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..
you have done a mistake on right join as Student_name does not appear on target table after right joining. You did not change the sequence of a and b
The speaker did not apparently know that the "on" word was required to join SAS tables? He seemed surprised when he got the error in his SAS code.