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
- 3743 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 slibref?
What do the PUT and INPUT functions do?
Explain by-group processing?
how sas deals with business intelligence? : Sas-bi
What versions of SAS have you used (on which platforms)?
How can sas program be validated?
how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming
What are the special input delimiters used in SAS?
How sas treats the dsd delimiters?
Explain the purpose of substr functions in sas programming.
What are the table names in oracle database...?
what is sas metadata server? : Sas-di
Mention few capabilities of sas framework.
What is the maximum and minimum length of macro variable
What is the use of stop statement?
