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
- 10197 Views
- I also Faced
- E-Mail Answers
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
What is the basic structure of the SAS base program?
what are the new features included in the new version of sas i.e., Sas 9.1.3? : Sas programming
Explain the difference between informat and format with an example.
Name any two sas spawners? : sas-grid-administration
Explain how you can debug and test your SAS program?
Why and when do you use proc sql?
How many ways to overcome a missing values???
Explain data_null_?
Name types of category in which SAS Informats are placed?
What was the last computer book you purchased? Why?
What is the use of %include statement?
What do the sas log messages “numeric values have been converted to character” mean? What are the implications?
I have a SCD Type 2 Dimention for Location In which A Sales Office in Having two Surrogate Keys just because of the change in it's Sales Group. SKey SalesGroup Sales Office BeginDate EndDate 280 SG1 SO1 01APR2000 01APR2010 281 SG2 SO1 02APR2010 31MAR2999 Now while loading the Fact, the Lookup ir returning SKey 280 for records before and after 01APR2010. I am not able to give WHERE condition in the Lookup Properties (TranDate between BeginDate and EndDate). Please help.
Mention how to limit decimal places for the variable using proc means?
How do you test for missing values?
