What are the joins,types of joins and thier functions?
Answer Posted / kush
Joins are used to join the datasets horizontally.
There are 2 types of joins: inner and outer joins.Outer joins includes left,right and full join.
Inner Join gives the matching records which are present in both the datasets.
Left join gives all the records that are present in left
dataset and matching records in right dataset.
Right join gives all the records in the right dataset and matching records in left datasets
full join gives all matching and non matching records found in both the datasets.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to create list output for cross-tabulations in proc freq?
what is sas business intelligence? : Sas-bi
what are input dataset and output dataset options? : Sas programming
What is the maximum length of the macro variable?
how the sas basic syntax style described? : Sas-administrator
what do the pad and dim functions do? : Sas programming
what are the component of range? : Sas-bi
what do the sas log messages "numeric values have been converted to character" mean? What are the implications? : Sas programming
Explain append procedure?
Difference between nodup and nodupkey options?
How many data types are there in SAS?
Compare sas with other data analytics tools.
What is the difference between INPUT and INFILE ?
it will become easy if uuu provide website linkssss and list of consultanciessssss
What is the basic syntax of a sas program?