what is the difference between SET and MERGE?
- 19 Answers
- 66413 Views
- CitiGroup, I also Faced
- E-Mail Answers
Answer Posted / swetha
We use merge when we have information abouth the topic in
two or more datasets. So that by merging we get the
complete information about the topic in one dataset.It is
combining the data horizontally.
But we use set, when the datasets are mutually exclusive.
i.e. information in dataset A in not depending the
information in dataset B.It is combining the data
vertically.
| Is This Answer Correct ? | 24 Yes | 0 No |
Post New Answer View All Answers
What is program data vector (pdv)?
What is the command used to find missing values?
Are you sensitive to code walk-throughs peer review or QC review?
what techniques and/or procs do you use for tables? : Sas programming
Intern stastical programmer written test
Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?
How you can read the variables that you need?
What do the sas log messages “numeric values have been converted to character” mean? What are the implications?
Give some examples where proc report’s defaults are same as proc print’s defaults?
What is connection profile? : sas-grid-administration
Differentiate between format and informat? : sas-grid-administration
How substr function works in sas?
What is the maximum and minimum length of macro variable
Describe the ways in which you can create a macro variable?
what is information maps?
