https://communities.sas.com/t5/SAS-Procedures/How-to-compare-SAS-date-with-a-string-date/m-p/8500#M382 You will need to determine the format (CHARACTER OR SAS/NUMERIC) of the date variables involved -- best to work with SAS NUMERIC variables and make comparisons. Suggest some basic SAS DATE variable review and reading from the SAS support <A href="http://support.sas.com/" target="_blank">http://support.sas.com/</A> website.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc.<BR /> <BR /> SAS Language Reference: Concepts - Dates, Times, and Intervals<BR /> <A href="http://support.sas.com/documentation/cdl/en/lrcon/61722/HTML/default/a001112342.htm" target="_blank">http://support.sas.com/documentation/cdl/en/lrcon/61722/HTML/default/a001112342.htm</A> Wed, 28 Oct 2009 03:44:52 GMT sbb 2009-10-28T03:44:52Z https://communities.sas.com/t5/SAS-Procedures/How-to-compare-SAS-date-with-a-string-date/m-p/8499#M381 I have a column named "EffectiveDate". I want to check for a record that has an EffectiveDate of "01-01-2010", then this record need to be removed. I don't know how to compare since the EffectiveDate is formated in Date type and the values look numerics. Can I use put function to convert the EffectiveDate to string? then I compare it with "01-01-2010". Your inputs are much appreciated. Wed, 28 Oct 2009 03:34:48 GMT https://communities.sas.com/t5/SAS-Procedures/How-to-compare-SAS-date-with-a-string-date/m-p/8499#M381 Lani 2009-10-28T03:34:48Z https://communities.sas.com/t5/SAS-Procedures/How-to-compare-SAS-date-with-a-string-date/m-p/8500#M382 You will need to determine the format (CHARACTER OR SAS/NUMERIC) of the date variables involved -- best to work with SAS NUMERIC variables and make comparisons. Suggest some basic SAS DATE variable review and reading from the SAS support <A href="http://support.sas.com/" target="_blank">http://support.sas.com/</A> website.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc.<BR /> <BR /> SAS Language Reference: Concepts - Dates, Times, and Intervals<BR /> <A href="http://support.sas.com/documentation/cdl/en/lrcon/61722/HTML/default/a001112342.htm" target="_blank">http://support.sas.com/documentation/cdl/en/lrcon/61722/HTML/default/a001112342.htm</A> Wed, 28 Oct 2009 03:44:52 GMT https://communities.sas.com/t5/SAS-Procedures/How-to-compare-SAS-date-with-a-string-date/m-p/8500#M382 sbb 2009-10-28T03:44:52Z https://communities.sas.com/t5/SAS-Procedures/How-to-compare-SAS-date-with-a-string-date/m-p/8501#M383 if EffectiveDate = '01jan2010'd then delete; Wed, 28 Oct 2009 08:11:20 GMT https://communities.sas.com/t5/SAS-Procedures/How-to-compare-SAS-date-with-a-string-date/m-p/8501#M383 GertNissen 2009-10-28T08:11:20Z