Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What are the joins,types of joins and thier functions?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the prime responsibilities of data integration administrator? : Sas-di

1063


List out some key concept of SAS

1119


What are the automatic variables for macro? : sas-macro

1244


what is the use of proc sql? : Sas programming

1131


Do you need to know if there are any missing values?

1036


Tell e how how dealt with..

2222


What is program data vector (pdv)?

1284


How can I remove header from output data set?

2617


Describe 5 ways to do a “table lookup” in SAS?

1148


Are you involved in writing the inferential analysis plan? Tables specfications?

2564


What is the function of Stop statement in a SAS Program?

1148


How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro

1038


What does P-value signify about the statistical data?

1355


hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana

5444


What is the SAS data set?

1129