Thank you all for your responses !! I am using GUI in the SAS EG. If I can get the prior month date value then I know how to get the record and do the comparsion...Here is what I have. I have a booking date which is a number and I think the input function posted by KurtBremser I converted to date and the next step was to get prior month same day but I am getting a blank...I am not sure what I am doing wrong. Thank you for helping me out !! BOOKING_DT put(t1.BOOKING_DT,8.) input((put(t1.BOOKING_DT,8.)),yymmd8.) intnx('month',(input((put(t1.BOOKING_DT,8.)),yymmd8.)),-1,'same') 20140717 20140717 20140717 20140808 20140808 20140808 20140904 20140904 20140904 20140910 20140910 20140910 20140918 20140918 20140918 20141013 20141013 20141013 20141107 20141107 20141107
... View more
