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 Posted / 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 |
Post New Answer View All Answers
What is the difference between SAS functions and procedures?
Explain the difference between nodup and nodupkey options?
What are the different operating system platforms in which we can use sas? : sas-grid-administration
Can you suggest us materials for sdtm mapping?
What is the difference between proportion and average?
This entry was posted in General. Bookmark the permalink. Post a comment or leave
What does PROC print, and PROC contents do?
How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?
how does sas handle missing values in procs? : Sas programming
What is the basic structure of a sas program?
Difference between nodup and nodupkey options?
what is transformation in sas data integration? : Sas-di
Mention what are the data types does SAS contain?
explain the proc in sas? : Sas-administrator
What is the order of application for output data set options, input data set options and SAS statements?