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 |
what are the differences between proc report and proc tabulate?
how do the in= variables improve the capability of a merge? : Sas programming
You need to create an In List that it is to be later used in a Where Clause that includes all the Regions that begin with the letter A from the sashelp.shoes table. Using PROC SQL with an into clause create the following string from the sashelp.shoes table using the variable region “AFRICA”,”ASIA”,…..
What is the work of tranwrd function?
i have a data set with 20 observations i want label from 8 to 15 observations ? how you create this one.
1.How many ways are there to create variables? 2.What is CLM,how can we use it? 3.what are the advontages of data step? 4.what is the extension of editor window in SAS 9.1.3? 5.How do you copy a particular data set from one library to another? 6.what is the use of double option? 7.Advontages of Proc Report? 8.what is the basic use of where statement? 9.How do you terminate the statments in SAS Programming? 10.What is the difference between symput and symget? 11.How would a identify the local and global variable? can any one answer for the 4'th question
how does sas handle missing values in assignment statements? : Sas programming
How would you combine 3 or more tables with different structures?
what are all the reports you generated in your recent project?
0 Answers Accenture, Quintiles,
what are input dataset and output dataset options? : Sas programming
If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?
Did you used proc lifetest? when?
2 Answers Accenture, Parexel, Quintiles,