How would you code a merge that will keep only the
observations that have matches from both sets.
Answer Posted / sheetal
Using joins in proc sql statement, see following example
proc sql;
select *
from a, b
where a.case_id = b.case_id;
quit;
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What are SAS/ACCESS and SAS/CONNECT?
Differentiate input and infile.
What do the sas log messages “numeric values have been converted to character” mean? What are the implications?
How would you identify a macro variable?
What are the uses of sas?
What is the difference between nodupkey and nodup options?
what do you mean by data staging area? : Sas-di
What is the difference between one to one merge and match merge? Give an example.
name some data transformation used in sas di? : Sas-di
explain the function of substr in sas? : Sas-administrator
what is sas enterprise intelligence architecture? : Sas-bi
what is the Population you used in your project, is it ITT or PP?
How substr function works in sas?
How do dates work in sas?
how the sas basic syntax style described? : Sas-administrator