https://communities.sas.com/t5/SAS-Programming/Update-colum-in-dataset-based-on-comparison-of-2-other-columns/m-p/683085#M206842 <PRE><CODE class=" language-sas">case when c1 = c2 then 'OK' else 'NOK' end as eval</CODE></PRE> Thu, 10 Sep 2020 21:39:50 GMT Kurt_Bremser 2020-09-10T21:39:50Z https://communities.sas.com/t5/SAS-Programming/Update-colum-in-dataset-based-on-comparison-of-2-other-columns/m-p/683081#M206838 <P>have</P> <P>c1 c2&nbsp;</P> <P>aa bb</P> <P>cc cc</P> <P>aa aa</P> <P>&nbsp;</P> <P>want</P> <P>c1 c2 eval</P> <P>aa bb NOK</P> <P>cc cc OK</P> <P>aa aa OK</P> <P>&nbsp;</P> <P>can you do this with a proc sql ?</P> <P>thank you</P> <P>&nbsp;</P> <P>&nbsp;</P> Thu, 10 Sep 2020 21:25:10 GMT https://communities.sas.com/t5/SAS-Programming/Update-colum-in-dataset-based-on-comparison-of-2-other-columns/m-p/683081#M206838 VCucu 2020-09-10T21:25:10Z https://communities.sas.com/t5/SAS-Programming/Update-colum-in-dataset-based-on-comparison-of-2-other-columns/m-p/683085#M206842 <PRE><CODE class=" language-sas">case when c1 = c2 then 'OK' else 'NOK' end as eval</CODE></PRE> Thu, 10 Sep 2020 21:39:50 GMT https://communities.sas.com/t5/SAS-Programming/Update-colum-in-dataset-based-on-comparison-of-2-other-columns/m-p/683085#M206842 Kurt_Bremser 2020-09-10T21:39:50Z