About don_data

don_data · ‎01-03-2019

Unfortunately, 8.2 does not have the functionality to sort by category on the axis labels.

don_data · ‎12-07-2018

Using SAS Visual Analytics 8.2 on Viya I have a stacked bar chart that can be arranged in either ascending or descending order as shown below: I, however, am in need on using a stacked chart with a fixed order. Such that for any given year, the stacked Chart will always display the stacked order in the same sequence (bottom to top) Cat-4, Cat-5, Cat-6, Cat-7, Cat-8 Is there any way of doing this?

don_data · ‎12-07-2018

Thanks SuryaKiran. However, I do not think this flexibility/ option is available in version 8.2 of SAS VA.

don_data · ‎04-06-2018

While not optimum, there is a crude workaround in 8.1. It takes a lot more effort. Approach 1: Use a measure in a list table. Use the format options to blend the cell background and remove titles. This works best on a white background. Approach 2: Use a category with a treemap. Remove the skin from the treemap in options and use display rules to blend into the background. This is a lot easier in 8.2 using the key value object. 8.2 also allows parameters to be passed through to text objects allowing for dynamic text.

don_data · ‎04-05-2018

I am looking at doing this in SAS Visual Analytics. Unfortunately, to my knowledge, the Visual Analytics module does not allow for proc codes.

don_data · ‎04-05-2018

My dataset has sales data for 3 years. For each year there are 3 records. I am interested in obtaining the sum of the maximum/ distinct values of the 3 years. Year Sales 2016 19959 2016 19959 2016 19959 2015 9201 2015 9201 2015 9201 2017 306245 2017 306245 2017 306245 Desired Result: 19959+9201+306245 = 335405 I have tried the following techniques to no avail: Technique 1: Sum (by GRoup) [Max( by Group)(Sales)] This resulted in an error as we can not perform an aggregate on an aggregate Technique 2: Duplicated sales variable and changed the default aggregate measure to MAX. Following which I ran a sum on Sales. Achieved Result: 1006215 Does anyone know of a way I can obtain my desired result?

don_data · ‎03-21-2018

Thanks. Unfortunately, I do not have a SAS/GRAPH licence. Would you be able to provide me with the alternate method. Thanks

don_data · ‎03-13-2018

Is there a lookup table for Canadian cities (eg: Vancouver, Calgary, Winnipeg) that is similar to the country lookup below: http://support.sas.com/rnd/datavisualization/va63geo/subdivs.html Thanks.

don_data · ‎03-05-2018

You may be able to leverage the LAST function.

don_data · ‎03-05-2018

While I work with the version in 8.1 and 8.2, I assume the logic would remain the same: Create a calculated field with the following logic if <field> not contains "Generator" then return <value> else return missing Missing can be replaced with 0 if preferred. In 8.1 and 8.2, there is an option to preview your result. Wherein generator exists, the corresponding result would be missing/ 0. Values would only exist where the string in the condition does not exist. Use the calculated field in the gauge. The aggregates of missing/0 values would remain 0, hence giving you the total. Note: from what I see, you may also need to put an 'AND' clause to remove values pertaining to Total Power PLant ( to avoid duplication) Hope this is what you were looking for.

don_data · ‎03-05-2018

I am working on a SAS VA 8.2 report and would like to dynamically select images based on a conditional logic. For example, if the month over month value is positive, I would the report to display an image of an upward green arrow (from a png file). If not, a negative downward arrow ( from existing png file). Is this possible in 8.2?

don_data · ‎03-02-2018

With the recent upgrade to SAS VA 8.2 ( from 8.1), I noticed that Data preparation replaced the data module builder. I was surprised to observe that the new module stripped away the GUI interface for Data Transformations. Not being a core SAS user, I am now left trying to figure out what functions ( and their respective syntax) are available for use in Calculated Columns functions. The help icon was not helpful as it took me to Data Studio's guide and to the Data Step command, which is not what I assume goes into the Calculated Columns function. Wondering if there is a list available of functions and their respective syntax?

Online Status	Offline
Date Last Visited	‎01-04-2019 06:03 PM

Re: Stacked Chart - custom order

Stacked Chart - custom order

Re: Sum of Maximum values

Re: Adding a KPI number to a report on Viya 8.1

Re: Sum of Maximum values

Sum of Maximum values

Re: Canadian Cities geographic lookup table

Canadian Cities geographic lookup table

Re: How to set default date value for a report using SAS VA Report Des...

Re: Advanced Filter for Gauge (Aggregated Measure)

Re: Adding a KPI number to a report on Viya 8.1

Re: Stacked Chart - custom order

Stacked Chart - custom order

Re: Sum of Maximum values

Re: Adding a KPI number to a report on Viya 8.1

Re: Sum of Maximum values

Sum of Maximum values

Re: Canadian Cities geographic lookup table

Canadian Cities geographic lookup table

Re: How to set default date value for a report using SAS VA Report Des...

Re: Advanced Filter for Gauge (Aggregated Measure)

Dynamically select an image based on calculated field

List of functions and Syntax for the Data Prep module of SAS VA 8.2