topic Re: Display the last date of the month in SAS Visual Analytics

Display the last date of the month

HansSteenhuis — Mon, 30 Sep 2024 08:36:32 GMT

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

Re: Display the last date of the month

BrunoMueller — Mon, 30 Sep 2024 08:38:14 GMT

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

Re: Display the last date of the month

HansSteenhuis — Mon, 30 Sep 2024 08:51:05 GMT

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

Re: Display the last date of the month

BrunoMueller — Mon, 30 Sep 2024 09:11:56 GMT

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

Re: Display the last date of the month

HansSteenhuis — Mon, 30 Sep 2024 09:54:37 GMT

Thank you very much. It worked!

Re: Display the last date of the month

Tom — Mon, 30 Sep 2024 16:17:07 GMT

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