How would you code a merge that will keep only the
observations that have matches from both sets?

Answer Posted / naveen

data qqq;
merge aaa(in=a) bbb(in=b);
if a and b;
run;

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what versions of sas have you used (on which platforms)? : Sas programming

580


I need level 2 to 5 sas using companies in india

1926


How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro

578


is data integration and etl programming is same? : Sas-di

574


which date functions advances a date time or date/time value by a given interval? : Sas programming

533






If a variable contains only numbers, can it be a character data type?

610


What is the difference between SAS functions and procedures?

653


Differences between where and if statement?

580


For what purposes have you used sas macros? : sas-macro

537


What is SAS? What are the functions does it performs?

727


for whom is sas data integration studio designed? : Sas-di

554


AE datasets names? how many types?

2072


Difference between sum function and using “+” operator?

598


how does sas handle missing values in procs? : Sas programming

634


How would you define the end of a macro?

698