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?
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 data governance? : Sas-di
Do you need to know if there are any missing values?
what is OLAP?
Explain the difference between using drop = data set option in set and data statement?
Hi im new to sas. I have a file with some charecter variables and some numeric variables now i want to load charecter variables into one datastep and numeric variables into another data step pls let me know Thanks
how do you want missing values handled? : Sas programming
Which function is used to count the number of intervals between two sas dates?
What are the special input delimiters used in SAS?
What are types of transport files?
2 Answers PRA Health Sciences, Quintiles,
how to display duplicated observations in a data using base sas.
13 Answers HCL, TCS,
what is sas metadata repository? : Sas-bi
How do i read multiple spaces in datasets?