Interested to Buy Any Domain ? << Click Here >> for more details...
What are the joins,types of joins and thier functions?
- 7 Answers
- 13668 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
Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?
Do you need to know if there are any missing values?
What is the difference between class statement and by statement in proc means?
Mention the difference between ceil and floor functions in sas?
What is the purpose of _character_ and _numeric_?
What commands are used in the case of including or excluding any specific variables in the data set?
What is the function of Stop statement in a SAS Program?
What is the maximum length of the macro variable? : sas-macro
how do you test for missing values? : Sas programming
Mention few capabilities of sas framework.
Hi, If anyone has base SAS certification dumps, please share.
Difference between SAS STATA & SPSS?
How would you define the end of a macro? : sas-macro
what is the purpose of _error_? : Sas programming
Explain data step in SAS
