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 is the difference between the proc sql and data step?
Hi,by usining ptf how we have to combine (likr merge)10 datasets at a time in the oracle database(and write a macro code also)?Like this i have a douts a lot if you dont mind may please send one text mail for me(madhusudhanap16@gmail.com)?
how does sas handle missing values in functions? : Sas programming
What is the sas data set? : sas-grid-administration
How do you test for missing values?
how to change the execute of macro
What is the good sas programming practices for processing large data sets?
name several ways to achieve efficiency in your program? : Sas programming
What is the difference between SAS functions and procedures?
Are you involved in writing the inferential analysis plan? Tables specfications?
Are you involved in writing the inferential analysis plan? Tables specifications?
which date functions advances a date time or date/time value by a given interval? : Sas programming
How do you control the number of observations and/or variables read or written? Approximately what date is represented by the SAS date value of 730?
What are the difference between the sas data step and sas procs?
What makes sas stand out to be the best over other data analytics tools?