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
- 3722 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
Name types of category in which SAS Informats are placed?
what is snowflake schema? : Sas-di
What is the role of sas grid administrator? : sas-grid-administration
What do you understand by the term Normal Distribution?
Explain how you can debug and test your SAS program?
how to read the variables in sas? : Sas-administrator
Describe the function and untility of the most difficult SAS macro that you have written.
Mention what is PROC in SAS?
how do you pull data from equifax?tell me the process?
What is the work of tranwrd function?
Have you used macros? For what purpose you have used? : sas-macro
In proc transpose and data step with arrays which one you pick?
How would you invoke a macro? : sas-macro
For clinical entire study how many tables will create approx?
Approximately what date is represented by the SAS date value of 730?
