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
- 14541 Views
- Accenture, Bank Of America, I also Faced
- E-Mail Answers
Answer Posted / madhavi
proc sort data=one;
by id;
run;
proc sort data=two;
by id;
run;
data comm_rec;
merge one(in=a) two(in=b);
by id;
if a and b;
run;
proc print data=comm_rec;
run;
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
What is the role of unrestrictive users? : sas-grid-administration
what is transformation in sas data integration? : Sas-di
What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?
Give some examples where proc report’s defaults are different than proc print’s defaults?
Explain data step in SAS
How we can call macros with in data step? : sas-macro
Describe a time when you were really stuck on a problem and how you solved it?
What is the difference between using drop = data set option in data statement and set statement?
Describe the function and untility of the most difficult SAS macro that you have written.
what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi
How sas treats the dsd delimiters?
Can you suggest us materials for sdtm mapping?
what is SAS OPTIMIZATION?
please can you tell me that in companies sas work are doing by through sas coding or sas wizard ??
Mention the difference between ceil and floor functions in sas?
