topic merge If condition A then data set1 ,else data set 2 in SAS Programming

merge If condition A then data set1 ,else data set 2

Ronein — Thu, 30 Sep 2021 14:41:00 GMT

Hello

What is the way to merge in the following way:

If condion A then merge from data set tbl1

If condion B then merge from data set tbl2

thanks

Re: merge If condition A then data set1 ,else data set 2

PaigeMiller — Thu, 30 Sep 2021 15:27:25 GMT

%macro conditional_merge;
data want;
     merge have
         %if &x=0 %then tbl1;
         %else %if &x>0 %then tbl2;
     ;
run;
%mend conditional_merge;
%conditional_merge