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

explain the proc in sas? : Sas-administrator

1034


Give some examples where proc report’s defaults are different than proc print’s defaults?

1010


In proc transpose and data step with arrays which one you pick?

3040


explain what is factor analysis? : Sas-administrator

1043


how can you put a "trace" in your program? : Sas programming

1004


How to sort in descending order?

1200


what is broad cast agent? : Sas-bi

1010


How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?

2401


what type of graphs we will create(for 2+years candidates)?

2240


how to read the variables in sas? : Sas-administrator

962


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

1049


Explain what is SAS informats?

1039


Differences between where and if statement?

1024


What is PROC in SAS?

1000


What do you know about symput and symget?

1163