whenever we using the merging through data set merging ,we can
get note in log like this "MERGE STATEMENT HAS MORE THAN ONE
ONE DATASET BY REPEATED BY VAIABLES" but the output has come
in good manner,whenever in in sql(full join) we can get
cartion product.so How do overcome this problem in sql?
- 1 Answers
- 3018 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / alok karan
if we have exactly same number of observation for each BY value in two data sets and we use merge statement to merge them then within log window we got message"MERGE STATEMENT HAS MORE THAN ONE
ONE DATASET BY REPEATED BY VAIABLES"
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the difference between the sas data step and sas procs?
Explain substr function?
how to generate the test data in sas without input data? : Sas-administrator
If you use a symput in a data step, when and where can you use the macro variable? : sas-macro
where to use sas business intelligence? : Sas-bi
how do you pull data from equifax?tell me the process?
For what purpose would you use the RETAIN statement?
What system options would you use to help debug a macro? : sas-macro
What is the work of tranwrd function?
Mention what is the difference between nodupkey and nodup options?
Mention the validation tools used in SAS?
how does sas handle missing values in a merge? : Sas programming
If you could design your ideal job, what would it look like?
What is the difference between %local and %global? : sas-macro
describe how to adjust the performance of data integrator? : Sas-di
