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?



whenever we using the merging through data set merging ,we can get note in log like this "MERG..

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

Post New Answer

More SAS Interview Questions

What do you understand by the term Normal Distribution?

0 Answers  


What are types of transport files?

2 Answers   PRA Health Sciences, Quintiles,


What are the implications?

0 Answers   Quintiles,


what are the new features included in the new version of SAS i.e., SAS9.1.3?

5 Answers   College School Exams Tests, Wockhardt,


How does the internal authentication work in sas? : sas-grid-administration

0 Answers  


What are the difficulties u faced while doing vital signs table or dataset?

0 Answers  


what kind of variables are collected in AE dataset?

3 Answers   Accenture, Quintiles, SAS,


In the flow of DATA step processing, what is the first action in a typical DATA Step?

9 Answers  


my problem is to export my report to xsl.i can do that.but the problem is my report has 3 headings first heading should be printed with the merging of (1-5)cells and heading 2 should be of merge(2-4)cells?how to do this condition?

2 Answers   Dr Reddys, Oracle,


For what purposes have you used sas macros? : sas-macro

0 Answers  


How would you code the criteria to restrict the output to be produced?

9 Answers  


Can you execute a macro within a macro? Describe. : sas-macro

0 Answers  


Categories