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

if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...

1443


what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi

1055


where are dashboard components are created and maintained? : Sas-bi

1058


Enlist the functions performed by sas.

1186


How to create list output for cross-tabulations in proc freq?

1147


what is the purpose of _error_? : Sas programming

1183


Explain the purpose of retain statement.

1100


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

1108


Which function is used to count the number of intervals between two sas dates?

1183


Explain the use of proc gplot? : sas-grid-administration

1042


Mention the category in which sas informats are placed?

1076


What is the difference between input and infile statement?

1218


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

1055


Tell e how how dealt with..

2263


Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro

1255