topic Filter on date which shows as 'MONYYYY' in SAS Programming

Filter on date which shows as 'MONYYYY'

dennis_oz — Mon, 14 Oct 2019 23:51:04 GMT

Hi i was wanting to filter based on 'MONYYYY' date condition in the where step

I know about the default date filter condition 'DDMONYYY'd . But that does not help here .

any suggestions ?

eg:

'AUG2018'

'SEP2018'

Re: Filter on date which shows as 'MONYYYY'

Reeza — Mon, 14 Oct 2019 23:56:12 GMT

How are you trying to filter your data?

You need to either use the formatted value or change your filter to use a full date.

where '01Jun2019'd <= date_filtered <= '30Jun2019'd;

where vvalue(date_filtered) = '01JUN'; *check case matches here;

where put(date_filtered, monyy5.) = '01JUN';*case must match, text comparison;

@dennis_oz wrote:

Hi i was wanting to filter based on 'MONYYYY' date condition in the where step

I know about the default date filter condition 'DDMONYYY'd . But that does not help here .

any suggestions ?

eg:

'AUG2018'

'SEP2018'

Re: Filter on date which shows as 'MONYYYY'

PaigeMiller — Mon, 14 Oct 2019 23:59:04 GMT

@dennis_oz wrote:

Hi i was wanting to filter based on 'MONYYYY' date condition in the where step

I know about the default date filter condition 'DDMONYYY'd . But that does not help here .

any suggestions ?

eg:

'AUG2018'

'SEP2018'

Your use of quotes around the date confuses the matter. SAS does not display the quotes when you look at dates, so why are you showing the quotes to us?

Are these numeric variables, formatted to appear as AUG2018? Or are they character strings in a character variable?

In either case, you can filter using a WHERE clause, but to do this properly we need to know if they are character or numeric variables.

Re: Filter on date which shows as 'MONYYYY'

Kurt_Bremser — Tue, 15 Oct 2019 05:18:23 GMT

Maxim 3: Know Your Data.

Is the variable in question character or numeric? If it is numeric, it has the monyy7. format assigned and contains a valid SAS date value; you can directly compare it to a date literal.

If it is character, you need to convert it first.

Re: Filter on date which shows as 'MONYYYY'

dennis_oz — Tue, 15 Oct 2019 11:44:32 GMT

they are numeric variables that habe the format applied to them.

Re: Filter on date which shows as 'MONYYYY'

PaigeMiller — Tue, 15 Oct 2019 12:09:03 GMT

@dennis_oz wrote:
they are numeric variables that habe the format applied to them.

The first line of code from @Reeza should work. Probably his other lines of code work as well.

Re: Filter on date which shows as 'MONYYYY'

Kurt_Bremser — Tue, 15 Oct 2019 12:45:36 GMT

You can also use

where month(yourdate) = 8 and year (yourdate) = 2018;