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
Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?
What is the difference between order and group variable in proc report?
Explain how merging helps to combine data sets.
Describe what are the different levels of administrative users in sas? : sas-grid-administration
what are validation tools that are used in sas? : Sas-administrator
What is maximum number of rows and cols can be handled in SAS?
If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?
How do dates work in sas?
What is the basic syntax of a sas program?
Differentiate between ceil and floor functions.
What are the applications primarily used by business analyst? : Sas-bi
What do the SAS log messages "numeric values have been converted to character" mean?
Explain the difference between informat and format with an example.
What is the difference between match merge and one to one merge?
why a stop statement is needed for the point= option on a set statement?