Delete rows based on a date in yymmdd8. format

[CherylA]

I need to remove all records from a dataset where the field 'Start_date' isn't within a certain range of dates. 

START_DATE - is in the format DATE9. i.e 01JAN2020. 

I keep having formatting errors whichever way I try. 

Thanks in advance 🙂 

[Reeza · Accepted solution]

if start_date > '01Apr2020'd then delete;

You need to specify your date as a date9 format with a d after the string. Above should work and give you an idea of how to format your code.

[CherylA]

That worked perfectly, thank you! 🙂

[Kurt_Bremser]

A SAS date literal needs to be written in the form

"01JAN2020"d

to be compared with SAS dates.