What are the joins,types of joins and thier functions?
Answer Posted / mehul thakkar
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 |
Post New Answer View All Answers
Name any two sas spawners? : sas-grid-administration
explain what is factor analysis? : Sas-administrator
explain the proc in sas? : Sas-administrator
Describe the ways in which you can create macro variables?
what is the primary data source for the wrs? : Sas-bi
What is the use of function Proc summary?
What is the difference between match merge and one to one merge?
Mention the category in which sas informats are placed?
how does sas handle missing values in a merge? : Sas programming
I have a dataset concat having a variable a b & c. How to rename a b to e & f?
What’s the difference between var b1 – b3 and var b1 — b3?
Are you involved in writing the inferential analysis plan? Tables specfications?
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
How to create an external dataset with sas code?
name several ways to achieve efficiency in your program? : Sas programming