Answer Posted / pricil kurian
Types of merges:-
1)one to one merge- It is the merge without any by variables
2)Match merges- Where we are using by variables.
Under match merge we have 1-1 , 1-many, and many-many
depending on the values in by variables.
For many-many merge proc sql will be relaiable.
Please correct me if I am wrong.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?
What does the trace option do?
how sas deals with business intelligence? : Sas-bi
If you were told to create many records from one record, show how you would do this using array and with proc transpose?
Can you suggest us materials for sdtm mapping?
What is the purpose of trailing @ and @@? How do you use them?
What is Linear Regression?
What system options would you use to help debug a macro? : sas-macro
how do you want missing values handled? : Sas programming
What would be the value of month at the end of data step execution and how many observations would be there?
what do you mean by data staging area? : Sas-di
What is the length assigned to the target variable by the scan function?
what is enterprise guide? What is the use of it? : Sas programming
explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di
What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro