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

proc sql;
select *
from one left join two
on one.X=two.X;
quit;

The above is code for lefjoin.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the implications?

1781


what is hash files in sas and why we are using this one in sas?

2260


What is SAS? What are the functions does it performs?

1243


what is sas data set?

1144


What are the statements that are executed only?

1202


describe about metadata object? : Sas-di

1120


What do the mod and int function do? : Sas programming

1292


if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...

1444


what is business intelligence? : Sas-bi

1103


what are the types of interactive display types? : Sas-bi

1143


What do you know about sas data set?

1180


hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?

2103


which features do you use to check the data validations and errors? : Sas-administrator

1090


What is the purpose of trailing @ and @@? How do you use them?

1082


what is SAS OPTIMIZATION?

2348