Hi Teja, SAS Office Analytics is the bundle of SAS products as listed SAS Office Analytics. This allows users to open/interact/refresh SAS VA Reports within Microsoft Office products and SAS Enterprise Guide as we have discussed in another thread, Kind Regards, Michelle ... View more

Hi, Yes it is possible to convert a numeric in the format YYYYMMDD to a SAS Date using SAS Visual Analytics Data Builder. Here is a screenshot of the expression that you would need to use (I am using the date column in the TEST table) Which produces the SAS date column you are after... Kind Regards, Michelle ... View more

Hi Sarthak, If you have created an aggregated data item within SAS Visual Analytics Designer and saved it in a report, then it is only accessible via the report. I see a couple of ways to overcome this... 1) You could create the aggregated data item within a query using SAS VIsual Analytics Data Builder and load the table into the SAS LASR Server so then the aggregated data item is available for all reports your different users want to create. 2) Create a template report where you have all your data item properties defined, hierarchies, geographics, aggregated data items, calculated data items etc and save this as a "setup" type report. Your users can use this report as the starting point for their reports, ensuring they Save As and don't overwrite it. Kind Regards, Michelle ... View more

Hi Marius, As you have discovered this feature of custom shape/boundary files wasn't added in the SAS Visual Analytics 7.1 release. It would be good to know whether this is on the roadmap still as I was asked about this today too. Kind Regards, Michelle ... View more

Good point Peter! ... View more

Hi mad_scientist, I did a high-level presentation on metadata at a SAS Western Australian user group meeting a couple of years ago that you might find helpful. I gave the analogy that metadata is like the blood traveling through your body... https://www.metacoda.com/en/2013/07/metadata-wasup-presentation/ It is the ability to share information between other components in the SAS Intelligence platform. There is more to metadata than tables, libraries and macro definitions/stored process prompts. As described at SAS(R) 9.4 Intelligence Platform: Overview - SAS Metadata Server, "the SAS Metadata Server is a multi-user server that enables users to read metadata from and write metadata to one or more SAS Metadata Repositories. This server is a centralized resource for storing, managing, and delivering metadata for all SAS applications across the enterprise." The page outlines what type of content is stored in metadata. Please note this list is a partial list as doesn't include objects from SAS solutions and newer products such as SAS Visual Analytics Explorations, Reports, Queries etc... Having a VA Report stored in a centralized metadata repository governed by a SAS security metadata model means those users who have access to it can view it in a SAS client they have access to, such as SAS Visual Analytics Designer, SAS Mobile BI app, SAS Enterprise Guide, SAS Add-in for Microsoft Office clients. In looking at your questions 1  As a programmer, what are the benefits of registering tables in Metadata ? I thought all SAS table metadata is available through DICTIONARY/SASHELP, which doesn’t require registering the table... Yes SAS table metadata is available through dictionary tables however the ability to have lineage or an understanding of what reports/stored processes etc use a particular column or table is what having a table registered in metadata provides. Also the ability to have security on the table. 2  What actual macros/ PROCs / statements do I use to get the above benefits that I can’t get through DICTIONARY/SASHELP ? If you are after technical information about how to use SAS metadata programmatically there are a number of ways. This 2008 SAS Global Forum paper might give you some ideas - Metadata for SAS 9 Programmers 3 What’s the point of the SAS mgmt. console – why aren’t all tables automatically registered in Metadata ? SAS Management Console and also the SAS Environment Manager are clients which allow you to manage the SAS metadata stored in the SAS metadata repository. This repository stores logical data representations of items such as libraries, tables, information maps and cubes thus ensuring central control over the quality and consistency of data definitions and business rules. The repository also stores information about system resources such as servers, the users who access data and metadata, and the rules that govern who can access what. Note it is a logical representation which may be different to the physical. Hope this helps... Kind Regards, Michelle ... View more

Yes! here's a useful matrix for SAS server versions and SAS Enterprise Guide 34960 - SAS® Enterprise Guide® support matrix Kind Regards, Michelle ... View more

The output you are seeing is the expected behavior of a crosstab report object. Without a measure data item in a crosstab, the cells represent the frequency of the X/Y combination. If you are wanting to see an X instead, I would suggest implementing a workaround by having a measure in the crosstab and define a SAS user-defined format on the measure such that values greater than 0 are a 'X' and values less than or equal to 0 are ' ' (a blank). You can create a SAS user-defined format using PROC FORMAT as described at Base SAS(R) 9.4 Procedures Guide, Third Edition - PROC FORMAT and information on how to set up your VA environment to use SAS user-defined formats can be found at SAS(R) Visual Analytics 7.1: User's Guide - Work with User-Defined Formats Let us know how you go. Kind Regards, Michelle ... View more

Hi Jackie, The idea of a template is to have the data item properties set up for standard use so that you use this as a basis for starting a new exploration or report. Create the geographies, hierarchies, formats, new calculated items, shared display rules, custom categories/colors, filtersetc Save it in a read-only folder and this exploration or report becomes the starting point for your content developers when they want to build explorations, reports and dashboards. Kind Regards, Michelle ... View more

Thanks for the screenshot. Such a shame that the show data labels is only for the top of the bar not the segments within in and you need to hover over to get the values via a tooltip. It does appear the feature you're after is missing. :smileyplain: Kind Regards, Michelle ... View more