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
- 3821 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 |
What are the default statistics that proc means produce?
In a shcool there are 1000 students. After completion of every test in 6 subjects , each subject teacher submit the marks of every student at different times and loaded in the database commonly. How will you seperate the top two subject marks for each each studet using SAS?
Could you please answers for this. 1.Code the tables statement for a single-level (most common) frequency. 2.Code the tables statement to produce a multi-level frequency.
What is the one statement to set the criteria of data that can be coded in any step?
what is the primary variable in your study?
What is the difference between %local and %global? : sas-macro
How many ways to overcome a missing values???
why is sas considered self-documenting? : Sas programming
what are 5 ways to perform a table lookup in sas? : Sas-administrator
What happens in the following code, if u type 8 instead of *? proc sql noprint; create table abc as select 8 from lib.abc; quit;
Give e an example of..
What is the length assigned to the target variable by the scan function?
Teradata 
