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
What is your favorite all time computer book? Why?
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
How to test the debugging in sas?
what is the use of sas management console? : Sas-di
Have you used macros? For what purpose you have used? : sas-macro
I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com
Mention sas system options to debug sas macros.
What is the maximum length of the macro variable?
how many display types available in sas bi dashboard? : Sas-bi
Describe the ways in which you can create macro variables?
In proc transpose and data step with arrays which one you pick?
How do you test for missing values?
Tell me more about the parameters in macro? : sas-macro
for whom is sas data integration studio designed? : Sas-di
How do you convert basic cube to transaction cube and transaction cube to basic cube?
