Interested to Buy Any Domain ? << Click Here >> for more details...
What are the joins,types of joins and thier functions?
- 7 Answers
- 13713 Views
- SAS, I also Faced
- E-Mail Answers
Answer Posted / mehul.v.thakkar@gmail.com
There are basically three types of joins in SAS,
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 ? | 4 Yes | 1 No |
Post New Answer View All Answers
What does the RUN statement do?
Intern stastical programmer written test
explain the concepts and capabilities of business object? : Sas-bi
describe the interaction table in sas di? : Sas-di
State the difference between INFORMAT and FORMAT ?
How would you invoke a macro? : sas-macro
what is the difference between nodup and nodupkey options? : Sas programming
explain the proc in sas? : Sas-administrator
what is sas metadata repository? : Sas-bi
what is scheduling and how will u implement it. In scheduling 5 jobs r running if there is an error occured at 3rd job and how will u check and waht necessary steps will u take not to repeat the same mistake
Do you need to know if there are any missing values?
Give some ways by which you can define the variables to produce the summary report (using proc report)?
what is sas and what are the functions? : Sas-administrator
Compare sas with other data analytics tools.
What is the maximum length of the macro variable? : sas-macro
