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
How do you control the number of observations and/or variables read or written? Approximately what date is represented by the SAS date value of 730?
for report generation which one you used proc report or data_null_?
How to limit decimal places for variable using proc means?
how sas deals with business intelligence? : Sas-bi
What is the basic structure of the SAS base program?
Mention few capabilities of sas framework.
Give some examples where proc report’s defaults are same as proc print’s defaults?
What is PROC in SAS?
Are you involved in writing the inferential analysis plan? Tables specfications?
it will become easy if uuu provide website linkssss and list of consultanciessssss
how could you generate test data with no input data? : Sas programming
Explain the difference between using drop = data set option in set and data statement?
What is maximum storage capability of SAS?
hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?
What is the difference between input and infile statement?