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

Which are the statements whose placement in the data step is critical?

1203


What are the data types does SAS contain?

1065


what do the sas log messages "numeric values have been converted to character" mean? What are the implications? : Sas programming

1210


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

1511


What is the role of sas grid administrator? : sas-grid-administration

1243


What is the basic syntax of a sas program?

1162


How do you convert basic cube to transaction cube and transaction cube to basic cube?

2196


: and & modifiers.

1345


What do you know about sas and what we do? : sas-grid-administration

1073


Which command is used to perform sorting in sas program?

1007


What is the maximum and minimum length of macro variable

1185


What are the ways to do a “table lookup” in sas?

989


how to change the execute of macro

2250


Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?

2368


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

1190