Display the last date of the month

[HansSteenhuis]

Hello everyone,

Is it also possible in SAS VIYA to display the last date of the month? I currently have a table with various dates and values. However, I only want to see the last day of the respective month. Is this possible in SAS VIYA?

In any case, thank you for the responses.

Regards, Hans

[BrunoMueller]

We would need more information like:

• are you writing a SAS program
• are you using Visual Analytics
• Is it the last day of the month as of today or something else

[HansSteenhuis]

thank you for your response.

I'm using Visual Analytics (VIYA). It concerns the last day of the month.

I only want to see the dates highlighted in yellow (see image).

[BrunoMueller · Accepted solution]

You can calculate the last day of the month based on some date using this expression. Where myDate is the Datum dataitem in your example. Depending on your version of Visual Analytics you can subtract a number directly from a date, otherwise you need to use the TreatAs function.

DateFromMDY(
    Mod(Month(myDate), 12) + 1
    , 1
    , Year(myDate) + Trunc(Month(myDate) / 12)
)
- 1

Once you have the new data item, you can use it in a filter to specify some like 
datum = last_day_of_month

[HansSteenhuis]

Thank you very much. It worked!

[Tom]

---

@HansSteenhuis wrote:

thank you for your response.

I'm using Visual Analytics (VIYA). It concerns the last day of the month.

I only want to see the dates highlighted in yellow (see image).

---

One simple way to test if a value is the last day of the month is to check if the next day is a different month.

In normal SAS code such a test could be :

month(datum) ne month(datum+1)

Which will be TRUE when DATUM is the last day of a month.