topic Re: setting filters using dates in SAS Programming

setting filters using dates

amyk — Mon, 10 Dec 2018 17:11:17 GMT

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?

Re: setting filters using dates

Reeza — Mon, 10 Dec 2018 17:12:24 GMT

@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.

Re: setting filters using dates

amyk — Mon, 10 Dec 2018 17:16:03 GMT

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

Re: setting filters using dates

Reeza — Mon, 10 Dec 2018 17:25:16 GMT

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')

Re: setting filters using dates

amyk — Mon, 10 Dec 2018 17:36:46 GMT

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!! 🙂