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 |
Can we use where and having clauses in a single SAS program. ex: proc sql; select a,b,c from test where state in 'KA' and having <some condition>. Is the above program run correctly, if not why ?
Approximately what date is represented by the SAS date value of 730?
What is SAS? is it a software just for use or we can creat something over there?
Mention common programming errors committed in sas ?
Explain the special input delimiters used in sas programming.
What is substr function?
What do the SAS log messages "numeric values have been converted to character" mean?
what is sas? is a package or tool? give me introduction about sas?
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??
Intern stastical programmer written test
DATA ABC; INPUT TDATE DATE9. AVG; CARDS; 18APR2008 150.00 19APR2008 167.00 20APR2008 123.00 21APR2008 145.00 ; RUN HOW CAN I FIND THE DIFFERENCE BETWEEN AVG OF 18APR2008 ANF 21APR2008?? IF ANY ONE GETS IT PLS TRY TO POST IT.
8 Answers Verinon Technology Solutions,
what is the use of catalog?