Nascif_SAS Tracker

Re: Using New Calculated Data Items in Exploration SAS VA

Nascif_SAS — Tue, 05 Aug 2014 13:46:28 GMT

For this particular aggregated measure you also need a category in your visualization. That is what will indicate what the measure is being aggregated over.

So you can use it in a bar chart, for example, but not in a scatter plot.

In a crosstab, you need to specify the category as well - just the measure is not sufficient. It will give you a single value for the whole dataset, probably not what you want?

What visualization you are trying to create with it? Can you try to reproduce the ones I created above?

Re: Using New Calculated Data Items in Exploration SAS VA

Nascif_SAS — Fri, 01 Aug 2014 19:51:58 GMT

Hi there,

Which version of VA you're using? This might not have been possible in earlier versions but below is an example created with 6.4.

Re: Finding No of Days between two dates in SAS VA

Nascif_SAS — Fri, 01 Aug 2014 19:30:04 GMT

A bit of a tangent to the original question, but I think it is valuable to share. I see all the responses showing how to create expressions to address the original question - but they are being shared as screenshots. Did you know you can also share them in their Text version - which not only you can modify directly, as if you were authoring code or SQL, but also copy and past between VA instances?

Here is an example. I have been working on the expression below, which is similar to the ones above:

But now I will switch to its Text version. Just click on the tab at the top right of the editing area:

Next, right-click on it, select all and copy to the clipboard:

And here is the final result, as text:

( 'Open+'n NotIn ('CLOSED') ) AND ( ( Year(DatePart(Now())) - Year('Date Opened'n) ) <= 'YearHorizon'p )

If your dataset has matching columns, you can re-create my expression simply by going into a new expression editor and pasting the text above in the Text editing area. Or you can paste it and change variable names to match your data.

I even keep a file with my favorite expressions that I re-use in different reports and explorations.

Give it a try!

Re: Geomap - link different cities/countries

Nascif_SAS — Tue, 18 Mar 2014 02:19:26 GMT

Just beat me to it! 🙂

Re: Geomap - link different cities/countries

Nascif_SAS — Sun, 16 Mar 2014 23:11:16 GMT

Here is an example combining network analysis can be combined with network visualization over maps in the SAS Visual Analytics Explorer.

We will be discussing this at the SAS Global Forum 2014 in Washington D.C.

Re: LASR FULL FORM

Nascif_SAS — Sun, 09 Feb 2014 16:23:02 GMT

Hi Avinesh,

Could you be more specific? What do you mean by "full form"?

Re: How to set up a non-english Stop List for Text Analysis

Nascif_SAS — Tue, 04 Feb 2014 19:29:16 GMT

Hi Andreas,

You need also to load your new stop list in the Visual Analytics Data Builder by clicking Tools\Load Text Analytics Stop List: then accept the defaults when they come up.

Note however that currently VA Text Analytics supports only the English language. Changing the stop list won't help with that because there are language-specific features of the text analysis (identifying entities, dealing with declination, etc) that are not affected by that change.

Regards,

Nascif

Re: How might I display a PDF in VA that is stored as binary data?

Nascif_SAS — Fri, 31 Jan 2014 02:57:12 GMT

Not at all @Quentin. We are looking for ways to leverage stored processes even more in VA. Suggestions and ideas are welcome!

Re: How might I display a PDF in VA that is stored as binary data?

Nascif_SAS — Thu, 30 Jan 2014 15:31:25 GMT

VA doesn't support binary files like PDFs natively, but it can create data-driven URLs that you can leverage to display your PDFs.

I would keep the PDF files in a separate table, accessible by a stored process - or even as static files in a directory visible to your web browser.

Then on the table you will load in VA, instead of the PDF content store a corresponding unique name.

You can then use that unique name to create data-driven links in your report, that when clicked by the user will call the stored process that retrieves the file (as described by @Quentin) or directly download them as a static file.

Re: How to create a Pareto Chart

Nascif_SAS — Tue, 21 Jan 2014 16:00:18 GMT

Hi Markus,

From the UI screenshot I can tell you are using the VA Explorer. Peter's suggestion of using a Bar-Line would require you to switch to the VA Designer.

The missing piece to get a Pareto chart is to calculate the cumulative totals. As of the current release, VA can't do this calculation for generic categories; only for dates. This is something we are likely to add in a future version though.

Re: How do I edit filter in SAS VA?

Nascif_SAS — Fri, 17 Jan 2014 15:18:42 GMT

Have you tried "(Date < 1 Apr 2013)" AND (Date > 30 Apr 2013)" ?

Which version of VA you're using?