topic Re: Printing max date in SAS Visual Analytics

Printing max date

Filipvdr — Wed, 15 Apr 2015 07:22:16 GMT

Hello,

In my dataset i've got a date field which represents the date of the ticket.

I want to show on top the max date, so the users will know which was the last refresh date.

Any suggestions?

I tried with a stored process, and this works, but when printing the report in PDF, it uses a whole page for the stored process.

Filip

Re: Printing max date

MichelleHomes — Wed, 15 Apr 2015 07:41:00 GMT

Hi Filip,

If you are using SAS Visual Analytics 7.1, have you tried to create a parameter and use this?

You may find this blog post useful to see how parameters can be used - http://blogs.sas.com/content/sgf/2015/01/29/using-parameters-in-sas-visual-analytics/

Also there has been some other posts on parameters you may find helpful such as https://communities.sas.com/thread/63739 You may find other posts if you search within the Visual Analytics community.

Kind Regards,

Michelle

Re: Printing max date

Filipvdr — Wed, 15 Apr 2015 08:13:26 GMT

Hello Michelle,

Thanks for the reply, but I can't really see how this can be usefull.

I'm using 7.1 and i'm trying to send a summary report by mail. But i want it to include the last refresh date. So no user interaction is possible.

When i select a parameter, i can only select char, or numeric. No dates.

Filip

Re: Printing max date

MichelleHomes — Wed, 15 Apr 2015 09:21:40 GMT

Hi Filip,

Yes parameters cannot be dates. I was thinking you could use functions to convert it to a string so that it is a formatted date as a character. Then you could use it in a text input control box with no interaction so that the date appears in the box. I'm not sure whether a parameter can be within a text object so this is an alternative.

Let us know how you go.

Kind Regards,

Michelle

Re: Printing max date

Filipvdr — Fri, 24 Apr 2015 07:48:09 GMT

Hello,

Thanks for the input. I have created a small table with 2 fields: tablename, and last update date. I'm also using this table now to send if the job did run correct or not.

I loaded this into VA and i used a list table to display the last date.

Filip

Re: Printing max date

BO1 — Tue, 03 May 2016 13:47:21 GMT

Hi Filip,

I think I have more or less the same requirement as you had and I am hoping you can share some information with me 🙂

We have scheduled around 25 Teradata tables to be loaded into the LASR Server on a daily basis. Now my requirement is to create a Monitoring Dashboard where the Service Desk can see whether the data sources are loaded. Therefore I want to output the MAX Timestamp of every SAS Data Source.

Would you be so kind to elaborate on your solution? Where did you create that small table? Is the information in that table coming from SAS or from your DBMS?

Thank you in advance.

Regards Bart