Interested to Buy Any Domain ? << Click Here >> for more details...
What are the joins,types of joins and thier functions?
- 7 Answers
- 13667 Views
- SAS, I also Faced
- E-Mail Answers
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 does P-value signify about the statistical data?
Give some ways by which you can define the variables to produce the summary report (using proc report)?
what is program data vector? : Sas-administrator
how does sas handle missing values in formats? : Sas programming
What is program data vector (pdv) and what are its functions?
What is by-group processing?
What does the RUN statement do?
what are the considerations when picking a SAS/STAT procedure?
Define run-group processing?
what is slowly changing dimension? : Sas-di
what are the best practices to process the large data sets in sas programming? : Sas-administrator
explain the function of substr in sas? : Sas-administrator
how many types prompting framework can be broken down to? : Sas-bi
How to create list output for cross-tabulations in proc freq?
name some data transformation used in sas di? : Sas-di
