what is the difference between SET and MERGE?
Answer Posted / pratik
Set statments are used to copy the data from existing
database to new database.
where merge is used to join two dataset and both should
have common varaible and same number of observation.
IN mearging we have two type one is
Vertically-we have three process concate,interleaving and
append.
in concate and interleaving we use set option.
Horazentally-we use Merge option.
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?
Hi,by usining ptf how we have to combine (likr merge)10 datasets at a time in the oracle database(and write a macro code also)?Like this i have a douts a lot if you dont mind may please send one text mail for me(madhusudhanap16@gmail.com)?
what is business intelligence? : Sas-bi
how can you create zero observation dataset? : Sas programming
What are the differences between sum function and using “+” operator?
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
Give some ways by which you can define the variables to produce the summary report (using proc report)?
Explain what Proc glm does?
what is sas application server, database server, sas olap server and sas metadata server? : Sas-di
how to do user inputs and command line arguments in sas?
How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro
For what purposes have you used sas macros? : sas-macro
which date functions advances a date time or date/time value by a given interval? : Sas programming
How we can call macros with in data step? : sas-macro
in the flow of data step processing, what is the first action in a typical data step? : Sas programming