topic Re: Date range by Year in SAS Programming

Date range by Year

danwarags — Wed, 07 Sep 2016 18:06:42 GMT

Hello Everyone,

I have a dataset with datevalues as shown below. I am trying to filter the dates which fall in certain range. How should I code this. For example, for the below dataset I need the date values in between 2001-01-01 and 2004-12-31.

Date	ID
2000-12-28	1
2001-05-26	3
2002-06-12	4
1999-05-25	6
2001-01-05	7
2002-01-20	8
1998-05-17	5
2007-06-20	9
2008-04-26	10

Re: Date range by Year

Reeza — Wed, 07 Sep 2016 18:34:53 GMT

If your dates are SAS dates (numeric with a date format) then filtering based on year should be fine.

where year(date) between 2000 and 2004;

if 2000 <= year(date) <= 2004;