Identifying data where month is not equal to specified month

[STRookie]

Hi there,
I have a table with a column of dates in which I need to identify and isolate those dates that are NOT in Septemer. The data is formatted as num Date9.
NIPR_EXP_DT1
8/31/2012
2/20/2012
9/18/2013
9/10/2013
9/10/2013
9/10/2013
9/5/2013
9/13/2013
6/30/2012
9/9/2013
Any help will be greatly appreciated!
Thanks!

 

[sasbobi]

take the date variable and use if condition to filter the data

 

[kdt82]

Hi STrookie,

The month function will return the integer month from a SAS date. So you can subset for dates not on the 9th month:

*display dates not in September(month 9) ;
if month(nipr_exp_dt1) ne 9 ;