How would you code a merge that will keep only the observations that have match

Categories >> Software >> Data Warehouse >> SAS
Suggest New Category

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

Question Posted / sasguru

5 Answers
11750 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / 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

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

Answer / naveen

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

Is This Answer Correct ?

1 Yes

0 No

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

Answer / 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

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

Answer / san

data c;
merge data a(in=a)
dat b(in=b);
if a=1 and b=1;
by<common column>;
run;

Is This Answer Correct ?

0 Yes

5 No

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

Answer / guest

nodupkey option in the merge statement

Is This Answer Correct ?

0 Yes

8 No

Post New Answer

More SAS Interview Questions

how can get the first and last observations in a dataset using Proc SQl?

4 Answers Satyam,

Under what circumstances would you code a SELECT construct instead of IF statements?

7 Answers Accenture,

What are the table names in oracle database...?

0 Answers HSBC,

Dear all, proc means data=dsn noprint completetypes; class trtmntgroup /preloadfmt; output out=tot n=n; format trtmntgroup trtf. ; by vstgrp descending severity; run; This is the code I used for AE table. I got the values without giving the variable ‘trtmntgroup(numeric)’ in var statement. And if I give the var statement for that variable i’m getting the same values.How is that possible? What is the difference between class and var statement? Could any one explain me how does proc means work at the back end. And what is the difference between _freq_ value and N value in proc means. Thanks and regards, Rajesh.

1 Answers

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

0 Answers

What is the sas data set? : sas-grid-administration

0 Answers

What does error:1 mean?

8 Answers Accenture,

what is the prob plot in clinical domain

1 Answers TCS,

There are 200 observations in a dataset, i want to pull out the observation no's 100, 150,180,190 by using Proc SQL? How you can get it?

5 Answers

How do you convert basic cube to transaction cube and transaction cube to basic cube?