Interested to Buy Any Domain ? << Click Here >> for more details...
What are the joins,types of joins and thier functions?
- 7 Answers
- 13883 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 |
if a program has some 1000 or more line and how to know whether the syntax of the particular code is correct without checking it manually
calculate the sum of value using only DATA STEP. data count_; input year name $ value; cards; 2006 xxx 10 2007 yyy 12 2006 xxx 20 2008 yyy 15 2007 xxx 15 ; out put should be like this year name T_value ----------------------- 2006 xxx 30 2007 xxx 15 2007 yyy 12 2008 xxx 15
Describe a time when you were really stuck on a problem and how you solved it?
Name few SAS functions?
Compare sas with other data analytics tools.
How would you invoke a macro? : sas-macro
What is the difference between a PROC step and a DATA step?
What is SAS informats?
How would you keep from overlaying the a SAS set with its sorted version?
What SAS statements would you code to read an external raw data file to a DATA step?
which date functions advances a date time or date/time value by a given interval? : Sas programming
Mention common programming errors committed in sas ?
Teradata 
