Explain the message ‘MERGE HAS ONE OR MORE DATASETS WITH
REPEATS OF BY VARIABLE’.

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different operating system platforms in which we can use sas? : sas-grid-administration

823


What is data _null_?

907


What is the difference between proportion and average?

3023


what is the use of sas management console? : Sas-di

825


Mention some common errors that are usually committed in sas programming.

822


What is the difference between %put and symbolgen? : sas-macro

937


Differentiate between sas functions and sas procedures.

881


If you were told to create many records from one record, show how you would do this using array and with proc transpose?

1172


what are the best practices to process the large data sets in sas programming? : Sas-administrator

802


what is the primary data source for the wrs? : Sas-bi

892


explain what is factor analysis? : Sas-administrator

850


How does proc sql work?

834


Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks

2016


how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5

1882


In sas, what are the areas that you are most interested in? : sas-grid-administration

851