How to select data from a specified time period

[ZZB]

Hi all,

I want to select only data from 02/29/2008 to 05/31/2009. The DATE format in my dataset is MMDDYY10.

I failed if using codes like [ if '02/29/2008'<=date<='05/31/2009' ].

Thanks a lot

[Kurt_Bremser · Accepted solution]

Is "date" a numeric variable formatted with mmddyy10.?

If so, then you need to write the condition like that:

if '29feb2008'd <= date <= '31may2009'd

'ddmmmyyyy'd is a date constant. Similar modifiers are t for time or x for hexadecimal.

If "date" is a string that contains MM/DD/YYYY values, I would recommend to use input(date,mmddyy10.) between the constants.