I am using bar chart for representing the patients in SAS VA. In the data, I have only 1 patient. How ever, the values on the Y-axis have 0.1, 0.2, 0.3.. and so on till 1 which does not make sense for persons. I tried to change the options by setting the minimum and maximum value. But, does not look nice because we could not predict how many maximum patients are available in the future.So, any other options, how to represent the values as only positive integers.
thank you for replying. Here is the screen shot of the chart I am trying to achieve.If you see the bar chart on the right bottom, I have values 0.0. 0.5...2. But, instead I want them to 1, 2 ..and so on. I am not sure how to achieve this. Since this is aggregated value, I could not change the aggregation.
If I understand correctly, the issue that you want to address is the value labels of the tick marks on the Y axis, rather than the actual data values in your plot.
Because the values for your DistinctPatients measure are integers, the tick marks on that axis should also be integers. That makes sense to me, but I'm not sure how to accomplish it.
If it is any consolation to you, this issue should go away when you have 4 or more distinct patients.
My expertise is with the Explorer, so hopefully someone else can help.
I'm not sure if this solves the problem, but in the custom graph builder you have the possibility to choose "only show integers" in the properties for the Y-axis..So maybe you could try and build the bar-chart in the graph builder and see if it solves your problem?
unfortunately its not having the effect. I created a bar chat as mentioned but when viewing the report, I have 0.5, 1.5 values for patients . When designing the report it looks like when it take only integers. But when I view the report its again displaying the mid values as well.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.