how to write code for left outer join in SAs using datastep?
Answer Posted / uma
first sort these datasets by common variable DEPT_ID,Then
use the following:
data left_join;
merge emp (in=a) dept (in=b);
by dept_id;
if a then output;
run;
| Is This Answer Correct ? | 22 Yes | 2 No |
Post New Answer View All Answers
what is the basic structure sas administrator? : Sas-administrator
for what purpose would you use the retain statement? : Sas programming
Tell me about % include and % eval? : sas-macro
What are the default statistics that proc means produce?
What are the features of base sas system?
hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana
what is sas database server? : Sas-di
Briefly explain input and put function?
what is sas metadata repository? : Sas-bi
what are _numeric_ and _character_ and what do they do? : Sas programming
How to include or exclude specific variables in a data set?
Explain the difference between informat and format with an example.
How to sort in descending order?
WHAT IS SAS WEB SERVICE and what are the steps to create an xml service ?
What do you know about symput and symget?