Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Adding Dates to headers or titles

Accepted Solution Solved
Reply
Contributor
Posts: 24
Accepted Solution

Adding Dates to headers or titles

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


Accepted Solutions
Solution
‎07-22-2015 06:18 PM
Occasional Contributor
Posts: 8

Re: Adding Dates to headers or titles

Posted in reply to dstephens22

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

View solution in original post


All Replies
Contributor
Posts: 38

Re: Adding Dates to headers or titles

Posted in reply to dstephens22

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

Occasional Contributor
Posts: 16

Re: Adding Dates to headers or titles

Posted in reply to dstephens22

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

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

Contributor
Posts: 24

Re: Adding Dates to headers or titles

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.

Solution
‎07-22-2015 06:18 PM
Occasional Contributor
Posts: 8

Re: Adding Dates to headers or titles

Posted in reply to dstephens22

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

Contributor
Posts: 24

Re: Adding Dates to headers or titles

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

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 5 replies
  • 1274 views
  • 0 likes
  • 4 in conversation