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
what are sas/access and sas/connect? : Sas programming
What do the SAS log messages "numeric values have been converted to character" mean?
How do you specify the number of iterations and specific condition within a single do loop?
explain what is factor analysis? : Sas-administrator
where are dashboard components are created and maintained? : Sas-bi
Give e an example of..
What do the mod and int function do? : Sas programming
What are the functions which are used for character handling functions?
What is PDV?
What are the new features included in the new version of SAS Programming Language?
Describe crosslist option in tables statement?
What are the special input delimiters used in SAS?
Which statement does not perform automatic conversions in comparisons?
Hi Jeevan/Akshara I have tried to contact SASI Vats for latest Advanced SAS Programming Certification Dumps (A00-212) but have not got any response. I would highly and gratefully appreciate your assistance in this regard. If you guys have access to this, would you be kind enough to forward it to me ? I would abide by all the terms you have for this. Please, note my email id: upretigopi@yahoo.com Preti Sharma
Differentiate between proc means and proc summary.