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

Great! Glad to help 🙂 ... 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 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

Hey,   Me too ran in to the same issue. Did you find any work around? It try to create a text box with fill unfortunately that didn't work too.   ... View more

Hi Abhishek,   I tried your solution but still have one problem. Maybe you can help me out with this last issue.   I have a "list filter month number1" that is filtered by the present month indicator as you mentioned. Also this "list filter month number1" filters a second filter "filter month number2". "Filter month number2" filters the object.   The "filter month number 1" does not change immediately  into the new month (for example last 1 december) as the present month indicator changes. It still gives the old month (november) and the user has to click the filter to change it into (december).  If the end user still has to click the filter that he/she can also use a 'normal' filter and choose the last month.   How to make sure that the end user does not have to click the first filter?     ... View more

What is an alternate way to do this?  I'm working with two pie charts and would like the interaction to exist between the two.  Right now if I do an interaction from pie chart 1 to pie chart 2, it works great.  However, I want to also have an interaction from pie chart 2 to pie chart 1.  I'm in version 7.3, looking for suggestions on how to accomplish this. ... View more

I have gone through the link which you have suggested, It’s regarding External URL Link. I am not able to use this for my requirement .   I have created 10 reports and based on requirement each report has multiple sections. I have created one Lookup table with 10 records (different combination of Parameter value). Now I want to use this lookup table in Main report for call those 10 reports. I can’t display lookup table on main report. Once all parameter fill by controls (like drop down) on Main report I want to call particular report ( link) .   I am not able to create link between Main Report, Lookup Table & Target Table. I hope you understand my requrement.   Regards, Anand ... View more

Hi svobodova_v, Base SAS has a NLMNICZK format, but it doesn't appear that the CURRENCY format in VA will output values in CZK. 😞 I tried it with my locale as Czech and I was surprised to see that the format names are localized. So if you are using the Czech user interface, the format I am talking about is apparently "Mĕna". ... View more

Here is an additional approach that we came up with to solve the 'report header' issue.  This solution uses a calculated data item (Report Description) created in the designer that makes use of the concatenation and format operators.  The formula in text mode is here: Concatenate('Report is for this period:  ', Format('Date by Month'n[Raw], 'MONYY5.')) The report example includes a list table object that displays data for periods.  A period is selected using a drop-down list.  A button bar is incorporated to display the header text.  Interactions are defined between the drop-down list and the list table and the drop-down list and the button bar.  I have attached screen shots of the report in viewer mode, the calculation of the Report Description data item, the button style, roles, and properties, and the interactions. I hope this solution will be useful to you.   ... View more

  Error while opening a report This is commonly happening in most of the environments.  So to resolve\overcome this issue, you need to import the same table\dataset again. Then open the saved reports.  It should work if you didn't save the reports when you got an error.   Thanks & Regards, Venu Murala  | Sr. SAS Consultant, USA. ... View more

And some basic messages from the SAS Management Console.  ... View more

Hi anandsasbi, I dont think its possible in list table. ... View more