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
- 3822 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to specify variables to be processed by the freq procedure?
Mention sas system options to debug sas macros.
what is change analysis in sas di ? : Sas-di
what is the one statement to set the criteria of data that can be coded in any step? : Sas programming
how many types prompting framework can be broken down to? : Sas-bi
what is proc Index? and what is proc document?
what type of graphs we will create(for 2+years candidates)?
how to change the execute of macro
What are the special input delimiters used in SAS?
Which date function advances a date, time or datetime value by a given interval?
where are dashboard components are created and maintained? : Sas-bi
what are some good sas programming practices for processing very large data sets? : Sas programming
How do dates work in sas?
What are the different servers in sas? : sas-grid-administration
How do you test for missing values?
