Interested to Buy Any Domain ? << Click Here >> for more details...
What are the joins,types of joins and thier functions?
- 7 Answers
- 13884 Views
- SAS, I also Faced
- E-Mail Answers
Answer Posted / rus
There are three types of joins:
1. Cartesian Join
2. Inner Join
3. Outer Join
Cartesian Join gives the records for all the combinations
of both the datasets
Inner Join gives only the matching records from both the
datasets
outer join is of three types:
Left Join
Right Join
Self Join
Left Join gives both matched and unmatched records from the
left table/dataset
Right join gives both matched and unmatched records from
the right table/dataset
self join gives matching or unmatched records from the same
table based on the condition
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming
What is the function of Stop statement in a SAS Program?
How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?
What are the data types that sas contain?
Name few SAS functions?
what is PhaseIII, ODS, TLG, Macro and Proc in SAS
what is the purpose of _error_? : Sas programming
what is the difference between unique key and primary key? : Sas-di
How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?
describe how to adjust the performance of data integrator? : Sas-di
what are the categories that sas informats are used to the place the data? : Sas-administrator
What does PROC print, and PROC contents do?
what do the sas log messages "numeric values have been converted to character" mean? : Sas programming
What do the mod and int function do? : Sas programming
I have a SCD Type 2 Dimention for Location In which A Sales Office in Having two Surrogate Keys just because of the change in it's Sales Group. SKey SalesGroup Sales Office BeginDate EndDate 280 SG1 SO1 01APR2000 01APR2010 281 SG2 SO1 02APR2010 31MAR2999 Now while loading the Fact, the Lookup ir returning SKey 280 for records before and after 01APR2010. I am not able to give WHERE condition in the Lookup Properties (TranDate between BeginDate and EndDate). Please help.
