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
which features do you use to check the data validations and errors? : Sas-administrator
What is substr function?
What is a pdv and what are its functions?
how do you debug and test your sas programs? : Sas programming
what is data access? : Sas-di
for what purpose would you use the retain statement? : Sas programming
what is broad cast agent? : Sas-bi
explain the proc in sas? : Sas-administrator
What are the difference between ceil and floor functions in sas?
How do you convert basic cube to transaction cube and transaction cube to basic cube?
how can you put a "trace" in your program? : Sas programming
In sas, what are the areas that you are most interested in? : sas-grid-administration
describe the interaction table in sas di? : Sas-di
How do you debug and test your SAS programs?
What is the difference between SAS functions and procedures?