topic Re: Cross Tab divide one column by another in SAS Visual Analytics

Cross Tab divide one column by another

AJRowe — Wed, 27 Feb 2019 23:00:09 GMT

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?

Re: Cross Tab divide one column by another

VDD — Thu, 28 Feb 2019 00:55:30 GMT

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-data-AKA-generate/ta-p/258712

How to Add attachments
https://communities.sas.com/t5/Community-Memo/Adding-attachments-to-your-communities-posts/ba-p/464767
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/ta-p/352068

Re: Cross Tab divide one column by another

AJRowe — Fri, 01 Mar 2019 22:59:31 GMT

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