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
- 20773 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 are the difference between sas functions and procedures?
State the difference between INFORMAT and FORMAT ?
explain what is data set in sas? : Sas-administrator
what do you mean by data staging area? : Sas-di
how will you location sas platform applications available from web browser? : Sas-bi
What is the use of PROC gplot?
How are numeric and character missing values represented internally?
What are the best sas programming practices for handling very large datasets? : sas-grid-administration
Mention common programming errors committed in sas ?
What would be the value of month at the end of data step execution and how many observations would be there?
what is the primary data source for the wrs? : Sas-bi
How do you control the number of observations and/or variables read or written?
How do you connect the desktop application to metadata server? : sas-grid-administration
how many types prompting framework can be broken down to? : Sas-bi
How do you define proc in sas? : sas-grid-administration
