Interested to Buy Any Domain ? << Click Here >> for more details...
What are the joins,types of joins and thier functions?
- 7 Answers
- 13413 Views
- SAS, I also Faced
- E-Mail Answers
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
Differentiate between ceil and floor functions.
Compare sas with other data analytics tools.
what other sas products have you used and consider yourself proficient in using? : Sas programming
is data integration and etl programming is same? : Sas-di
it will become easy if uuu provide website linkssss and list of consultanciessssss
explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di
What are SAS/ACCESS and SAS/CONNECT?
How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?
Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?
What is the work of tranwrd function?
Difference between sum function and using “+” operator?
what versions of sas have you used (on which platforms)? : Sas programming
What do the mod and int function do? : Sas programming
what is the difference between unique key and primary key? : Sas-di
Define run-group processing?
