Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the message ‘MERGE HAS ONE OR MORE DATASETS WITH
REPEATS OF BY VARIABLE’.
- 2 Answers
- 10200 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / siri
This is the note obtained in log while performing many-to-
many merge refering the situation of having duplicate
values for key variables in both input files simultaneously.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / christeena
this happens in many to many merge..if we do not have a key
variable to identify that which observation from one data
set to be matched with which observation in the other data
set, a note will appear in the log as 'merge with repeat
set of by values'..So to get rid of this note find a unique
key variable so that observations from the data sets can be
correctly matched..
| Is This Answer Correct ? | 4 Yes | 1 No |
what is slowly changing dimension? : Sas-di
what is transformation in sas data integration? : Sas-di
What is the order of application for output data set options, input data set options and SAS statements?
how would you create multiple observations from a single observation? : Sas programming
how to do user inputs and command line arguments in sas?
Where do the database management systems store data and how do u import them.
what type of reports you are generating in your company...???
2 Answers GSK GlaxoSmithKline,
what is the difference between proc means and proc summary?
What are the automatic variables for macro? : sas-macro
How does the internal authentication work in sas? : sas-grid-administration
Approximately what date is represented by the SAS date value of 730?
There is a field containing a date. It needs to be displayed in the format “ddmonyy” if it’s before 1975,”dd mon ccyy” if it’s after 1985, and as ‘disco years’ if its between 1975 and 1985. How would you accomplish this in data step code? Using only PROC FORMAT.
Teradata 
