Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3838 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 is the difference between nodupkey and nodup options?
what is transformation in sas data integration? : Sas-di
what versions of sas have you used (on which platforms)? : Sas programming
Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks
What is the sas data set? : sas-grid-administration
What are the default statistics that proc means produce?
what is sas database server? : Sas-di
explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di
Have you used macros? For what purpose you have used? : sas-macro
What is PDV?
Hi, If anyone has base SAS certification dumps, please share.
Explain why double trailing @@ is used in input statement?
How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?
what is sas application server? : Sas-di
Explain the purpose of substr functions in sas programming.
