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
- 3372 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
For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration
AE datasets names? how many types?
How can sas program be validated?
how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5
What is the difference between the proc sql and data step?
What are symget and symput? : sas-macro
what is the difference between infile and input? : Sas-administrator
explain about data integrator metadata reports? : Sas-di
What is the maximum length of the macro variable?
what is the Population you used in your project, is it ITT or PP?
What is the order of application for output data set options, input data set options and SAS statements?
What are the prime responsibilities of data integration administrator? : Sas-di
what are validation tools that are used in sas? : Sas-administrator
what do the sas log messages "numeric values have been converted to character" mean? : Sas programming
What is the basic syntax style in SAS?
