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
- 3338 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 |
Enlist the syntax rules followed in sas statements.
what is sas metadata server? : Sas-di
what are input dataset and output dataset options? : Sas programming
What is the purpose of the trailing and How would you use them?
How to merge the data using merge statement and proc format? Is the result is same ?
I am looking to buy a sas advance book. So any one can guide me that which one i should buy.
Under what circumstances would you code a SELECT construct instead of IF statements?
Does anybody has lastest SAS certification dumps,if anybody has please mail me at akshara_SAS@ymail.com Thanks Akshara
How would you remove a format that has been permanently associated with a variable? ________________
We want to merge file A and B. File A has variable age, file B provide birthdate. How to merge the data according to age in file B
What is PROC in SAS?
what has been your most common programming mistake? : Sas programming
Teradata 
