Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the message 'Merge has one or more datasets with
repeats of by variables'.
- 5 Answers
- 20984 Views
- I also Faced
- E-Mail Answers
Answer Posted / pricil kurian
This message occur when we merge two datasets having the by
variables with more than one observation in both datasets.
In such scenarios we can't tell the result is true...We are
expecting really a carteisan product in such situation but
it is not the case..Inside the by values it will do a 1-1
merge only. So this note is very important. Use
nomergeby=error option in sas as a option so that we will
get this message as a error. This will avoid ignoring this
message. Use proc sql to merge the dataset such type
situation and proc sql will give a carteisan product. If u
are doing with datastep create unique variable and then
merge.
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
What is the use of stop statement?
What do the put and input function do?
Give some examples where proc report’s defaults are same as proc print’s defaults?
What do you know about sas and what we do? : sas-grid-administration
What is the purpose of trailing @ and @@? How do you use them?
what is sas application server, database server, sas olap server and sas metadata server? : Sas-di
where are dashboard components are created and maintained? : Sas-bi
what is operational data and operational system? : Sas-di
what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming
What is the general format of function in sas? : sas-grid-administration
How do you specify the number of iterations and specific condition within a single do loop?
In ARRAY processing, what does the DIM function do?
I need level 2 to 5 sas using companies in india
What are the different types of sas functions?
name some data transformation used in sas di? : Sas-di
