Can I merge cell in list table in a Tabular format? below is an example     ... View more

Can you tell me the detailed steps? I also encountered this problem ... View more

can you please send me the details how to do Re: Dependency between drop down list .last step i didnt understand.i am new to sas ... View more

With SAS Visual Analytics 8.5, you can use the _Full_ parameter interval to calculate over multiple years rather than year over year.       Hope this helps, Jaime ... View more

Hi,   I'd guess one could restrict the access to the table in such a way, that each user only sees his/her own row(s). And then if in the row with the name of person A in it, the specific value occurs, person A gets a message, but not all the others.   Wouldn't that be the VA behavior one can expect?   Don ... View more

To get some very helpful timings on SAS VA reports, open the report in Report Designer and then press the CNTRL, ALT and P keys simultaneously. This should bring up a window listing the timings for both the rendering of report objects and also the data queries underlying them. I see this is mentioned in the paper @JuanS_OCS references. ... View more

That is more elegant! Cynthia ... View more

Do you mean this? https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-set-default-date-value-for-a-report-using-SAS-VA-Report/td-p/405188 ... View more

Hi @Carrot17,   sorry for the late reply....   In my knowledge there is no workaround for this in SAS VA.   In simple form Tie option will work based on Alphabetical order (i.e., if  you un-check the TIE for TOP Level it will remove/hide C, in the same way if  you un-check the TIE for Bottom Level it will remove/hide B. )   Ex: Actual Data:   Name                                       Count A                                                   4 B                                                   4 C                                                   2 D                                                   2 E                                                   2 F                                                   2       For Top 5:   Name                                       Count A                                                   4 B                                                   4 D                                                   2 E                                                   2 F                                                   2       For Bottom 5: A                                                   4 C                                                   2 D                                                   2 E                                                   2 F                                                   2     Thanks, Teja Surapaneni       ... View more

Work around: Add a Text Input-control to your report. Create a parameter on this Text input (say Parameter1). Add a filter to your Dropdown-object like this: ( LowerCase('ElementName'n) Contains LowerCase('Parameter1'p) )   As the user inputs text in the Text Input-control, the possible choises in the DropDown is limited to those elements that contains the inputted text. The full list of elements is showed in the Drop Down when the TextInput is empty. ... View more

Hi Teja, Would you know how to remove the last tie value in rank? Please see example below. In that example we would like to remove the "F" but everytime we unticked the "All Ties" option "C" will be vanished. Thank in advance. example: Top 5 A 4 B 4 C 2 D 2 E 2 F 2 EXPECTATION A 4 B 4 C 2 D 2 E 2 SAS VA Result A 4 B 4 D 2 E 2 F 2 Regards, Carrot17 ... View more