SAS Visual Analytics 7.4 Hotfix 09
I'm making a crosstab. My raw data is a result by 2 categories. 1st data column is an average of the result, 2nd column is a count of the results, 3rd column is a count of results less than a certain value (number of "failures"), 4th column is supposed to be the percentage of the 3rd column/2nd column. Basically it's a failure percentage.
For the 4th column, i made a calculated item of (column_2)/(column_3). But since I'm forced to choose an aggregation for the calculated measured value, I don't get the actual raw percentage calculation.
In case it matters, I have the report filtered for the current month/year.
How do I set up my 4th column?
Please be kind and provide information need to understand your request.
How to create a data-step version of your data
https://communities.sas.com/t5/help/faqpage/faq-category-id/posting#posting
https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat...
How to Add attachments
https://communities.sas.com/t5/Community-Memo/Adding-attachments-to-your-communities-posts/ba-p/4647...
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
https://communities.sas.com/t5/SAS-Communities-Library/Maxims-of-Maximally-Efficient-SAS-Programmers...
I figured out my problem. I didn't create New Aggregate Measures, I just changed the aggregations of data columns. When I created new aggregate measures, I was able to get calculate percentages using them like I needed.
Thanks
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.