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
- 2986 Views
- Accenture, I also Faced
- E-Mail Answers
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 |
What is the purpose of the trailing @? The @@? How would you use them?
how to remove the duplicates by proc sql?
name some data transformation used in sas di? : Sas-di
How to limit decimal places for the variable using proc means?
Why is a STOP statement needed for the point=option on a SET statement?
Name few SAS functions?
The below code we are using for creating more than one macro variables in proc sql using into clause. How we can use same code to create macro variables vara, varb, varc instead of var1, var2, var3.? proc sql noprint; select count(distinct(patient)) into :var1 - :var3 from dataset1 group by trtreg1c ; quit;
name several ways to achieve efficiency in your program? : Sas programming
how to remove duplicates using proc sql?
For what purposes have you used sas macros? : sas-macro
What type of tables you are using in YOUR reporting..???
2 Answers GSK GlaxoSmithKline,
Difference between sum function and using “+” operator?
Teradata 
