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

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

Just a simple function to replace   TMP=A; A  =B; B  =TMP;   with shorter and more legible   call swap(A,B);   and RC=swap(A,B); for macro use.     ... View more

It would be helpfull, if we have Multiple selection drop down list. which consumes less space and have the ability for multiple selections. ... View more

  Hi, I think that in cases  the filter .in a  SAS Visual Analytics report , don't return any matches, instead of  visualizing the yellow  triangle, It´d be better customizing a text to be shown , This will prevent the user thinking he´s got an error in the report. Greetings. Silvia   ... View more

Hi, I was exploring SAS VA, and created a crosstab section. But the moment i found that there are no data in any intersaction that row disappears from the crosstab. But our management prefers that whether there are data or not, all the rows should be there in the crosstab, either with zero or missing value. I was managed to finally do that by inserting empty rows for all the combination. But the file size becomes very big. Other software (Tableau) that our office is also exploring have this capability with a simple menu option. So, i would suggest that SAS VA should incorporate this functionality so that we can do this kind of crosstab without restructing data. Thanks Badal   ... View more

It would be really useful to have the ability within a report display rule for SAS to automatically assign colours to categorical values for a specific category. The user should be able to choose from a couple of selected palettes (warm colours, bright colours, high contrast etc.).   This would save a lot of time setting up display rules and ensure the colours are consistent throughout the report. There is already something close (see below) within the Data Explorer. ... View more

It's frustrating when you write a %macro function and/or a %do loop, and the DATA and PROC steps inside are not colored according to the usual syntax highlighting.   This was suggested as a feature back in version 9.1, but it still hasn't been fixed. ... View more

Request It is requested to enable utilization in VA of filters at report level linked one each other. Currently in VA it is possible to specify filter at report level but it is not possible to include relation between this filters Use Case/Workaround For enable to keep along different sections the same filters it was requested to include filters at report level. Beside since it is not possible to define relation between filters at report level the needs was managed with filter at section level linked properly. Technical workaround was already provided by SAS local support team Considerations Technical workaround has been already provided by SAS Support, then the request is not critical, beside it should be fine to have a standard function available also for self bi needs ... View more

The data step debugger are a practical tool for solving problems in advanced data step programs. Please make this functionality available when using Workspace Server programming clients such as Enterprise Guide and Data Integration Studio. ... View more

In SAS VA 6.3. category variables in treemaps which contain many characters show an empty line in treemaps. Instead of using substrings to limit the number of characters in advance it might be valuable to create an option which can select a certain amount of characters of the variable (for example:"1533 Maligne neoplasma colon sigmoideum" becomes "1533 Maligne neoplasma..." instead of "...") . Hence we don't have to prepare the data with substrings every time we use variables which contain a high number of characters   ... View more

In a simple stacked bar chart, such as on a graph like such: proc sgplot data=sashelp.prdsale; vbar year/response=actual group=quarter groupdisplay=stack; run; It is often desired to have the response value labeled on each stacked bar.  This can be done with annotation, but it is cumbersome and causes difficulty when using SGPANEL (for example) to combine multiple charts.  Currently, datalabels create tables on top or bottom when used with stacked bar charts, but do not overlay the groups.  Instead doing this: proc sgplot data=sashelp.prdsale; vbar year/response=actual group=quarter groupdisplay=stack datalabel datalabelpos=center; run; or something like that would be simple, and as the data tip already contains this information, this should not be complex to implement. ... View more

ODS MARKUP: add the ability to modify the worksheet tab colors with the ExcelXP tagset ... View more

Hi, Two variables of the same name are used in a merge without being listed in the by statement is usually unintentionnal (usually done by mistake). As far I'm aware of, the only way to be informed about it is to display information messages in the log using options msglevel=i;. But That option is not in the default setting. The message is not really easy to notice (black color) and not listed in the interface         Other messages which are usually not that relevant popup on the way with this option. Would it be possible to have a global option called for example mergeoverwrite= (or any other relevant name) with WARN by default (as VARLENCHK=)?   data one; key=1; x=1; output; key=2; x=2; output; run; data two; key=1; x=5; output; key=2; x=6; output; run; *options mergeoverwrite=WARN; options msglevel=i; data demo; merge one two; by key; run;   ... View more

I suggest the creation of additional methods for hash objects which provide the capability to first "position" a pointer in the search tree (e.g. hash.pos_key()), even if the key is not found, and then find the next key in the sorting sequence (hash.next_key()). The second method should have an option to search "up" or "down", the default being "up". The first method will always return a zero, while the second method will return a non-zero return code if the beginning (while searching "down") or the end (while searching "up") of the hash has been reached. Multiple entries for a given key should be treated as one.   ... View more

It'd be useful that the null device existed to access the null device of the OS, so we don't have to test whether nul (DOS) or /dev/null (Unix) are to be used.   ... View more

Adding the median to the periodic functions in VA would enable simple and effective median percentage growth capabilities. Since the mean and median are usually unequal in 'real world' data, this would be a huge add and time saver. ... View more

Enough with all the crap with wrapping text automatically in ODS!    Just let us shut it off with something SIMPLE like WRAPTEXT=OFF!!! ... View more

When switching between the CODE / LOG / RESULTS tabs in SAS Studio, it would be nice when clicking on the CODE tab (with the mouse) to always change the cursor focus to the actual editor window.   Currently after clicking the CODE tab, you need to click down in the editor window in order to start interacting with it.  The problems with this are:   If you forget to click in the editor window and press an arrow key, it changes to a different tab If you click in the editor window, whatever was previously highlighted is deselected If you forget to click in the editor window and start typing, you realize you forgot to click and need to move your hand BACK to your mouse and then back to the keyboard, ugh.     ... View more