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 keep only the
observations that have matches from both sets?

Answer Posted / vijay

Dear Guest,
Merge won't accept NODUPKEY option. it is for PROC SORT.
the following code will get only matched observations in
both datasets

data three;merge one (in=a) two (in=b);by **;if a and b;run;

Is This Answer Correct ?    12 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the use of proc print and proc contents?

967


explain what is data set in sas? : Sas-administrator

993


describe about metadata object? : Sas-di

1077


explain about sas business intelligence? : Sas-bi

1147


what is sas business intelligence? : Sas-bi

1183


Will it bother you if the guy at the next desk times the frequency and duration of your bathroom or coffee breaks on the grounds that ?you are getting paid twice as much as he is??

2617


What are the uses of sas?

1277


What will calendar procedure do?

1081


Explain append procedure?

1090


Mention common programming errors committed in sas ?

1131


What system options would you use to help debug a macro? : sas-macro

1101


Differences between where and if statement?

1099


what is the primary data source for the wrs? : Sas-bi

1243


Do you need to rearrange the order of the data for the report?

2311


How does proc sql work?

1101