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

Mention what are the data types does SAS contain?

1192


Which date function advances a date, time or datetime value by a given interval?

1194


Mention the category in which sas informats are placed?

1076


Hi, If anyone has base SAS certification dumps, please share.

1925


What are the different versions of sas that you have used until now? : sas-grid-administration

1389


explain about various caches available in data integrator? : Sas-di

1111


how sas deals with business intelligence? : Sas-bi

1101


How long can a macro variable be? A token? : sas-macro

1264


describe about physical data integration? : Sas-di

1096


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

5503


For what purpose would you use the RETAIN statement?

1583


for report generation which one you used proc report or data_null_?

7933


List down the reasons for choosing sas over other data analytics tools.

1329


what are some differences between proc summary and proc means? : Sas programming

1194


Explain the purpose of retain statement.

1105