How would you code a merge that will keep only the
observations that have matches from both sets?
Answer Posted / san
data c;
merge data a(in=a)
dat b(in=b);
if a=1 and b=1;
by<common column>;
run;
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?
what is treatment emergent events and treatment emregent adverse event
What do you know about sas data set?
what do the pad and dim functions do? : Sas programming
I have a dataset concat having a variable a b & c. How to rename a b to e & f?
What are the default statistics for means procedure?
How can sas program be validated?
how many display types available in sas bi dashboard? : Sas-bi
for what purpose would you use the retain statement? : Sas programming
Are you involved in writing the inferential analysis plan? Tables specifications?
Can you execute a macro within a macro? Describe. : sas-macro
How to create an external dataset with sas code?
Explain the purpose of retain statement.
what is PhaseIII, ODS, TLG, Macro and Proc in SAS
what is transformation in sas data integration? : Sas-di