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

Difference between nodup and nodupkey options?

1271


Explain proc sort?

1176


explain the main difference between the nodup and nodupkey options? : Sas-administrator

1221


What is the role of sas grid administrator? : sas-grid-administration

1343


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

1130


What Proc glm does?

1141


Name few SAS functions?

1146


how sas deals with business intelligence? : Sas-bi

1103


for whom is sas data integration studio designed? : Sas-di

1061


How would you determine the number of missing or nonmissing values in computations?

1132


Are you sensitive to code walk-throughs peer review or QC review?

3200


what is ae onset date n what is RDS

2661


what are several options for creating reports in web report studio? : Sas-bi

1226


Describe what are the different levels of administrative users in sas? : sas-grid-administration

1082


Differences between where and if statement?

1156