Interested to Buy Any Domain ? << Click Here >> for more details...
What are the joins,types of joins and thier functions?
- 7 Answers
- 13706 Views
- SAS, I also Faced
- E-Mail Answers
Answer Posted / mehul thakkar
There are basically three types of joins,
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 ? | 6 Yes | 7 No |
Post New Answer View All Answers
what is proc Index? and what is proc document?
What does the RUN statement do?
What are the data types that sas contain?
What are all the problems you faced while validating tables and reports?
State the difference between INFORMAT and FORMAT ?
what are 5 ways to perform a table lookup in sas? : Sas-administrator
What is a method to debug and test your SAS program?
What is the difference between nodupkey and nodup options?
What are common programming errors committed in sas
What is a pdv and what are its functions?
What is the difference between %local and %global? : sas-macro
How you can read the variables that you need?
How to test the debugging in sas?
What does P-value signify about the statistical data?
In sas admin differentiate between roles and capabilities? : sas-grid-administration
