Hi For question 2 match merging is like full join . In that case we should compare full join using proc sql full join right? But why do we compare using select *from a,b. Correct me if I understood in wrong way.
Hi, You are right. Thanks for spoting this. Should use full join however in full join also first product will be Cartesian product and then query will be optimized as per the join condition.
Sir ur videos r very helpful
Glad to hear that.
Thank you sir
Great explanation
Sir thank you, your videos are very helpful and please keep on making videos.
Glad to know that you liked it.
Nice explation
Interview perspective very helpfull information... please upload some more videos 🙂
Thank you, I will keep uploading.
Nive video
Hi For question 2 match merging is like full join . In that case we should compare full join using proc sql full join right? But why do we compare using select *from a,b.
Correct me if I understood in wrong way.
Hi, You are right. Thanks for spoting this. Should use full join however in full join also first product will be Cartesian product and then query will be optimized as per the join condition.
👏🏼
Waiting for other videos on interview prospective