What are the joins,types of joins and thier functions?
Answer Posted / mehul.v.thakkar@gmail.com
There are basically three types of joins in SAS,
1. Inner Join
2. Left Join
3. Right Join
Inner Join gives the records which are present in both the
datasets.
Left join gives all the records that are present in left
dataset irrespective of whether they have a matching record
in the right dataset.
Right join gives all the records in the right dataset
irrespective of whether they have a matching record in the
left dataset.
Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What are the default statistics that proc means produce?
Hi Jeevan/Akshara I have tried to contact SASI Vats for latest Advanced SAS Programming Certification Dumps (A00-212) but have not got any response. I would highly and gratefully appreciate your assistance in this regard. If you guys have access to this, would you be kind enough to forward it to me ? I would abide by all the terms you have for this. Please, note my email id: upretigopi@yahoo.com Preti Sharma
How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro
is data integration and etl programming is same? : Sas-di
WHAT IS SAS WEB SERVICE and what are the steps to create an xml service ?
How long can a macro variable be? A token? : sas-macro
what is the difference between unique key and primary key? : Sas-di
How would you identify a macro variable?
why is sas data integration studio important? : Sas-di
how can you put a "trace" in your program? : Sas programming
What is PDV?
How sas treats the dsd delimiters?
I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com
What are the ways to do a “table lookup” in sas?
where are dashboard components are created and maintained? : Sas-bi