how to put a where statement in a merge

alepage — Fri, 22 Nov 2024 22:43:22 GMT

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;

Re: how to put a where statement in a merge

Tom — Fri, 22 Nov 2024 23:01:51 GMT

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."))

topic how to put a where statement in a merge in SAS Enterprise Guide

how to put a where statement in a merge

Re: how to put a where statement in a merge