setting filters using dates

[amyk]

I am trying to set a filter using  dates: 

if build_mn  < sold_mn - 3 then do ;
...

...

end ;

It is grabbing all the records and not filtering. I think I am using the sold_mn - 3 wrong. 

Can someone help me with this?

[Reeza]

---

@amyk wrote:

I am trying to set a filter using  dates: 

if build_mn  < sold_mn - 3 then do ;
...

...

end ;

It is grabbing all the records and not filtering. I think I am using the sold_mn - 3 wrong. 

Can someone help me with this?

---

What are you trying to do? You've shown non working code, but not explained what you think it's doing or what you want it to do.

[amyk]

I want to set a flag if the build month is 4 months less then the sold month then set flags. 

[Reeza · Accepted solution]

Assuming you have SAS date variables, numeric with a date format, you can use the INTNX() function to increment a date. Look at the fourth parameter that will increment a date to either the same day of the month, end or beginning so that your comparison is what you want.

Something along these lines, you'll need to set the parameters for what you need:

build_mn < intnx('month', build_mn, 4, 'e')

[amyk]

Thanks that helped. 

I ended up using it as follows:

build_mn le intnx('month', build_mn, -4, 'e')

It gave me exactly what I was looking for. Again thank you so much!! 🙂