If there are unmapped categorical items in a geomap, the info or warning icon will display a message similar to: 2 of 13 regions were not found.   It would be more useful if this listed the first 5 or 10 regions that did not map. Similar to the behaviour in the Edit Geographic Item dialogue :    ... View more

During the recent delivery of the SAS Visual Analytics 8.3: Basics course, I did a demo highlighting how Data Views can now be used to provide a "business layer" between the CAS Table and the Report, which would be used as the basis for future reports.   The functionality is great but, as far as I can tell, the only way to determine if there is a view associated with a CAS Table is to add the data source to a report, then click Data Options and select "Data View..." from the menu.   Suggestion(s):   Minimum: If there ARE data views, indicate how many in parenthesis beside the Data View... menu option in VA.  e.g.  Data Views (2)...   Better: Suggestion above, and change the behavior of the menu so that the Data View... option is disabled if there are NO data views associated with a selected data source (similar to how the Data Source Filter only shows Edit/Delete Data Source Filter options if there are data source filters currently in effect.   Ideal: Both of the above techniques, plus an indication in the Manage Data application and the Add Data Source dialog box within VA, which allows expanding the Available list for tables with Views, to see the views.  If clicked, the Details shows the structure of the view (Sample Data and Profile would disappear).         ... View more

On Viya you have the possibility to sort the data of a table through the custom sorting. But this has a limitation in case the data are so many. Among the requests I need to sort the data in a very specific order. In the database I have an attribute composed of numerical values ​​that represents the order in which I have to display the elements of the table. In the normal table, thanks to the possibility of inserting this attribute as a hidden element, it allows me to sort the table elements for that element, but as far as the crosstab is concerned this is not possible and it is very complicated being a noteworthy database items using custom sorting. Previously, the elements were followed by a numerical value, thanks to which the sort took place naturally without being modified. For the purposes of illustrating the data, this numerical value was removed, with the sole purpose of showing the ordered data, and the only solution is to use the custom sorting or it would be optimal to be able to insert a hidden element for the crosstab tables.   ... View more

Hi All,  Just a request, it is possible to display user last login date/time as the attached pdf? It is requested by customer due to compliance policy. Cheers. Regards, Kian Sin ... View more

Hi Team, I tried searching but was unsuccessful so posting as an idea, please let me know if it is already implemented.   Using a button bar or a list control to be able to pick columns(measures) that should be displayed in the same crosstab.   For example, if I select "Revenue" all columns starting with REV_ (or containing rev in column name) only to be displayed in the crosstab/list table.   It is similar to what I want to show using a data step-  data a; set x; keep rev_:; run;   Something around this would be useful to save columns displaying null/missing when using controls. ... View more

Whilst you can see history of what users have connected to Visual Analytics via the Usage Reports or by searching metadata logs, there is currently no way to see what VA users are connected in real time.  This feature would be beneficial in working out what user might currently be maxing out the server for example. ... View more

Hello,   I've been using SAS VA 7.4. One of the major issues in using VA is the lack of two-way interactions between report objects.   Lets assume I have a scatter plot and list table in the same section. I would like to be able to select one or several points from the graph and brush/filter them to the list table and vise versa: by selecting a row or rows on the list table I'd get the selected observations (or subjects) highlighted in the graph.   Also I would like that these interactions (brushing or filtering) would be supported between sections.   (I usually have multiple tables which include an ID variable, so solutions which depend on the data being in the same table are, at least for me, inadequate.) ... View more

At the moment, it is possible to create a single connection to a single LDAP server and in that connection, 2 queries, a single query for users and a single query for the groups.   In the past, the User Bulk loading could allow an array of queries, for both the users and the groups, and also a certain pagination based on number of observations or based on alphanumeric order and you could split the queries.   It would be really nice and useful in SAS Viya, especially in SAS Visual Analytics environments, where it is expected a usage of thousands of users per organisation , the possibilities to:   Create multiple queries, for users and for groups, having different baseDNs and to split internally those queries in additional queries, based on number of observations and/or starting letter (alphanumerical)   ... View more

I collect usage data for a server, including the amount of CPU time used by processes. I'd like to analyse this in Visual Analytics, using the CPU time as a measure. Currently, the only way to do this is to create a calculated item where the time is converted to a number of seconds, as date and time variables are only treated as categories. This makes sense for discrete dates and times, but not elapsed times. It would be really good to allow elapsed times as measures. ... View more

It would be useful to have the option to choose colors not only based on the strength of the correlation but also on its sign (negative/positive). This way it would be possible to know the type of correlation without moving the cursor on the specific box. For instance, a strong  negative correlation could be assigned an intense color and a strong positive correlation could be assigned a different intense color, both gradually fading to a neutral color (like gray) where there is no correlation.. Thanks Carlo  ... View more

Hi, when you use Tables and cross tables in VA 7.1-7.3 there is always an empty column at the end and also empty rows that you cannot remove. Customers are very bored of this and frequently they don’t want to use anymore VA. Also there is a problem with the resize of objects: with different resolutions the work area doesn’t scale well the objects but only the box that contain the canvas objects. This is very annoying because appears some scrollbars in each object: it isn’t normal, because at maximum of acceptable the scrolling would be on the visualization area. It can be ok in designer, but not in viewer. Another point is the dinamic Id assigned to the DOM objects in HTML5: if it changes in every refresh of the visualization area the stored process cannot catch it...... ......and the last, please give us the possibility to use the stored process with a precise layout. ... View more

    The desire change should be the possibility to use two variables "start selection and end selection". So it can selecter by default the last month, and still have the max and min date   See also post: https://communities.sas.com/t5/SAS-Visual-Analytics/Time-slider-with-dynamic-selection-for-last-month/td-p/357090   Example TIme slider is from 1 jan 2015 till 1 jan 2020, but it should select per default the last month calculated field  1 = Today() = 15 november 2017 calculate filed 2 = today() - 1 month. 15 oktober 2017   (Current date 15 november 2017) 1 jan 2015-------------------------------slider------------------------------------------------------1 jan 2020               15 oktober 2017------dynamic selection--------15 november 2017   SAS Va 7.4   Best Regards, Patrick Posthuma The Netherlands ... View more

At the moment it's not possible in SAS Visual Analytics to calculate the t-distribution based confidence interval for the mean of a given sample using t-quantiles (depending on samplesize/degrees of freedom and confidence level).  It's only possible to calculate the confidence level based on assumption of normal distribution (using fix z-quantile values) of the mean which is not appropriate if the standard deviation of the population is unknown and has to be estimated by the std.dev. of the sample. Obviously there is a function in SAS called TINV(df, alpha) but it's not available in SAS Visual Analytics. We hope that you will include this basic function in inferential statistics in SAS Visual Analytics.   Thank you in advance and kind regards   Nicolas Matzinger Dipl. Natw. ETH Statistik/EDV   Post CH AG Geschäftsbereich E-Health Baumackerstrasse 46, 4. OG  CH-8050 Zürich ... View more

When distributing reports via a scheduled distribution it would be helpful to have an image of the front page of the dashboard embedded in the email, similar to the way it is sent when emailing the dashboard manually.  This would allow viewers to see the most important information quickly in their inbox rather than requiring them to click through to a link, to log in, and wait for the report to open. ... View more

SAS Visual Analytics v7.3   Single colour Arrow Indicators in VA would be an important addition to reporting where the level of increase or decrease is key.   An ‘Indicator’ showing just one colour, rather than the multiple colour ‘Gauges’, would greatly enhance things such as 'Year on Year' reporting, where there is no set target.   Single colour arrows; green up, green down, red up and red down        Traffic Light Indicators are shown on the support page (Output tab): http://support.sas.com/kb/36/180.html However, traffic lights and arrows are not currently available in VA. ... View more

In SAS VA when you add a rank to display the top 3 brands of cars - you get it. When you then add a second rank to get the top 3 of a second element, it does not yield the correct results, but rather treats this as though it was its own rank, rather than a sub rank of the 'cars' rank.   Please add a multiple level rank ability, so that in tables we can show the top n of the top x.   Thanks,   Happy to add more detail / screenshots to clarify message if needed. ... View more

When accessing help internet explorer is launched to access help online.   SAS Support say "I can confirm that the behaviour you are seeing is expected and by design. Please note that the help of some of the procedures point to a specific User's Guide, such as the SAS/STAT User's Guide in the case of the GLIMMIX procedure, and these User's Guides are not part of the offline help files that are installed on your computer. Thus, it is not possible to prevent these from being redirected to the SAS Documentation website."   There are many circumstances when working offline is essential or simply the only option due to lack of internet coverage. The change to online help from locally installed help is a regressive step which limits the functionality of SAS. ... View more

Please add an autosave feature in SAS Visual Analytics while you are in Report Designer.  If your session times-out while you are creating the report, you lose all of your work that hasn't been saved. ... View more

Text analytics in SAS VA can be applied only to English or German text. Since text analytics in SAS VA seems to be targeting social media this is not usable in real world scenarios within organizations with primary language different from English or German. ... View more