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
- 3842 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 you were told to create many records from one record show how you would do this using arrays and with PROC TRANSPOSE?
How do you add a number to a macro variable?
what is data governance? : Sas-di
Mention what are the data types does SAS contain?
How do dates work in SAS data?
List down the reasons for choosing sas over other data analytics tools.
Describe a time when you were really stuck on a problem and how you solved it?
what is study design in while working with SAS? what are screening variables in SAS?
Differences between where and if statement?
Do you need to combine data sets? How should you combine data sets– MERGE or SET statements in DATA steps,PROC APPEND,PROC SQL?
Did you used proc lifetest? when?
2 Answers Accenture, Parexel, Quintiles,
Have you ever linked SAS code, If so, describe the link and any required statements used to either process the code or the step itself?
Teradata 
