how to put a where statement in a merge

[alepage]

Hello,

I would like to put a where statement to reduce the size of one of the dataset.

First question is it possible to do it and if so how?

data dest1.&filename dest2.&filename._Anonym;
merge source4.&filename. (in=inbase)
src1.**bleep**rmt_in_premds_intg_20241031 (in=inlist) (where=(filename eq "&filename."))
;
by ORGNL_SAS_DS_ROW_NBR;
if inlist and inbase then output dest2.&filename._Anonym;
else if inbase then output dest1.&filename.;
run;

[Tom · Accepted solution]

You have the right idea, only the wrong syntax.  All of the dataset options appear in one set of ().

libref.memname(in=inlist where=(filename eq "&filename."))