I am not sure if the title is accurate. Here is what I am trying to achieve and hope some of you can help.
I have my source loaded from an excel file with the following data:
|Project||Software 1||Number of copies||Software 2||Number of copies||Software 3||Number of copies|
I would like to be able to show the above data using a pie chart to show the number of copies.
The software name is dynamic.
Hope the problem is clear.
Thank you very much for your help.
This is doable directly in VA designer, but the easiest way would be manipulate the data structure to better support vizualisation.
If you want to do it with this data structure here's the steps that I did.
IF ( 'SW1'n NotMissing ) RETURN 'SW1'n ELSE ( IF ( 'SW2'n NotMissing ) RETURN 'SW2'n ELSE 'SW3'n )
( IF ( 'Number of copies 1'n NotMissing ) RETURN 'Number of copies 1'n ELSE 0 ) + ( IF ( 'Number of copies 2'n NotMissing ) RETURN 'Number of copies 2'n ELSE 0 ) + ( IF ( 'Number of copies 3'n NotMissing ) RETURN 'Number of copies 3'n ELSE 0 )
I hope this helps.
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.