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 / aniruddha

Data left_outer;
merge emp(in=a) dept(in=b);
by deptno;
if a=1 and b=0;
run;

Is This Answer Correct ?    22 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between order and group variable in proc report?

1437


What is maximum number of rows and cols can be handled in SAS?

1588


How does proc sql work?

1092


Enlist the syntax rules followed in sas statements.

1087


What is a put statement?

1202


what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming

1244


how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5

2112


What are the data types that sas contain?

1186


What is the order of application for output data set options, input data set options and SAS statements?

1561


Are you involved in writing the inferential analysis plan? Tables specifications?

3960


What is the use of %include statement?

1063


Mention what is the difference between nodupkey and nodup options?

1012


How can you create a macro variable with in data step? : sas-macro

1045


How do you test for missing values?

1639


Which command is used to perform sorting in sas program?

1048