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?
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 is slowly changing dimension? : Sas-di
what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming
Tell e how how dealt with..
What do you understand by the term Normal Distribution?
Are you sensitive to code walk-throughs peer review or QC review?
What does the RUN statement do?
What are the ways to do a “table lookup” in sas?
Have you ever used the SAS Debugger?
how are numeric and character missing values represented internally? : Sas programming
What is run-group processing?
describe about physical data integration? : Sas-di
What was the last computer book you purchased? Why?
Tell me about % include and % eval? : sas-macro
Hi Jeevan/Akshara I have tried to contact SASI Vats for latest Advanced SAS Programming Certification Dumps (A00-212) but have not got any response. I would highly and gratefully appreciate your assistance in this regard. If you guys have access to this, would you be kind enough to forward it to me ? I would abide by all the terms you have for this. Please, note my email id: upretigopi@yahoo.com Preti Sharma
Explain bmdp procedure?