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

if you use x=1 and y=0
you must use set statement also
try this
data a b;
merge one two;
by id;
if x=1 and y=1 then output a;
if x=1 and y=0 then output b;
data new;
set a b;
run;

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to create an external dataset with sas code?

1073


In ARRAY processing, what does the DIM function do?

1116


do you prefer proc report or proc tabulate? Why? : Sas programming

935


What are the default statistics for means procedure?

1171


Explain what is SAS informats?

1042


how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?

2706


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

988


Intern stastical programmer written test

682


How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?

1480


how do the in= variables improve the capability of a merge? : Sas programming

1396


what is study design in while working with SAS? what are screening variables in SAS?

2182


In sas, what are the areas that you are most interested in? : sas-grid-administration

1025


For clinical entire study how many tables will create approx?

1908


Give e an example of..

2275


describe about physical data integration? : Sas-di

994