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
- 3744 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 |
When looking for data contained in a character string of 150 bytes, which function is the best to locate that data: scan, index, or indexc?
How substr function works in sas?
what is the use of proc sql?
Have you ever linked SAS code, If so, describe the link and any required statements used to either process the code or the step itself?
Briefly explain input and put function?
How experienced are you with customized reporting and use of Data _Null_ features?
DATA ABC; INPUT TDATE DATE9. AVG; CARDS; 18APR2008 150.00 19APR2008 167.00 20APR2008 123.00 21APR2008 145.00 ; RUN HOW CAN I FIND THE DIFFERENCE BETWEEN AVG OF 18APR2008 ANF 21APR2008?? IF ANY ONE GETS IT PLS TRY TO POST IT.
8 Answers Verinon Technology Solutions,
what is sas and what are the functions? : Sas-administrator
why only we use SAS? their r many programmin language like SPSS, Oracle... Why SAS?
How to convert HTML file into SAS dataset?
How do you convert basic cube to transaction cube and transaction cube to basic cube?
When merging 2 datasets with a common variable (not merge key), how to keep both?
Teradata 
