topic Converting a number like 2019 from a numeric parameter into a calculated column date (YYYY) format in SAS Visual Analytics

Converting a number like 2019 from a numeric parameter into a calculated column date (YYYY) format

Hessam — Sat, 12 Jan 2019 01:08:11 GMT

Hi All

I have a numeric number like 2018 fed from a slider bar into a numeric parameter (year_parameter).

I'd like to convert the value into a date year (YYYY) format in a new calculated column and then use the new calculated column as a filter criteria for the object in my report.

Any idea how to do this?

Re: Converting a number like 2019 from a numeric parameter into a calculated column date (YYYY) form

Sam_SAS — Mon, 14 Jan 2019 13:35:59 GMT

Hello,

In 8.2 and later you can make date-based parameters, which would simplify things.

Otherwise, you can create a date value using a calculated expression like this:

DateFromMDY(1, 1, 'Parameter 1'p)

This will create values like '01 January 2018', but you can set the format of this data item to show the year only.

Let us know if this helps!

Thanks,

Sam