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
- 3390 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 are SAS/ACCESS and SAS/CONNECT?
For what purpose(s) would use the RETURN statement?
I have a dataset concat having variable a b & c. How to rename a b to e & f?
Why and when do you use proc sql?
who is the best SAS clinical Trainer in Hyderabad?
What is SAS informats?
Differences between where and if statement?
what are scrubing procedures in SAS?
what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?
Can we create datasets by proc step ? (Proc contents, Means)?
What do the SAS log messages "numeric values have been converted to character" mean?
Does anybody has lastest SAS certification dumps,if anybody has please mail me at akshara_SAS@ymail.com Thanks Akshara
Teradata 
