Interested to Buy Any Domain ? << Click Here >> for more details...
What are the joins,types of joins and thier functions?
- 7 Answers
- 13399 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 are the uses of sas?
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 does the run statement do? : Sas programming
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
Will it bother you if the guy at the next desk times the frequency and duration of your bathroom or coffee breaks on the grounds that ?you are getting paid twice as much as he is??
why a stop statement is needed for the point= option on a set statement?
What function CATX syntax does?
what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming
For clinical entire study how many tables will create approx?
what is data governance? : Sas-di
what other sas products have you used and consider yourself proficient in using? : Sas programming
what is sas application server? : Sas-di
What are the differences between sum function and using “+” operator?
what is the use of sas management console? : Sas-di
it will become easy if uuu provide website linkssss and list of consultanciessssss
