Interested to Buy Any Domain ? << Click Here >> for more details...
What are the joins,types of joins and thier functions?
- 7 Answers
- 13707 Views
- SAS, I also Faced
- E-Mail Answers
Answer Posted / rus
There are three types of joins:
1. Cartesian Join
2. Inner Join
3. Outer Join
Cartesian Join gives the records for all the combinations
of both the datasets
Inner Join gives only the matching records from both the
datasets
outer join is of three types:
Left Join
Right Join
Self Join
Left Join gives both matched and unmatched records from the
left table/dataset
Right join gives both matched and unmatched records from
the right table/dataset
self join gives matching or unmatched records from the same
table based on the condition
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
how do the in= variables improve the capability of a merge? : Sas programming
Explain the purpose of retain statement.
State the difference between INFORMAT and FORMAT ?
Difference between informat and format?
Hi all, If Anybody has Advance SAS Certification dumps??? Please share with me. Email: pramod.kalugade03@gmail.com
Name types of category in which SAS Informats are placed?
what is the limit of the number of the rows and columns available in the worksheet? : Sas-bi
Difference between sum function and using “+” operator?
what is data governance? : Sas-di
Explain what is SAS informats?
explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di
how do you test for missing values? : Sas programming
explain what is data set in sas? : Sas-administrator
What are the limitations for memory allocation for SAS variables
What are the advantages of using sas?
