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 command is used to perform sorting in sas program?
where to use sas business intelligence? : Sas-bi
what are validation tools that are used in sas? : Sas-administrator
How does proc sql work?
What is the command used to find missing values?
what is factor analysis? : Sas-administrator
What are the limitations for memory allocation for SAS variables
What are the different types of sas functions?
Which statement does not perform automatic conversions in comparisons?
What is factor analysis?
What are the parameters of scan function?
what does the run statement do? : Sas programming
What is program data vector (pdv) and what are its functions?
Did you used proc test? when?
how could you generate test data with no input data? : Sas programming