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
do you prefer proc report or proc tabulate? Why? : Sas programming
what r the job openings SAS for fresher graduates !
Enlist the functions performed by sas.
How does the internal authentication work in sas? : sas-grid-administration
If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?
Explain the use of proc gplot? : sas-grid-administration
how many types prompting framework can be broken down to? : Sas-bi
What do the SAS log messages "numeric values have been converted to character" mean?
what is data integration? : Sas-di
What is the basic structure of the SAS base program?
How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?
how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming
What Proc glm does?
Hi, If anyone has base SAS certification dumps, please share.
What do you know about sas and what we do? : sas-grid-administration