1. Categories >> Software >> Data Warehouse >> SAS
  2. Suggest New Category

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?

Question Posted / durgachandragiri


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

how can you put a "trace" in your program? : Sas programming

0 Answers  

Approximately what date is represented by the SAS date value of 730?

0 Answers  

What is SAS?

0 Answers  

what are input dataset and output dataset options?

6 Answers   HCL,

When you will use nowd option in report???

6 Answers   Accenture,




wt is a-z and a--z?

3 Answers   Accenture,

how do u test a pros sql(works or not) without executing it?

1 Answers   DELL, HSBC,

how to generate the test data in sas without input data? : Sas-administrator

0 Answers  

Have you been involved in editing the data or writing data queries?

1 Answers   BioServe, Oracle, Sasken,

What is the purpose of trailing @ and @@? How do you use them?

0 Answers  

what is p-value

3 Answers   Accenture, Quintiles, Sristek,

what is data integration? : Sas-di

0 Answers  

For more SAS Interview Questions Click Here
Categories