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

Answer Posted / murray

Both answers #2 and #3 will work fine, however the '= 1'
part is superfluous, and will work fine without.

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what techniques and/or procs do you use for tables? : Sas programming

573


What is slibref?

744


what is operational data and operational system? : Sas-di

631


What are the parameters of scan function?

619


if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...

940






explain about various caches available in data integrator? : Sas-di

576


How will you generate test data with no input data?

561


What is the differnce between SDTM 3.1.2 to 3.1.1 version

4608


What is SAS informats?

633


Name some categories in sas 9? : sas-grid-administration

555


Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro

694


What is the general format of function in sas? : sas-grid-administration

563


how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming

596


what is sas and what are the functions? : Sas-administrator

537


what is sas database server? : Sas-di

611