Interested to Buy Any Domain ? << Click Here >> for more details...
What are the joins,types of joins and thier functions?
- 7 Answers
- 13693 Views
- SAS, I also Faced
- E-Mail Answers
Answer Posted / kush
Joins are used to join the datasets horizontally.
There are 2 types of joins: inner and outer joins.Outer joins includes left,right and full join.
Inner Join gives the matching records which are present in both the datasets.
Left join gives all the records that are present in left
dataset and matching records in right dataset.
Right join gives all the records in the right dataset and matching records in left datasets
full join gives all matching and non matching records found in both the datasets.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain data step in SAS
Do you need to rearrange the order of the data for the report?
What are the special input delimiters used in SAS?
what are some differences between proc summary and proc means? : Sas programming
hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?
why is sas considered self-documenting? : Sas programming
How do you define proc in sas? : sas-grid-administration
What is SAS? What are the functions does it performs?
WHAT IS SAS WEB SERVICE and what are the steps to create an xml service ?
What is connection profile? : sas-grid-administration
what is sas metadata server? : Sas-di
Enlist the functions performed by sas.
for what purpose would you use the retain statement? : Sas programming
Explain the use of proc gplot? : sas-grid-administration
What is the use of divide function?
