Interested to Buy Any Domain ? << Click Here >> for more details...
How would you code a merge that will keep only the
observations that have matches from both sets?
- 5 Answers
- 11908 Views
- I also Faced
- E-Mail Answers
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
How does the internal authentication work in sas? : sas-grid-administration
Explain substr function?
what are informats in sas? : Sas-administrator
what has been your most common programming mistake? : Sas programming
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??
Differentiate between sas functions and sas procedures.
explain the function of substr in sas? : Sas-administrator
If a variable contains letters or special characters, can it be numeric data type?
what are the new features included in the new version of sas i.e., Sas 9.1.3? : Sas programming
What commands are used in the case of including or excluding any specific variables in the data set?
How you can read the variables that you need?
why a stop statement is needed for the point= option on a set statement?
Describe what are the different levels of administrative users in sas? : sas-grid-administration
How to create an external dataset with sas code?
For what purposes have you used sas macros? : sas-macro
