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
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.