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 makes sas stand out to be the best over other data analytics tools?
what is program data vector? : Sas-administrator
Why Info School? BUILD YOUR CAREER WITH RIGHT GUIDANCE AND SUPPORT SAS Training in Data Management at InfoSchool Bangalore
CHOOSE ANY ONE OF THE PROCEDURE FOLLOWING TO GENERATE THE REPORTS? HOW CAN YOU SAY IT IS BETTER THAN THE OTHER? AND DEFERENCIATE THESE TWO ? 1). REPORT PROCEDURE 2). TABULATE PROCEDURE
how can you improve the performance of a query, If it is excuting very slowly?
Mention what is SAS data set?
How can you create a macro variable with in data step? : sas-macro
firstobs and obs are working only option wise,but we are using infile statement with firstobs and obs in a statement wise? so firstobs,obs working at options and statemnts or not?
how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming
Diff between proc sql merge and join?
what is incremental update ? is this possible in SAS OLAP CUBE STUDIO.
Briefly explain input and put function?