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
Name some categories in sas 9? : sas-grid-administration
How to specify variables to be processed by the freq procedure?
what do you mean by data staging area? : Sas-di
What areas of SAS are you most interested in?
how could you generate test data with no input data? : Sas programming
Differentiate between proc means and proc summary.
how do the in= variables improve the capability of a merge? : Sas programming
Define run-group processing?
why is a stop statement needed for the point=option on a set statement? : Sas programming
What are the 3 components in sas programming?
what are input dataset and output dataset options? : Sas programming
how does sas handle missing values in procs? : Sas programming
If a variable contains letters or special characters, can it be numeric data type?
List down the reasons for choosing sas over other data analytics tools.
Do you need to know if there are any missing values?