Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the message 'Merge has one or more datasets with
repeats of by variables'.
- 5 Answers
- 20826 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vimal
If we are merging two datasets,
say,
a b
100 100
100
data x;
merge a b;
by id;
in this case, b has by variable repeated twice.
so the warning occurs.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / upendra
it meens that by variable uesd in merge has more than one
record for observation.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / pricil kurian
This message occur when we merge two datasets having the by
variables with more than one observation in both datasets.
In such scenarios we can't tell the result is true...We are
expecting really a carteisan product in such situation but
it is not the case..Inside the by values it will do a 1-1
merge only. So this note is very important. Use
nomergeby=error option in sas as a option so that we will
get this message as a error. This will avoid ignoring this
message. Use proc sql to merge the dataset such type
situation and proc sql will give a carteisan product. If u
are doing with datastep create unique variable and then
merge.
| Is This Answer Correct ? | 5 Yes | 3 No |
Answer / pari
merge,is performed under conditional criteria, thus we could
merge one or many datasets with repeats of a particular
variable using by statement.
| Is This Answer Correct ? | 1 Yes | 7 No |
Have you used macros? For what purpose you have used? : sas-macro
What are types of transport files?
2 Answers PRA Health Sciences, Quintiles,
If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable?
1.What is the difference between _NULL_ , _ALL_, and _N_? 2.What are the uses of _NULL_ using in Data Steps? Can we _NULL_ in Proc Steps also? 3.How do call the macro variable in Data Steps? 4.How to construct Pivot tables in Excel Using SAS?
Difference between sum function and using “+” operator?
What are the difference between the sas data step and sas procs?
If reading a variable length file with fixed input, how would you prevent SAS from reading the next record if the last variable didn?t have a value?
What are the different versions of sas that you have used until now? : sas-grid-administration
In which case u go for libname and in which case u go for proc sql pass thru facilit diff?
How do you download a flat file from Mainframe to your local PC using SAS?
what is the difference between unique key and primary key? : Sas-di
what is sas database server? : Sas-di
Teradata 
