How would you code a merge that will keep only the
observations that have matches from both sets?
Answer Posted / 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 |
Post New Answer View All Answers
Explain the use of proc print and proc contents?
explain what is data set in sas? : Sas-administrator
describe about metadata object? : Sas-di
explain about sas business intelligence? : Sas-bi
what is sas business intelligence? : Sas-bi
Will it bother you if the guy at the next desk times the frequency and duration of your bathroom or coffee breaks on the grounds that ?you are getting paid twice as much as he is??
What are the uses of sas?
What will calendar procedure do?
Explain append procedure?
Mention common programming errors committed in sas ?
What system options would you use to help debug a macro? : sas-macro
Differences between where and if statement?
what is the primary data source for the wrs? : Sas-bi
Do you need to rearrange the order of the data for the report?
How does proc sql work?