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
- 3825 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 |
data study; input Subj : $3. Group : $1. Dose : $4. Weight : $8. Subgroup; x= input(Weight,5.1); datalines; 001 A Low 220 2 002 A High 90 1 003 B Low 193.6 1 004 B High 165 2 005 A Low 123.4 1 ; Why does X get truncated? X shows up as 22 instead of 220,9 instead of 90 and 19.8 instead of 198? This problem doesnt happen with the values 193.6 and 123.4. This does not happen if x is read on the 5. informat instead of the 5.1 informat
what are sas bi dashboard components? : Sas-bi
what does the run statement do? : Sas programming
explain the use of % includes a statement in sas? : Sas-administrator
what is the use of proc contents and proc print in sas? : Sas-administrator
what is enterprise guide? What is the use of it? : Sas programming
Name statements that function at both compile and execution time?
What is instream data in SAS?
how does sas handle missing values in an update? : Sas programming
How can you limit the variables written to output dataset in data step?
what is the use of sas management console? : Sas-di
What are the best sas programming practices for handling very large datasets? : sas-grid-administration
Teradata 
