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 prime responsibilities of data integration administrator? : Sas-di
List out some key concept of SAS
What are the automatic variables for macro? : sas-macro
what is the use of proc sql? : Sas programming
Do you need to know if there are any missing values?
Tell e how how dealt with..
What is program data vector (pdv)?
How can I remove header from output data set?
Describe 5 ways to do a “table lookup” in SAS?
Are you involved in writing the inferential analysis plan? Tables specfications?
What is the function of Stop statement in a SAS Program?
How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro
What does P-value signify about the statistical data?
hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana
What is the SAS data set?