Explain the message ‘MERGE HAS ONE OR MORE DATASETS WITH
REPEATS OF BY VARIABLE’.
Answers were Sorted based on User's Feedback
Answer / siri
This is the note obtained in log while performing many-to-
many merge refering the situation of having duplicate
values for key variables in both input files simultaneously.
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / christeena
this happens in many to many merge..if we do not have a key
variable to identify that which observation from one data
set to be matched with which observation in the other data
set, a note will appear in the log as 'merge with repeat
set of by values'..So to get rid of this note find a unique
key variable so that observations from the data sets can be
correctly matched..
Is This Answer Correct ? | 4 Yes | 1 No |
What is the purpose of the trailing @? The @@? How would you use them?
1.we can execute a macro with in a macro,by using call symput and symget can any one give me one example? 2.We can create the macro variables by using %let,%do,macro parameters,INTO clause in proc sql and call symput, can any one give me example to create macro variable with INTO clause and call symput? 3.
what is the use of proc sql?
code the tables statement for a single level frequency?
What is SAS?
what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming
I have a dataset with variables empid and doj how to calculate retirement age?
What statement do you code to tell SAS that it is to write to an external file? What statement do you code to write the record to the file?
how can you improve the performance of a query, If it is excuting very slowly?
my problem is to export my report to xsl.i can do that.but the problem is my report has 3 headings first heading should be printed with the merging of (1-5)cells and heading 2 should be of merge(2-4)cells?how to do this condition?
what is SAS/Access and SAS/Connect?what are the uses?
In the following DATA step, what is needed for ‘fraction’ to print to the log? data _null_; x=1/3; if x=.3333 then put ‘fraction’; run;