How would you code a merge that will keep only the
observations that have matches from both sets.
Answer Posted / nishant
Using "IN" variable option. Look at the following example.
data three;
merge one(in=x) two(in=y);
by id;
if x=1 and y=1;
run;
| Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
What are the difference between ceil and floor functions in sas?
What are the automatic variables for macro? : sas-macro
What is the role of administrative users? : sas-grid-administration
Hi Jeevan/Akshara I have tried to contact SASI Vats for latest Advanced SAS Programming Certification Dumps (A00-212) but have not got any response. I would highly and gratefully appreciate your assistance in this regard. If you guys have access to this, would you be kind enough to forward it to me ? I would abide by all the terms you have for this. Please, note my email id: upretigopi@yahoo.com Preti Sharma
For clinical entire study how many tables will create approx?
what is sas application server? : Sas-di
What makes sas stand out to be the best over other data analytics tools?
Explain append procedure?
Which command is used to perform sorting in sas program?
I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com
What are the special input delimiters used in SAS?
Name some categories in sas 9? : sas-grid-administration
Mention common programming errors committed in sas ?
What is PDV?
How is character variable converted into numeric variable and vice versa?