topic Re: Adding Dates to headers or titles in SAS Visual Analytics

Adding Dates to headers or titles

dstephens22 — Wed, 22 Jul 2015 14:42:59 GMT

Is it possible to create and add a date to a title or heading in SAS VA? I used to use a macro with Info Maps in SAS BI. It doesn't appear to offer anything in SAS VA.

Thanks,

Dave

Re: Adding Dates to headers or titles

mariusg — Wed, 22 Jul 2015 17:45:55 GMT

Hi Dave,

what exact is a header or title for you?

A simple way is to define a new calculated item with now() or a similar function,

assign this new item to a list table and format the list table without header, so that the list table

has not the look and feel like a normal table.

kind regards from germany

Marius

Re: Adding Dates to headers or titles

Paari — Wed, 22 Jul 2015 18:43:16 GMT

You can use SAS defined system date or time as below :

title "date is &sysdate and time is &systime";

Re: Adding Dates to headers or titles

Allycat — Wed, 22 Jul 2015 22:18:24 GMT

Hi Dave,

Building on what Marius has said.

You can use some of the operators in the calculated item to create a dynamic title including the current date.

As a simple example, in the calculated item text input, you can put the following:

Concatenate('The date is - ', Format(DatePart(Now()), 'DDMMYY8.'))

That will get you a string that looks like the below when you put it in a report object:

The date is - 23/07/15

Re: Adding Dates to headers or titles

dstephens22 — Thu, 23 Jul 2015 13:47:44 GMT

Thanks for the reply Paari. I am not sure I can use this SAS code in Visual Analytics. I had hoped that was the case. Unless I am missing something.

Re: Adding Dates to headers or titles

dstephens22 — Thu, 23 Jul 2015 13:55:27 GMT

Thanks Allycat and Marius.

I have created the metric you described below, but just so I am clear: I cannot add it as a title? It would have to be part of the report? So I added it at the top of a Crosstab and it appears to be a title. Is this true or am I mistaken?

I am ok with that but would rather it be in an overall banner or the title of the report.

I appreciate your help with this.

Thank you!

Dave