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

How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?

2131


name the scheduler for scheduling job and explain the scheduler? : Sas-di

1050


What are the data types in sas?

1069


What is the maximum and minimum length of macro variable

1265


Give e an example of..

2106


What commands are used in the case of including or excluding any specific variables in the data set?

1102


Which command is used to perform sorting in sas program?

1057


What is your favorite all time computer book? Why?

2518


Do you know the features of sas?

1049


What are common programming errors committed in sas

1155


How would you identify a macro variable?

1097


What does proc print, and proc contents are used for?

1142


What is the difference between INPUT and INFILE ?

1331


Why double trailing @@ is used in input statement?

1232


What is Linear Regression?

1174