Hi, I would like to select all observations who are present one month in a year with SAS EG. I have Start date et end Date as data with format Date and I'm running out of ideas num StartDate EndDate select 001 25/09/2013 4/10/2013 1 0002 26/09/2013 28/09/2013 0 0003 1/02/2012 05/04/2012 0 0004 30/09/2013 1/10/2013 1 0005 3/10/2013 8/10/2013 1 0006 26/10/2013 15/11/2013 1 0008 26/11/2013 4/12/2013 0 0009 30/09/2013 21/11/2013 1 0010 8/09/2013 4/11/2013 1 0011 3/05/2013 13/11/2013 1 0012 3/06/2013 25/07/2013 0 0013 2/09/2012 25/11/2012 0 0014 2/05/2014 21/05/2014 0 0015 17/09/2013 7/11/2013 1 I've tried for example a filter or a calculated column: DATEPART(StartDate)<=MDY(10,31,2013) AND DATEPART(EndDate) >= MDY(10,1,2013) for October 2013 But it does not work. The query returns empty. Is that someone would help me? I am a novice... Thanks in advance! Beresh using SAS EG 4.1
... View more