topic Re: adjustable intervals in a bar chart in VA in SAS Visual Analytics

adjustable intervals in a bar chart in VA

YannRC — Wed, 08 Jan 2025 21:53:21 GMT

Hi,Happy new year.

I remember reading a post in this section that explained how to create adjustable intervals in a bar chart in VA. But I can't find it anymore. I want to compare the distribution of two data sets, but the histogram doesn't allow it. So I need to find a solution.

Can you help me

Re: adjustable intervals in a bar chart in VA

Sam_SAS — Wed, 08 Jan 2025 22:04:47 GMT

Hello,

Probably what you want to do is to create a custom category. https://documentation.sas.com/doc/en/vacdc/v_029/vareportdata/p15f7c1bp1vv09n1ezx5yifpg9ni.htm

You can assign whatever value intervals you want, and then create a bar chart with the custom category on the category axis and Frequency on the response axis:

Would that work for you? Let us know,

Sam

Re: adjustable intervals in a bar chart in VA

YannRC — Wed, 08 Jan 2025 22:12:02 GMT

I sam. More or less. I know that I can use custom category. But these categories are always the same.

I read a post that allowed creating intervals dynamically using calculations. For example, I could specify that I wanted a step of 5, and it would automatically create categories like 0-5, 5-10, and so on. But I can't find this post anymore

Re: adjustable intervals in a bar chart in VA

Sam_SAS — Thu, 09 Jan 2025 15:12:32 GMT

If I understand correctly, you want to programmatically make the intervals something like: (min to max by 5).

Sorry, I don't know offhand how you would do that within VA. In the most recent releases of VA you can have an expression-based parameter so that you have your min and max values in the table to work with. But I would think you'd need some sort of For/While loop to generate the intervals by 5. The VA expression language is just not that robust.

As far as I know, your best option is to pre-calculate the bin intervals as part of your data preparation.

Sam

Re: adjustable intervals in a bar chart in VA

BrunoMueller — Mon, 13 Jan 2025 08:43:22 GMT

Have a look here https://communities.sas.com/t5/SAS-Communities-Library/SAS-Visual-Analytics-Tips-amp-Tricks-Series-A-smart-and-dynamic/ta-p/908972
@KalleM has a lot of very useful tips and tricks. Check it out here https://communities.sas.com/t5/SAS-Communities-Library/SAS-Visual-Analytics-Tips-amp-Tricks-Series-Main-Page/ta-p/899113

Re: adjustable intervals in a bar chart in VA

YannRC — Mon, 13 Jan 2025 09:31:05 GMT

Wonderful, it was this one.