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 would you code a merge that will write the matches of
both to one data set, the non-matches from the left-most
data set to a second data set, and the non-matches of the
right-most data set to a third data set.

Answer Posted / tangyoulei

data new1 new2 new3;
merge old1 (in=one) old2 (in=two);
if one and two then output new1;
else if one and not two then output new2;
else output new3;
run;

Is This Answer Correct ?    16 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the work of tranwrd function?

1238


why is a stop statement needed for the point=option on a set statement? : Sas programming

1079


What is the difference between %local and %global? : sas-macro

1179


i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm

2366


What is the maximum and minimum length of macro variable

1243


Explain substr function?

1098


what is ae onset date n what is RDS

2568


What are the statements in proc sql?

1097


which date function advances a date, time or datetime value by a given interval? : Sas programming

1040


What are the uses of sas?

1257


How do you test for missing values?

1625


what is treatment emergent events and treatment emregent adverse event

2395


How would you identify a macro variable? : sas-macro

1016


What are the automatic variables for macro? : sas-macro

1242


how can you create zero observation dataset? : Sas programming

1141