Date + number of month combination

ralizadeh — Thu, 11 May 2023 21:16:18 GMT

I want to write a CASE WHEN statement. I would like to use my prompt date that has an start date and end date. SAS EG will code it as "&DateRange_min"d and "&DateRange_max"d. No need to think about the end date for this question.

I want to choose those rows in my table that their dates are between "&DateRange_min"d and 12 month later.

For example if "&DateRange_min"d is 11/01/2021 then "&DateRange_min"d + 12 months should come out as 10/31/2022 (last day of that month). I need any rows between these two dates (which easily can be done with CASE WHEN statement if I could figure out the end date). I need to make sure the codes would work properly when the interval crosses the year boundary e.g. "&DateRange_min"d is in 2021, and 12 month later is another year e.g. 2022 while also taking into consideration that not all months have the same number of days in them.

I wrote the code below to first create a computed column in Query Builder that will add 12 months to "&DateRange_min"d, however I get an error. Any thought, why?

intnx(month, &DateRange_min, 12, e)

This is also failed

intnx(month, "&DateRange_min"d, 12, e)

Re: Date + number of month combination

SASKiwi — Thu, 11 May 2023 21:39:29 GMT

If you want an opinion as to why an error has happened then you really need to post the error and the code causing it from your SAS log.

Re: Date + number of month combination

ralizadeh — Thu, 11 May 2023 21:50:39 GMT

Never mind. I found why. I did not assign the prompt to the query.

topic Re: Date + number of month combination in SAS Enterprise Guide

Date + number of month combination

Re: Date + number of month combination

Re: Date + number of month combination