https://communities.sas.com/t5/SAS-Procedures/Conditional-Merge/m-p/667302#M79068 <P>This worked, but the final data set only contains observations that met those conditional statements. Is there a way to retain <EM>all</EM> observations regardless of whether they merge given the specified conditions?</P> Mon, 06 Jul 2020 21:37:50 GMT raivester 2020-07-06T21:37:50Z https://communities.sas.com/t5/SAS-Procedures/Conditional-Merge/m-p/667298#M79066 <P>I was wondering if anyone could share how to merge two data sets conditionally. The following is a simplified example of what I am trying to do. I have two data sets and each is unique at the <STRONG>individ_id_num</STRONG> and <STRONG>year</STRONG> level. The <STRONG>year</STRONG> variable ranges from 2000-2020.&nbsp;&nbsp;I only want the merge to occur for <STRONG>year</STRONG>=2018. Is there some way to specify merge only if <STRONG>year</STRONG>=2018 in both data sets?</P> Mon, 06 Jul 2020 20:56:29 GMT https://communities.sas.com/t5/SAS-Procedures/Conditional-Merge/m-p/667298#M79066 raivester 2020-07-06T20:56:29Z https://communities.sas.com/t5/SAS-Procedures/Conditional-Merge/m-p/667299#M79067 <PRE><CODE class=" language-sas">data want; merge have1(where=(year=2018) in=in1) have2(where=(year=2018) in=in2); by indiv_id_num; if in1 and in2; run;</CODE></PRE> <P>Assumes have1 and have2 are properly sorted by indiv_id_num.</P> Mon, 06 Jul 2020 21:02:27 GMT https://communities.sas.com/t5/SAS-Procedures/Conditional-Merge/m-p/667299#M79067 PaigeMiller 2020-07-06T21:02:27Z https://communities.sas.com/t5/SAS-Procedures/Conditional-Merge/m-p/667302#M79068 <P>This worked, but the final data set only contains observations that met those conditional statements. Is there a way to retain <EM>all</EM> observations regardless of whether they merge given the specified conditions?</P> Mon, 06 Jul 2020 21:37:50 GMT https://communities.sas.com/t5/SAS-Procedures/Conditional-Merge/m-p/667302#M79068 raivester 2020-07-06T21:37:50Z