Explain the message ‘MERGE HAS ONE OR MORE DATASETS WITH
REPEATS OF BY VARIABLE’.
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 business intelligence? : Sas-bi
Describe the ways in which you can create a macro variable?
What is the difference Using & and && in the macro variables
I am having a stored process.it needs to route my report to both hthml and Xls.By default SP routes to html.I used the PRINTTO to route the html to Xls.BUt it createsthe file not but no content was written to file(0KB)?how can i do it?
What are the rows present in protocol Violation table?
2 Answers Accenture, Quintiles,
How to select the observations randomly from a SAS dataset
HOW DO WE CREATE A SAS STORED PROCESS IN SAS EG ?
Describe how you would pass data to macro.
How do I CREATE an external dataset with sas code? I would like to create within a sascode a non-exsistent textfile on the host. So I am not forced to create the file befor filling it.
What versions of SAS have you used (on which platforms)?
If you were told to create many records from one record show how you would do this using arrays and with PROC TRANSPOSE?
Describe a time when you were really stuck on a problem and how you solved it?