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 do the pad and dim functions do? : Sas programming
i have one dataset data l; input name: $ 25; cards; manoj is a good boy to krishna krishna is a god boy to malli malli is good boy to ramana ques: here i want "manoj" observations nubers
How would you remove a format that has been permanently associated with a variables?
Which command is used to save logs in the external file?
Where do you use proc means over proc freq?
is data integration and etl programming is same? : Sas-di
How to convert HTML file into SAS dataset?
What is the use of stop statement?
what is sas and what are the functions? : Sas-administrator
What is the basic syntax of a sas program?
what are input dataset and output dataset options? : Sas programming
What sas features do you use to check errors and data validation?