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 is the function of Stop statement in a SAS Program?

1200

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

1102

What is factor analysis?

1199

What are symget and symput? : sas-macro

1368

What is the difference between reading data from an external file and reading data from an existing data set?

1232

What are the advantages of using sas?

1189

What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?

1199

What is the work of tranwrd function?

1297

Have you ever used the SAS Debugger?

1820

what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming

1182

Explain what is data step?

1240

how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming

1403

What sas features do you use to check errors and data validation?

1266

How many data types are there in SAS?

1132

What are the ways to do a “table lookup” in sas?

1076