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
if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...
what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi
where are dashboard components are created and maintained? : Sas-bi
Enlist the functions performed by sas.
How to create list output for cross-tabulations in proc freq?
what is the purpose of _error_? : Sas programming
Explain the purpose of retain statement.
What makes sas stand out to be the best over other data analytics tools?
Which function is used to count the number of intervals between two sas dates?
Explain the use of proc gplot? : sas-grid-administration
Mention the category in which sas informats are placed?
What is the difference between input and infile statement?
for whom is sas data integration studio designed? : Sas-di
Tell e how how dealt with..
Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro