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
12075 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

What is the basic syntax of a sas program?

0 Answers

You need to perform an analysis on a massive dataset by groups, but are unable to sort the data due to memory constraint. How would you accomplish the task?

2 Answers

data data1; input dt account; format dt date9.; cards; 1745 1230 1756 1120 1788 1130 1767 1240 ; data data2; input startdt enddt total; format startdt date9. enddt date9.; cards; 1657 1834 12300 1557 1758 16800 1789 1789 12300 1788 1345 12383 1899 1899 13250 ; proc sql; create table data3 as select * from data1 as x left join data2 as y on x.dt>=y.startdt and x.dt<=y.enddt; quit; Here, we are getting cartision product. But,I want left join report consisting of this program. It should not get duplicate values. you can modify the program also.

1 Answers

Give e an example of..

0 Answers

What makes sas stand out to be the best over other data analytics tools?

0 Answers

How to import the Zip files into SAS? If it is possible in SAS? If it is posible write the code...

7 Answers

what is proc Index? and what is proc document?

0 Answers Mind Tree,

i want to upload titles and footnotes to excel file?how it is possible?

1 Answers

how can u import .csv file in to SAS?tell Syntax?

7 Answers CitiGroup, Franklin Templeton,

What is SAS Information Map Studio and its purpose ?

2 Answers SAS, TCS,

Hi im new to sas. I have a file with some charecter variables and some numeric variables now i want to load charecter variables into one datastep and numeric variables into another data step pls let me know Thanks

2 Answers

how sas deals with business intelligence? : Sas-bi

0 Answers

For more SAS Interview Questions Click Here