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
- 3422 Views
- Accenture, I also Faced
- E-Mail Answers
Answer / 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 |
What do you understand by the term Normal Distribution?
What are types of transport files?
2 Answers PRA Health Sciences, Quintiles,
What are the implications?
what are the new features included in the new version of SAS i.e., SAS9.1.3?
5 Answers College School Exams Tests, Wockhardt,
How does the internal authentication work in sas? : sas-grid-administration
What are the difficulties u faced while doing vital signs table or dataset?
what kind of variables are collected in AE dataset?
3 Answers Accenture, Quintiles, SAS,
In the flow of DATA step processing, what is the first action in a typical DATA Step?
my problem is to export my report to xsl.i can do that.but the problem is my report has 3 headings first heading should be printed with the merging of (1-5)cells and heading 2 should be of merge(2-4)cells?how to do this condition?
For what purposes have you used sas macros? : sas-macro
How would you code the criteria to restrict the output to be produced?
Can you execute a macro within a macro? Describe. : sas-macro
Teradata 
