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 / sheetal

Using joins in proc sql statement, see following example

proc sql;
select *
from a, b
where a.case_id = b.case_id;
quit;

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between the proc sql and data step?

1169


Hi,by usining ptf how we have to combine (likr merge)10 datasets at a time in the oracle database(and write a macro code also)?Like this i have a douts a lot if you dont mind may please send one text mail for me(madhusudhanap16@gmail.com)?

1675


how does sas handle missing values in functions? : Sas programming

1197


What is the sas data set? : sas-grid-administration

976


How do you test for missing values?

1624


how to change the execute of macro

2302


What is the good sas programming practices for processing large data sets?

1105


name several ways to achieve efficiency in your program? : Sas programming

1057


What is the difference between SAS functions and procedures?

1144


Are you involved in writing the inferential analysis plan? Tables specfications?

2219


Are you involved in writing the inferential analysis plan? Tables specifications?

3946


which date functions advances a date time or date/time value by a given interval? : Sas programming

941


How do you control the number of observations and/or variables read or written? Approximately what date is represented by the SAS date value of 730?

1664


What are the difference between the sas data step and sas procs?

1178


What makes sas stand out to be the best over other data analytics tools?

1053