topic Re: Using System Date as Parameter in SAS Visual Analytics

Using System Date as Parameter

SAS_Explorer — Wed, 11 May 2016 13:20:38 GMT

Hi Community,

I would like to use System Date in my Report Parameter. Is there anyway wherein I can fetch system date.

I've aggregated measures which use this "System Date Parameter" for calculation, From System Date I'll be using the Year and Quarter for their calculation.

Regards,

SAS Explorer

Re: Using System Date as Parameter

pearsoninst — Wed, 11 May 2016 14:55:19 GMT

You can use the SYSDATE it is an AMV

Re: Using System Date as Parameter

BrunoMueller — Wed, 11 May 2016 15:43:49 GMT

You can get the current date using this expression:

DatePart( Now() )

This is a date that can be formatted in different ways, or used as part of a filter on date items.

Since parameters do not support a date type, you need to format the date as a char, see example below:

Format(DatePart(Now()), 'YYQ6.')

This will return a char string that can then be used as needed.

You might also have a look at this SAS Note entry http://support.sas.com/kb/58/046.html

Bruno

Re: Using System Date as Parameter

SAS_Explorer — Thu, 12 May 2016 04:53:31 GMT

Hi @BrunoMueller,

I've a tried it and its working. Can you tell me how to convert "year(category)" to year as numeric?

Regards,

SAS Explorer

Re: Using System Date as Parameter

BrunoMueller — Thu, 12 May 2016 15:39:22 GMT

Is category a date or a char variable?

The YEAR operator expects to have a date as its argument and will return a numeric.

Bruno

Re: Using System Date as Parameter

SAS_Explorer — Fri, 13 May 2016 04:01:24 GMT

Hi @BrunoMueller,

Its a Date variable, I've done by creating a calculated Item as follows:

TreatAs(_Number_, Year(DatePart(Transaction Date)))

Is there any other method to do it, plz share

Regards,

SAS Explorer