Interested to Buy Any Domain ? << Click Here >> for more details...
What are the joins,types of joins and thier functions?
- 7 Answers
- 13498 Views
- SAS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sree
There are two types of joins
1.Inner joins
2.Outer joins
The outer join is of 3 kinds
- Right join
- Left join
- Full join
Inner join have following characteristics
-return only matching rows
allow max of 32 tables to be joined at the same time
Outer joins--can retrive nonmatching as well as matching
rows.
--outer joins are limited to two tables at a time.
| Is This Answer Correct ? | 10 Yes | 1 No |
Answer / 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 |
Answer / 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 |
Answer / shwetha
1.simple join:-to report matching data from various tables
2.inner join:- to report data.Conditional clause implemented
by on clause.For inner & outer join.
3.outer join:- left join:-to report data from the left side
table & matching data from right side table,right
join:-report overall data from right side& matching data
from the left side table,full join:- report overall data
from both tables & matching.
union join:- adding & combining.
self join:-the table join with same table
natural join:- report matching data from the variable tables
without using conditions.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / saifudheen
inner join...outer join...its used in open sql statements
to retrieve data from database..
| Is This Answer Correct ? | 5 Yes | 5 No |
There are basically three types of joins,
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 ? | 6 Yes | 7 No |
Answer / 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 |
How do you put a giraffe into the refrigerator?
What are the 3 components in sas programming?
how do you validate sas program?
i have a dataset with 25 obs; 10th obs has like ramu,anji,ramu,azad,ramu like this. i want to know how many times the word repeats in that obs?
why is a stop statement needed for the point=option on a set statement? : Sas programming
What are the rows present in protocol Violation table?
2 Answers Accenture, Quintiles,
What are some problems you might encounter in processing missing values? In Data steps? Arithmetic? Comparisons? Functions? Classifying data?
what is the SAS/ACCESS and SAS/CONNECT?
9 Answers Accenture, iFlex, TCS,
If reading an external file to produce an external file, what is the shortcut to write that record without coding every single variable on the record?
what are the three main credit bureau names
1 Answers Synchrony Financial,
What are the limitations for memory allocation for SAS variables
what r the job openings SAS for fresher graduates !
Teradata 
