How would you code a merge that will keep only the
observations that have matches from both sets?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
what is sas metadata server? : Sas-di
How do you debug and test your SAS programs?
How do you define proc in sas? : sas-grid-administration
Describe the ways in which you can create a macro variable?
"What is the difference between proc sort nodup and proc sort nodupkey?"
Hot to suppress characters from a given string?
Where do you use proc means over proc freq?
what is the function of catx syntax? : Sas-administrator
If you?re not wanting any SAS output from a data step, how would you code the data statement to prevent SAS from producing a set?
What is the difference between a PROC step and a DATA step?
The Lion King is hosting an animal conference. All the animals in the world attend except one. Which animal does not attend?
What is Tabulate.?Why we use it.? Which type of output we get from Tabulate.?