Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3843 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 |
If i doest required Cumilative frequency in my table, generated by using PROC FREQ what i had to do?
diff between nodup rec and ondup key???
Why Info School? BUILD YOUR CAREER WITH RIGHT GUIDANCE AND SUPPORT
how does sas handle missing values in a merge? : Sas programming
What is LAG function?How is it used? can any one explain
3 Answers TRE, Verinon Technology Solutions,
Which function is used to count the number of intervals between two sas dates?
how to import HTML files into SAS datasets?
%STPbegin;%STPEND; ERROR: No logical assign for filename _WEBOUT. WARNING: No body file. HTML output will not be created. unable to fix it.plz help
What are the ways in which macro variables can be created in sas programming?
How many data types are there in SAS?
I have a dataset concat having a variable a b & c. How to rename a b to e & f?
How to limit decimal places for the variable using proc means?
Teradata 
