Explain the message ‘MERGE HAS ONE OR MORE DATASETS WITH REPEATS OF BY V

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

Question Posted / guest

2 Answers
10076 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

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

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

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

Post New Answer

More SAS Interview Questions

Given an unsorted data set, how to read the last observation to a new data set?

0 Answers

what are different analysis datasets you created and what are the new variables created

2 Answers Sciformix,

how can you code the confidence intervals?

6 Answers Cytel, IIT, Ranbaxy,

Describe the types of SAS programming tasks that you performed like Tables? Listings? Graphics? Ad hoc reports? Other?

4 Answers HP, Oracle,

what are validation tools that are used in sas? : Sas-administrator

0 Answers

what are 5 ways to perform a table lookup in sas? : Sas-administrator

0 Answers

What do you know about sas data set?

0 Answers

What will calendar procedure do?

0 Answers

in data set200 observation how to take 110,150,170 using sql procedure?

7 Answers Accenture,

sas implimented companies in hyderabad

11 Answers CTS, HSBC,

data data1; input dt account; format dt date9.; cards; 1745 1230 1756 1120 1788 1130 1767 1240 ; data data2; input startdt enddt total; format startdt date9. enddt date9.; cards; 1657 1834 12300 1557 1758 16800 1789 1789 12300 1788 1345 12383 1899 1899 13250 ; proc sql; create table data3 as select * from data1 as x left join data2 as y on x.dt>=y.startdt and x.dt<=y.enddt; quit; Here, we are getting cartision product. But,I want left join report consisting of this program. It should not get duplicate values. you can modify the program also.

0 Answers

How to create an external dataset with sas code?

0 Answers

For more SAS Interview Questions Click Here