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

Hi Jeevan/Akshara I have tried to contact SASI Vats for latest Advanced SAS Programming Certification Dumps (A00-212) but have not got any response. I would highly and gratefully appreciate your assistance in this regard. If you guys have access to this, would you be kind enough to forward it to me ? I would abide by all the terms you have for this. Please, note my email id: upretigopi@yahoo.com Preti Sharma

3467


Name some categories in sas 9? : sas-grid-administration

915


What is Linear Regression?

1104


What is the difference between using drop = data set option in data statement and set statement?

1105


Difference between nodup and nodupkey options?

1110


What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?

1099


what versions of sas have you used (on which platforms)? : Sas programming

1003


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

1140


What is the length assigned to the target variable by the scan function?

1095


Describe a time when you were really stuck on a problem and how you solved it?

2578


describe about physical data integration? : Sas-di

992


how can you create zero observation dataset? : Sas programming

1087


Mention what is PROC in SAS?

1009


Where do you use proc means over proc freq?

1052


For what purpose would you use the RETAIN statement?

1464