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

how does sas handle missing values in formats? : Sas programming

1190


i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;

2554


what is sas metadata repository? : Sas-bi

1172


what is the difference between floor and ceil functions in sas? : Sas-administrator

1314


Describe crosslist option in tables statement?

1264


Give an example where SAS fails to convert character value to numeric value automatically?

1135


What are the data types in sas?

1112


Explain the main difference between the sas procedures and functions? : Sas-administrator

1113


what is the purpose of _error_? : Sas programming

1188


what is the primary data source for the wrs? : Sas-bi

1333


sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately

3632


Hi Jeevan/Akshara I have tried to contact SASI Vats for latest Advanced SAS Programming Certification Dumps (A00-212) but have not got any response. I would highly and gratefully appreciate your assistance in this regard. If you guys have access to this, would you be kind enough to forward it to me ? I would abide by all the terms you have for this. Please, note my email id: upretigopi@yahoo.com Preti Sharma

3552


what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming

1311


What Proc glm does?

1138


Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager

2129