How would you code a merge that will keep only the
observations that have matches from both sets?

Answer Posted / san

data c;
merge data a(in=a)
dat b(in=b);
if a=1 and b=1;
by<common column>;
run;

Is This Answer Correct ?    0 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

555


How to specify variables to be processed by the freq procedure?

613


what do you mean by data staging area? : Sas-di

597


What areas of SAS are you most interested in?

1062


how could you generate test data with no input data? : Sas programming

619






Differentiate between proc means and proc summary.

599


how do the in= variables improve the capability of a merge? : Sas programming

931


Define run-group processing?

579


why is a stop statement needed for the point=option on a set statement? : Sas programming

583


What are the 3 components in sas programming?

723


what are input dataset and output dataset options? : Sas programming

561


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

634


If a variable contains letters or special characters, can it be numeric data type?

757


List down the reasons for choosing sas over other data analytics tools.

805


Do you need to know if there are any missing values?

591