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
- 3006 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 is washout period?
In the flow of DATA step processing, what is the first action in a typical DATA Step?
How would you identify a macro variable?
I have a dataset concat having variable a b & c. How to rename a b to e & f?
How do you debug and test your SAS programs?
Give e an example of..
How to get top scorer student from a class-table having different sections A,B, C & D? Each section having same number of students.
how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming
How do you control the number of observations and/or variables read or written?
what is chi-square test? have you used that?
1 Answers Accenture, Quintiles,
What are the implications?
What are the difficulties u faced while doing vital signs table or dataset?
Teradata 
