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

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

Question Posted / naveen

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

Please Help Members By Posting Answers For Below Questions

what are the component of range? : Sas-bi

1102

what is sas metadata repository? : Sas-bi

1119

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

979

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

993

What was the last computer book you purchased? Why?

2377

What are the scrubbing procedures in sas?

1014

Explain the difference between informat and format with an example.

1173

How does the internal authentication work in sas? : sas-grid-administration

1128

Enlist the syntax rules followed in sas statements.

1088

what is PhaseIII, ODS, TLG, Macro and Proc in SAS

4521

What is the order of application for output data set options, input data set options and SAS statements?

1564

what does the run statement do? : Sas programming

1060

What can you learn from the SAS log when debugging?

1392

Describe the ways in which you can create a macro variable?

1089

what are the types of interactive display types? : Sas-bi

1100