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
why is sas data integration studio important? : Sas-di
what versions of sas have you used (on which platforms)? : Sas programming
Intern stastical programmer written test
Tell me about % include and % eval? : sas-macro
Do you need to rearrange the order of the data for the report?
what is intially documentation in sas?
What are the default statistics for means procedure?
Did you used proc test? when?
Give e an example of..
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?
in the flow of data step processing, what is the first action in a typical data step? : Sas programming
What is interleaving in SAS?
what is scheduling and how will u implement it. In scheduling 5 jobs r running if there is an error occured at 3rd job and how will u check and waht necessary steps will u take not to repeat the same mistake
Which function is used to count the number of intervals between two sas dates?
which date function advances a date, time or datetime value by a given interval? : Sas programming