How would you code a merge that will keep only the
observations that have matches from both sets?
Answer Posted / vijay
Dear Guest,
Merge won't accept NODUPKEY option. it is for PROC SORT.
the following code will get only matched observations in
both datasets
data three;merge one (in=a) two (in=b);by **;if a and b;run;
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
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
Name some categories in sas 9? : sas-grid-administration
What is Linear Regression?
What is the difference between using drop = data set option in data statement and set statement?
Difference between nodup and nodupkey options?
What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?
what versions of sas have you used (on which platforms)? : Sas programming
What are the automatic variables for macro? : sas-macro
What is the length assigned to the target variable by the scan function?
Describe a time when you were really stuck on a problem and how you solved it?
describe about physical data integration? : Sas-di
how can you create zero observation dataset? : Sas programming
Mention what is PROC in SAS?
Where do you use proc means over proc freq?
For what purpose would you use the RETAIN statement?