Thanks for update. Much appreciated. ... View more

Thanks for sharing an example value. I'm not sure I understand what you want to accomplish with your IF statement: IF (GetWord('Loan Account No'n)>0)   What would be some values that would fail this check, if it was working like you wanted it to? Are you checking for missing values, or values that would just be "0"? If so, you could check for those in a different way. ... View more

@Surya1203 wrote: Hello SAS community , By the way I am currently learning SAS visual analytics and i have two doubts to be sorted which of those are : 1) I want to known whether if i have an list table that contains around 200000 rows of values and i just want to export these table into an excel sheet .   For what very little it may be worth, large amounts of data and "Excel" are a bad combination. I've worked with this stuff since the row limit in Excel was 63K and have never seen anyone read all the rows of the exported data. If the result is to be consumed by another process then a text file like CSV is usually better as you don't need to worry about lost data from rows and most programs that accept external data will accept CSV. There may also be a benefit of not having "Excel" interpret your data into something else or a different appearance than desired. ... View more

The user will have no way of knowing if it's a percent graph or an index graph so they'd have to klick the tabs to find the graph after making the selection... This was considered but rejected. We went with displaying the unit in the graph name using a textbox with a parameter instead. Not perfect but it's something. Thinking about sending in a feature request to SAS so that you can allow a calculated object to inherit the format (and also sort order) of another object... ... View more

Here is some more detail about the solution that @acordes suggested:   As far as I can tell, this workaround will only work well if there is one row for each date in the data query. The user experience becomes very confusing if, for example, the row for 27JAN2025 contains the aggregation of 10 values in the underlying data query. (Because the calculation only compares the first and last row in the query, which would not match what is displayed in the list table in this case.)   You will need to create a filter action from the first list table to the one that displays the difference row.   If the user selects multiple rows, it will calculate the difference between the first and last row only. (As the user would probably expect) ... View more

Hello,   I think there are a lot of options to achieve what you want.   With a Text object, you could enter your commentary directly in the report. Depending on the version of VA you have, you might be able to insert dynamic text (that is, data-driven values) into the commentary in the Text object. You can make the contents of a Text object into a "Report summary" (see Creating a Report Summary ) but I'm not sure whether this is what you are thinking of.   Also in a Text object you can insert a link to an external web page or a file such as the XLS/CSV file you mentioned.   In a Web Content object, you could display the contents of a web page inline in the report.   Does this help? Sam ... View more

There can be literally hundreds of columns, so it might be an implementation challenge to have width options at the column level. But there's no harm entering a suggestion for it : ) ... View more

Wonderful, it was this one.  ... View more

Can you change its format to Float12.2, then post a screenshot of the results? Visual Analytics uses the BEST12. format by default which may not necessarily include decimals.     ... View more

Hello,   Could you tell us a little more about what you want to do?   If I understand correctly, you want to have a control where the selected student ID will select all students that have the same education level as the selected student.   I don't know that there's an easy way to do this directly, but a workaround is possible by combining the values of the two columns using the Concatenate function in a calculated item to give you something like "112 | 10th" as the value. Then you could store that in a parameter and make an advanced filter based on the second part of the value.   Here is an example using the SASHELP.CLASS dataset:   I concatenated the Name and Gender columns in an expression like this:  Concatenate(Concatenate(Name, ' | '), Gender) The syntax is slightly different in the latest versions of VA, but this should give you the general idea. I assigned a parameter to the drop-down list control to store this value. In the list table, I made an advanced filter, NOT(IsSet('Name and Gender Parameter'p)) OR (GetWord('Name and Gender Parameter'p, 2) = Gender) This will show all values if nothing is selected in the drop-down, or else filter on the part of the selected value that comes after the "|" character.   Some extra work would be necessary if you want to select all students with the selected education level or less, but it should be possible with some tedious IF statements. Let us know if that helps, or if what you wanted was something else. Sam ... View more

Can you share how your geo data provider structure looks like? If you have more than one polyline - each of these lines would get a unique identifier assigned. Given it's a line - you will need more than two rows representing the lines (minimum a start and an end point). You would repeat this for any line - each with it's own identifier. In your business data (the table used in the report) - would just carry the actual line identifiers and you would use related column when mapping the geo data provider. Assuming - those match successfully - you should be able to see multiple polylines in your geo map. If you can't get it to work - maybe share the first couple of rows representing your lines as well as an extract of your business data. If you see any warnings via the small 'i' icon in the bottom right corner of the geo map - see whether it helps to narrow down the issue. Falko ... View more