How would you code a merge that will keep only the
observations that have matches from both sets.
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
explain about various caches available in data integrator? : Sas-di
name some data transformation used in sas di? : Sas-di
Of all your work, where have you been the most successful?
What are the scrubbing procedures in sas?
what is operational data and operational system? : Sas-di
Describe the function and untility of the most difficult SAS macro that you have written.
Describe a time when you were really stuck on a problem and how you solved it?
What is by-group processing?
what is data integration? : Sas-di
describe the interaction table in sas di? : Sas-di
if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming
explain about data integrator metadata reports? : Sas-di
What are the parameters of scan function?
What will calendar procedure do?
explain about sas business intelligence? : Sas-bi