topic Re: Delete rows based on a date in yymmdd8. format in SAS Programming

Delete rows based on a date in yymmdd8. format

CherylA — Mon, 15 Jun 2020 17:07:29 GMT

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 🙂

Re: Delete rows based on a date in yymmdd8. format

Reeza — Mon, 15 Jun 2020 17:11:24 GMT

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.

Re: Delete rows based on a date in yymmdd8. format

Kurt_Bremser — Mon, 15 Jun 2020 17:13:27 GMT

A SAS date literal needs to be written in the form

"01JAN2020"d

to be compared with SAS dates.

Re: Delete rows based on a date in yymmdd8. format

CherylA — Mon, 15 Jun 2020 17:14:47 GMT

That worked perfectly, thank you! 🙂