whenever we using the merging through data set merging ,we can get note in log

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

1 Answers
3750 Views
Accenture, I also Faced
E-Mail Answers

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

1.What is the difference between _NULL_ , _ALL_, and _N_? 2.What are the uses of _NULL_ using in Data Steps? Can we _NULL_ in Proc Steps also? 3.How do call the macro variable in Data Steps? 4.How to construct Pivot tables in Excel Using SAS?

3 Answers

how to import HTML files into SAS datasets?

3 Answers HP,

Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager

0 Answers

how the sas basic syntax style described? : Sas-administrator

0 Answers

Enlist the functions performed by sas.

0 Answers

what is intially documentation for a sas programmer?

2 Answers Accenture,

The Lion King is hosting an animal conference. All the animals in the world attend except one. Which animal does not attend?

6 Answers Oracle,

What is a method to debug and test your SAS program?

0 Answers

Which is the best place to learn SAS clinicals and Oracle clinical in hyderabad?