how many types of MERGE?
Answers were Sorted based on User's Feedback
Answer / chandu
Till now, i had used 2 types of Merges...
1 More than 2 datasets having same BY variable...
eg : Adding summary statistics to the Dataset.
2 More than 2 datasets doesnt having same BY variables...
eg : adding totals to the dataset.
| Is This Answer Correct ? | 0 Yes | 3 No |
Answer / no need
hey ashok kore if u know the right answer then post
otherwise keep quiet(noru musuko) uselessfellow
| Is This Answer Correct ? | 1 Yes | 4 No |
Answer / kishore kumar
There r four types of merges r there...
match Merge , one to many merge , many to one merge and
many to many merge
| Is This Answer Correct ? | 2 Yes | 7 No |
Answer / j.surendhar
This the Answer u search for - Types of MERGE
1.One to One reading.
2.Concatenating.
3.Interleaving.
4.Mach Merge.
I'll give the Explanation also, If u need.
| Is This Answer Correct ? | 3 Yes | 8 No |
Answer / siri
7 types
concatenation
interleving
one to one merge
one to many merge
many to one merge
many to many merge
| Is This Answer Correct ? | 1 Yes | 6 No |
Answer / name is no need
arai uselessfelow why are you dropping these type of
answers.how can a person knows how many types of merges are
there?
please don't drop the wrong answers.
| Is This Answer Correct ? | 1 Yes | 6 No |
Answer / ashok kore
There is 3 types of merge,
1.Equiv Join : Merge the datasets with Only matching
observations.
2.Non Equiv Join : Merge the datasets with not,greater and
less matching observations.
3.Outer Join : Merge the datasets with insufficient
observations.
| Is This Answer Correct ? | 2 Yes | 10 No |
how will you location sas platform applications available from web browser? : Sas-bi
What is the difference between class statement and by statement in proc means?
Which statement does not perform automatic conversions in comparisons?
Why Info School? BUILD YOUR CAREER WITH RIGHT GUIDANCE AND SUPPORT SAS Training in Data Management at InfoSchool Bangalore
explain about data integrator metadata reports? : Sas-di
what is null hypothesis? why do you consider that?
0 Answers Accenture, Quintiles,
How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data set to a second data set, and the non-matches of the right-most data set to a third data set.
How do I CREATE an external dataset with sas code? I would like to create within a sascode a non-exsistent textfile on the host. So I am not forced to create the file befor filling it.
What is interleaving in SAS?
how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?
Which date functions advances a date time or date/time value by agiven interval?
How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?