exclude last day of each month

Gieorgie — Tue, 21 Dec 2021 18:04:58 GMT

Hey Guys !

Is it possible to write a function to a condition, e.g. Where, which will turn off the last days of the month, ie. If the last day of December is 2021-12-31, I would like my condition not to be excluded?

	when/where datepart(t1.PRP_END_DATE) IS NOT NULL and datepart(t1.PRP_END_DATE) - &gv_date_dly. >=0 and ( function ) THEN 'A'

for example like a below : ?

     ,intnx('month',datepart(t1.PRP_END_DATE),-1,'e') format=yymmd7. as POLICY_VINTAGE,

Re: exclude last day of each month

PaigeMiller — Tue, 21 Dec 2021 18:27:10 GMT

I would imagine something like this would work

where your_date_variable ne intnx('month',your_date_variable,0,'e')

topic exclude last day of each month in SAS Programming

exclude last day of each month

Re: exclude last day of each month