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
- 3918 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 |
Describe a time when you were really stuck on a problem and how you solved it?
what is sas business intelligence? : Sas-bi
it will become easy if uuu provide website linkssss and list of consultanciessssss
What is the order of application for output data set options, input data set options and SAS statements?
Tell me more about the parameters in macro? : sas-macro
What do you feel about hardcoding?
For what purpose(s) would use the RETURN statement?
What is highest missing value for numeric?
What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?
how do u validate the program which u have written.
i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;
when we are using the PROC TRANSPOSE? OBSERVATIONS are repeated then what will happen and what it will show in log window.
Teradata 
