Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

what is the basic structure sas administrator? : Sas-administrator

964


for what purpose would you use the retain statement? : Sas programming

1028


Tell me about % include and % eval? : sas-macro

1101


What are the default statistics that proc means produce?

979


What are the features of base sas system?

1024


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

5388


what is sas database server? : Sas-di

1061


Briefly explain input and put function?

1040


what is sas metadata repository? : Sas-bi

1067


what are _numeric_ and _character_ and what do they do? : Sas programming

1114


How to include or exclude specific variables in a data set?

1071


Explain the difference between informat and format with an example.

1123


How to sort in descending order?

1211


WHAT IS SAS WEB SERVICE and what are the steps to create an xml service ?

2748


What do you know about symput and symget?

1172