What are the joins,types of joins and thier functions?
Answer Posted / sree
There are two types of joins
1.Inner joins
2.Outer joins
The outer join is of 3 kinds
- Right join
- Left join
- Full join
Inner join have following characteristics
-return only matching rows
allow max of 32 tables to be joined at the same time
Outer joins--can retrive nonmatching as well as matching
rows.
--outer joins are limited to two tables at a time.
Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
Give an example where SAS fails to convert character value to numeric value automatically?
Give some examples where proc report’s defaults are different than proc print’s defaults?
Hi,by usining ptf how we have to combine (likr merge)10 datasets at a time in the oracle database(and write a macro code also)?Like this i have a douts a lot if you dont mind may please send one text mail for me(madhusudhanap16@gmail.com)?
If a variable contains only numbers, can it be a character data type?
What is the difference between nodupkey and nodup options?
what are the new features included in the new version of sas i.e., Sas 9.1.3? : Sas programming
Difference between SAS STATA & SPSS?
how would you determine the number of missing or nonmissing values in computations? : Sas programming
What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?
how do you test for missing values? : Sas programming
Why double trailing @@ is used in input statement?
What is SAS? What are the functions does it performs?
How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro
How can you limit the variables written to output dataset in data step?
Hi, If anyone has base SAS certification dumps, please share.